Scribd
Upload
41 views11 pages

Connect MSSQL to Oracle via ODBC

To connect MSSQL from Oracle using Windows ODBC, create a new data source by going to Control Panel and opening ODBC. Then install Oracle Express and create an initdg4odbc2.ora file in the hs/admin folder, changing the listener and tnsnames.ora files before restarting the listener.

Uploaded by

ssmohanta
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
41 views11 pages

Connect MSSQL to Oracle via ODBC

To connect MSSQL from Oracle using Windows ODBC, create a new data source by going to Control Panel and opening ODBC. Then install Oracle Express and create an initdg4odbc2.ora file in the hs/admin folder, changing the listener and tnsnames.ora files before restarting the listener.

Uploaded by

ssmohanta
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

MSSQL Connection from Oracle using Windows ODBC

1. Go to Control Panel

2. Open ODBC
3. Create Data Source
4. Oracle Express Installation & Create [Link] in hs/admin folder
Change Listener as follows
Change [Link]
Restart [Link]

You might also like