Error when Expand Tables for Oracle Linked Server 64 bit

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  July 15, 2012 at 10:44 am

  #392751

  I ran a script to create a Linked Server, however I was obviously not correct.

  Cannot initialize the data source object of the OLE DB provider "MSASQL" for linked server. (Microsoft SQL Server, Error: 7303)

  I'm looking for a solution to this problem but I have not found one yet.

  Does anyone have a link to step by step instructions with screen shots?

  Thanks.

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  July 15, 2012 at 11:05 am

  #1512887

  I found a solution at the following URL:

  http://stackoverflow.com/questions/307636/how-do-you-setup-a-linked-server-to-an-oracle-database-on-sql-2000-2005

  EXEC sp_addlinkedserver

  @server = '{Linked Server Name}'

  ,@srvproduct = '{System DSN Name}'

  ,@provider = 'MSDASQL'

  ,@datasrc = '{System DSN Name}'

  EXEC sp_addlinkedsrvlogin

  @rmtsrvname = '{Linked Server Name}'

  ,@useself = 'False'

  ,@locallogin = NULL

  ,@rmtuser = '{Oracle User Name}'

  ,@rmtpassword = '{Oracle User Password}'

  [/code]

  I wondered why the OraOLEDB.Oracle Provider was not specified?

  I would think that it would be faster?

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/