Home » Other » General » ODBC configuration
ODBC configuration [message #204796] Wed, 22 November 2006 02:32 Go to next message
mattia
Messages: 2
Registered: November 2006
Junior Member
Hi all,
I've a problem in creating a connection between a program under windows and an Oracle Database (version 10.1.0.2) on a Solaris machine.
I've try to use "Microsoft ODBC for Oracle", "Oracle RDB Driver" and "Oracle in instantclient10_1", but no one of these works.
With the "Microsoft ODBC for Oracle" and "Oracle RDB Driver" I've always the same error ORA-12154, but with the "Oracle in instantclient10_1" I have the ORA-12560 error.
I would like to know if someone can explain me with a "step by step" solution, the right configuration and the right ODBC driver to use.

Thanks

Mattia
Re: ODBC configuration [message #204949 is a reply to message #204796] Wed, 22 November 2006 19:14 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Search this forum for 'ODBC' there should be a link to a site somewhere on the Web. Otherwise, google it.

By the way, please remember to test the ODBC linkage BEFORE you start trying to use it in your program.

David

Upd: Dumb typo.

[Updated on: Thu, 23 November 2006 17:08]

Report message to a moderator

Re: ODBC configuration [message #205035 is a reply to message #204796] Thu, 23 November 2006 02:13 Go to previous messageGo to next message
mattia
Messages: 2
Registered: November 2006
Junior Member
I already search on this mailing list for ODBC but I can't find the solution to my problem.
I've also tested the link before using the ODBC in my program. With the "Microsoft ODBC for Oracle" there isn't a way to test the link.
With "Oracle RDB Driver" when I make the test I obtain this error:
FAILED: Service Connection Test
rc=-1
SQLState=08S01
[Oracle][ODBC][Rdb] Connect Ret -1 Err#10061 WSAECONNREFUSED Connection Refused

With "Oracle in instantclient10_1" when I make the test I obtain this error:
Unable to Connect
SQLState=08004
[Oracle][ODBC][Ora] ORA-12154: TNS:could not resolve the connect identifier specified
In this case I don't have the possibility to set the IP or hostname . How can the driver find where to connect?
In both cases I've checked the Oracle logs but there isn't any significative record. Only when I use my program with the "Microsoft ODBC for Oracle" I find a record in the Oracle logs and I see SERVICE=ip_of_the_server instead of SERVICE=name_of_the_service

I've search on google to find something that can help me, but nothing...
It can be a problem of Oracle configuration?
Re: ODBC configuration [message #205182 is a reply to message #205035] Thu, 23 November 2006 17:15 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
It sounds like you haven't defined the ODBC link in your TNSNAMES.ORA file.

Look at http://www.orafaq.com/forum/m/172737/67467/?srch=odbc+tnsnames#msg_172737 and http://www.orafaq.com/forum/m/158725/67467/?srch=odbc+tnsnames#msg_158725 and http://www.orafaq.com/forum/m/141600/67467/?srch=odbc+tnsnames#msg_141600

David
Previous Topic: Table scheme visualization
Next Topic: SolidDB
Goto Forum:
  


Current Time: Wed Dec 07 06:41:29 CST 2016

Total time taken to generate the page: 0.27563 seconds