Oracle Linked server from sql server 2005

• Daniel Warne

  Old Hand

  Points: 339

  More actions

  January 14, 2009 at 3:23 am

  #198476

  Hi

  I've am trying to set up a linked server from sql server 2005 to an oracle server in order to run queries and am receiving the following error.

  OLE DB provider "MSDAORA" for linked server "*******" returned message "ORA-06413: Connection not open.

  ".

  Msg 7303, Level 16, State 1, Line 1

  Cannot initialize the data source object of OLE DB provider "MSDAORA" for linked server "*******".

  This is the query i am running:

  select * from OPENQUERY(*******, 'SELECT id FROM = ''QT''')

  The SQL Server is a Windows 2003 Standard 64-bit edition SP2. The SQL edition is SQL Server 2005 Standard Edition 32-bit SP1. The oracle client is edition 10 and is also 32-bit.

  Can anyone help?

  Cheers

  Daniel

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  January 14, 2009 at 6:35 am

  #926522

  Does a TNSPING return the correct results when executed?

  Have you attempted logging in using SQLPLUS to the Oracle database using the credentials that you are using for the linked server?

  ---

  
  Shamless self promotion - read my blog http://sirsql.net

• Daniel Warne

  Old Hand

  Points: 339

  More actions

  January 14, 2009 at 6:56 am

  #926541

  yes

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  January 14, 2009 at 7:08 am

  #926551

  Could you provide a list of the providers (drivers) installed on the server?

  ---

  
  Shamless self promotion - read my blog http://sirsql.net