OraFAQ Forum: Open Database Interfaces » ODBC connection fails for Oracle 10g in Windows XP.

Home » Open Source » Open Database Interfaces » ODBC connection fails for Oracle 10g in Windows XP.

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

ODBC connection fails for Oracle 10g in Windows XP. [message #247312]

Mon, 25 June 2007 09:08

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

Report message to a moderator

Re: ODBC connection fails for Oracle 10g in Windows XP. [message #247315 is a reply to message #247312]

Mon, 25 June 2007 09:26

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

Report message to a moderator

Re: ODBC connection fails for Oracle 10g in Windows XP. [message #247325 is a reply to message #247315]

Mon, 25 June 2007 09:55

Michel Cadot
Messages: 54129
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 23:52:20 CDT 2013

Total time taken to generate the page: 0.20793 seconds