OraFAQ Forum: Open Database Interfaces

Home » Open Source » Open Database Interfaces » ODBC error (10.2.0.1, Windows 2003)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

ODBC error [message #351682]

Thu, 02 October 2008 07:53

sant_new
Messages: 164
Registered: June 2008

Senior Member

Hi all, I am trying to troubleshoot user's problem connecting to the Oracle database via ODBC from an application server. There are sql server's configured in the ODBC and I'm able to test the connection to the SQl server databases. BUt unable to test the connection for the Oracle database in ODBC. IS there a way to test the connection??

THe server does not have MS office installed, I thought I can try with the Excel.

Thanks for your help.

Report message to a moderator

Re: ODBC error [message #351684 is a reply to message #351682]

Thu, 02 October 2008 08:00

Michel Cadot
Messages: 54192
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

When you create the DSN you can click on the "test" button.

Regards
Michel

Report message to a moderator

Re: ODBC error [message #351687 is a reply to message #351682]

Thu, 02 October 2008 08:12

sant_new
Messages: 164
Registered: June 2008

Senior Member

But, for some reason there is no test connection option when I create the DSN. I am using 'Microsoft ODBC for Oracle' driver.

But if I use the Oracle Client 10.2.0.1, I see the test connection option.

Any suggestions?? THanks.

Report message to a moderator