ODBC connect to Oracle in Windows 2003

• AndreQ1

  Right there with Babe

  Points: 758

  More actions

  May 27, 2005 at 4:19 pm

  #362743

  We've been migrating DTSs from a Windows 2000/SQL 2000 box to a Windows 2003/SQL 2000 box and have had trouble moving the connections to Oracle.  We installed first Oracle 9.2 and then Oracle 8.1.7 without any change.  We're able to connect via SQL Plus to each of the databases without problem, so I know everything is fine with my TNSNAMES.ORA file.  When I try to connect via the DTS using the Microsoft ODBC Driver for Oracle or Microsoft OLE DB Provider for Oracle, I get the message:

  "Test connection failed because of an error in initializing provider.  Oracle error occurred, but error message could not be retrieved from Oracle."

  I tried getting the latest drivers for both Oracle 9.2 and 8.1 without effect.

  I downloaded and installed the .NET Managed Provider for Oracle, because the Windows 2003 comes with the .NET framework.

  The DTS works on my machine, which has Windows XP Professional, and it works on Windows 2000 machine, so I suspect it has to do either with Windows 2003 or the .NET framework.

  Any suggestions?  The knowledgebase wasn't that helpful for this. 

  Thanks in advance.

  Andre

• Erhembayar

  Newbie

  Points: 2

  More actions

  May 29, 2005 at 9:39 pm

  #561640

  I need SQL server pdf books,

  please

  let me know

   

   

• v_schoen

  SSC Journeyman

  Points: 80

  More actions

  June 21, 2005 at 7:30 am

  #567016

  Hi Andre,

   

  have you setup a DSN with ODBC Manager?

  Is the path $ORALCE_HOEM\BIN in your path variable?

  Try to install MDAC 2.8

  HTH

  Volker