SQL Server: Creating Linked Server with Oracle
So far I have used two ways to create linked server with Oracle. By 1. MS OLE DB Provider for ODBC Driver 2. OraOLEDB.Oracle Provider For first one steps are like [this actions will be done where the sql server resides. assume oracle db is in remote machine] 1. Install Oracle Client with all options. 2. Reboot the machine (not sure mandatroy or not) 3. Go to tnsnames.ora and note the oracle database info you want to connect 4. Create a system DSN name through adminsitrative tool --> Data Source --> System Driver --> Add new [configure and test it oracle user name and password] 5. Right Click of Provider MSDASQL in SSMS->Server Objects->Linked Server and check the box "Allow In Process" 6. Now open SSMS and put the below queries exec master . dbo . sp_addlinkedserver @server = N'TEST2ORACLE' , @srvproduct = N'DSN_NAME' , @provider = N'MSDASQL' , @datasrc = N'DSN_NAME' exec master . dbo . sp_addlinkedsrvlogin...