For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hi All,
How would I connect to MS SQL Server databases from Oracle 10g Database?
I have few databases on MS SQL Server and I would like to make a connection between Oracle 10g db to MS SQL server.
My Database is Oracle 10g on HP-UX OS 11.11
Thanks,
ERROR at line 1: ORA-29278: SMTP transient error: 421 Service not available ORA-06512: at "SYS.UTL_SMTP", line 17 ORA-06512: at "SYS.UTL_SMTP", line 96 ORA-06512: at "SYS.UTL_SMTP", line 138 ORA-06512: at "ODSUSER1.DEMO_MAIL", line 205 ORA-06512: at "ODSUSER1.DEMO_MAIL", line 99 ORA-06512: at "ODSUSER1.DEMO_MAIL", line 86 ORA-06512: at line 2
SMTP Server is required to use UTL_SMTP or Demo_Mail Package. If it is available to you then CUSTOMIZE your Demo_Mail Package Specification.
CREATE OR REPLACE PACKAGE demo_mail IS ----------------------- Customizable Section ----------------------- -- Customize the SMTP host, port and your domain name below. smtp_host VARCHAR2(256) := 'smtp-server.some-company.com'; smtp_port PLS_INTEGER := 25; smtp_domain VARCHAR2(256) := 'some-company.com'; .. ..... .. .. ... .... ... ....
You can use Microsoft Exchange Server, MDaemon and many more SMTP Software Packages for that......... also there are free SMTP Software Packages are available on "Free Downlolad Websites" which you can download.
We are using Lotus notes in our office. So, we can't check what is the microsoft exchange server. Is there any other way - that i can check that one. Or if Lotus notes use any different mail sever - can you say how to view that information?
It does'nt matter that which SMTP Server you are using, what you need to ask with your system administrator is about IP Address or Domain Name of your Email Server(of any brand).
You can Ask with your Network or System Adminstrator OR you can Check your Incoming/Outgoing Mail Server IP or Dmain Name.
Also...You must know about....
Global Email Account ID (Which must be able to email to the world) from which you will send email to your mobile phone and then Customize your Package.
You can also define server IP Address in DEMO_MAIL instead of defining domain name in it.
--Customize the SMTP host, port and your domain name below. smtp_host VARCHAR2(256) := '192.168.0.1'; smtp_port PLS_INTEGER := 25; smtp_domain VARCHAR2(256) := 'some-company.com';
Or, can you give me any link from where i can download those exchange server? Any idea? Thanks in advance for sharing your thought with us.
Regards.
Satyaki De.
you can check it on http://www.download.com
Best Regards, Muhammad Waseem Haroon m.waseem@emirates.com Emirates Group I.T - Mercator
Message was edited by: Waseem Haroon