Ora file, thentication_services (NTS names.
Exe: Set your TNS_admin variable to the full path of the relevant folder?).
Instructions for Adding the Environment variable TNS_admin in windows xp service pack 2 (sp2) cd key windows.
Cannot initialize the data source object of OLE DB provider "msdaora" for linked server "linked_ORA".Ora file: orcl (description (address (protocol TCP host ravi port 1521) (connect_data (server dedicated) (service_name m) ) ).OracleDB_Dev (description (address_list (address (protocol TCP host m port 1521) ) (connect_data (service_name OracleDB) (server dedicated) ) in the above tnsnames.However 64-Bit oledb Provider for odbc (msdasql) is already there in Windows Vista/Windows Server 2008 and later.NEW- StringValue and name it TNS_admin and give the value Note: This is not a must but in some cases this is what fixed the issue.I have oracle server 11g installed on my windows 7 machine.Steps to Take, verify that the correct port is specified.Create an environment variable TNS_admin that points to the directory where your tnsnames.Service Name: OracleDB (Actual Oracle service name instance name in SQL).Ora file Alias OracleDB_Dev.Below is a list of things that you can try to resolve this issue.How to set up and troubleshoot a linked server to an Oracle database in SQL Server m/kb/280106, net framework 4.0 features codeproject also make sure visual studio 2010 with key you have installed Oracle Client on the SQL server.Handler(s "dedicated" established:0 refused:0 local server.Ora file in your client home.Verify if you can connect to Oracle from the SQL server machine using tools installed with Oracle Client For example "SQL Developer" or SQL Plus with the same user id/password or TNS alias.Check if SQL server start up account has permission to the Oracle Home.If that works, then my guess is you maybe installed the Oracle client software too, and when you run sqlplus, it looks for the tnsnames.You can also create linked server using Oracle odbc driver together with Microsoft OLE DB provider for odbc.Sample Value of Environment Variable path: E:appproduct11.1.0client_1bin ;C:Program FilesBusiness FilesBusiness FilesMicrosoft SQL Server80Toolsbinn;C:Program FilesCommon FilesMicrosoft Sharedweb server FilesMicrosoft SQL Server80ToolsBinn;C:Program FilesMicrosoft SQL Server90dtsbinn;C:Program FilesMicrosoft SQL Server90Toolsbinn;C:Program FilesMicrosoft SQL FilesMicrosoft Visual Studio FilesMicrosoft Network Monitor.For general understanding of the error, you can review oracle documentation like this m in SQL Server Linked Server, it could indicate a few things (not limited to). .
Note: You can check and verify if MS OLE DB Provider for Oracle is running InProcess from the registry key.