Tuesday, May 01, 2012 4:51 PM
For my test system I am running Windows XP with SQL Server 2008 Std 32 bit installed.
I also have the Oracle Instant Client version 10.2 installed.
I can create a system DSN to the Oracle database w/out any issues.
I can connect to the Oracle database via MS Access 2003 using an ODBC connection.
I can also connect to the Oracle database using Toad.
When trying to connect to Oracle via linked server with SQL Server 2K8 there is not an option to connect with ODBC. Any suggestions would be greatly appreciated!
- Edited by DawnOfTheApes Tuesday, May 01, 2012 5:48 PM
Tuesday, May 01, 2012 7:14 PMModerator
If you have installed the Oracle client and created an ODBC DSN already, then you just have to create the linked server with the following instructions:
1. On the “General Page” select “Oracle Provider for OLE DB” as the provider and type the name of the DSN on the “Product Name” and “Data source” fields.
2. On the “Security” page, select the “Be made using this security context” option, and provide login and password for authentication to the Oracle server.
3. On the “Server Options” page set “RPC” and “RPC Out” to True.
Hope this helps.
Tuesday, May 01, 2012 7:20 PM
Thank you sir!
Friday, May 04, 2012 6:54 PM
hi please see the link given here, it may help you.