Home » Open Source » Programming Interfaces » ODBC connection fails for Oracle 10g in Windows XP.
ODBC connection fails for Oracle 10g in Windows XP. [message #247312] Mon, 25 June 2007 09:08 Go to next message
purusothaman
Messages: 2
Registered: June 2007
Location: Chennai, INDIA
Junior Member

Hi all,

I just want to connect my app with Oracle thru ODBC.
And this is what I have tried to connect to.

CDatabase::OpenEx("DRIVER={Microsoft ODBC for Oracle};SERVER=192.168.2.17;UID=system;PWD=db5;");

This did not work and gives error message,
"ORA-12170: TNS:Connect timeout occurred. Driver's SQLSetConnectAttr failed."

I have searched in net and left no luck.

My installation is Oracle 10g.

And I am able to connect to server using URL,
http://192.168.2.17:5560/isqlplus

with user name : system
password : db5
Connect Identifier : (blank)

Any suggestion would be appreciated.

Thanks.

Regards,
Purusothaman A
Re: ODBC connection fails for Oracle 10g in Windows XP. [message #247315 is a reply to message #247312] Mon, 25 June 2007 09:26 Go to previous messageGo to next message
purusothaman
Messages: 2
Registered: June 2007
Location: Chennai, INDIA
Junior Member

Now I added port 1521 in server's firewall to not to block requests of this port.

Now the error message changed to,
ORA-12514: TNS:listner does not currently know of service requested in connect descriptor. Driver's SQLSetConnectAttr failed.

Any solutions?

Regards,
Purusothaman A
Re: ODBC connection fails for Oracle 10g in Windows XP. [message #247325 is a reply to message #247315] Mon, 25 June 2007 09:55 Go to previous message
Michel Cadot
Messages: 59405
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ora-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
 *Cause:  The SERVICE_NAME in the CONNECT_DATA was not found in
 the listener's tables.
 *Action: Check to make sure that the SERVICE_NAME specified is correct.
 *Comment: This error will be returned if the (database) service has not been
 registered with the listener; a database instance that is part of this
 service may need to be started or configured properly.

Regards
Michel
Previous Topic: Modifying a passwoed on a front end application
Next Topic: how to connect to Oracle from jsp page in Eclipse?????
Goto Forum:
  


Current Time: Mon Oct 20 20:43:10 CDT 2014

Total time taken to generate the page: 0.07676 seconds