| ODBC configuration [message #204796] |
Wed, 22 November 2006 02:32  |
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  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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 |
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?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
