Home » Open Source » Programming Interfaces » ODBC Connection Fails connection to Oracle 10g database (Microsoft ODBC for Oracle 6.01.7601.17514 OS-Windows 2008R2 64bit)
ODBC Connection Fails connection to Oracle 10g database [message #636016] Tue, 14 April 2015 13:10 Go to next message
joneschik
Messages: 1
Registered: April 2015
Location: Oklahoma
Junior Member
Connection to Oracle db fails System DSN using MS Access 2003 and Oracle database. Using 32-bit ODBC Admin Tool from C:\Windows\SysWOW64\System DSN Windows 2008R2 64bitusing odbcad32.exe. Microsoft ODBC Driver for Oracle 6.01.7601.17514 MSORCL32.DLL 11/20/2010. This works perfectly on a Windows 2003 32-bit server. Does the SQL log attached give any clues?
  • Attachment: SQL.txt
    (Size: 11.51KB, Downloaded 3175 times)
Re: ODBC Connection Fails connection to Oracle 10g database [message #636020 is a reply to message #636016] Tue, 14 April 2015 14:28 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Every connection request that gets to the listener gets logged; regardless of the success or failure.

post excerpt from listener.log file that shows this ODBC connection request.

If no such entry exists, this means the request never got to the listener & therefore root cause & fix are external to Oracle.
Re: ODBC Connection Fails connection to Oracle 10g database [message #636024 is a reply to message #636016] Wed, 15 April 2015 01:38 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

As for your question, can you explain the situation again? I cannot work out if it is your ODBC client or your Oracle database that is running on 32bit or 64bit Windows. Did you upgrade one or the other or both? Aso, exactly what releases of Oracle products are you running? For example, it is only the terminal release of the 10g database, 10.2.0.5, that is certified against 2008R2.
Previous Topic: Lob read/write functions called while another read/write is in progress: getBytes()
Next Topic: Unable to connect to a remote database through ASP. NET ( ASPHostPortal.com)
Goto Forum:
  


Current Time: Thu Mar 28 18:15:01 CDT 2024