ERROR IN ORACLE CONNECTION

  • Thread starter Thread starter triptiasawa
  • Start date Start date
T

triptiasawa

I HAVE CREATED ODBC CONNECTION FOR ORACLE.But when i use the
connection in vb.net i get the following error
error:ORA-12154 :TNS:could not resolve servicename
 
The Oracle client can not find the database because
the service name is wrong

1/ check that you can connect to the db with a native oracle client
for instance sql+
if you can't (and the database exist) you have to change your
tnsnames.ora file and add your service's entry
(if you don't understand, ask your dba )

2/ if point 1 is ok check the connection in the odbc tool. when you
define it you can push a "test connection" button.

3/ if none of the above work maybe you need to put a .WORLD suffix
to the service name in you connection string.

hope this helps

Marc Boizeau

http://oraclevsmicrosoft.blogspot.com
I HAVE CREATED ODBC CONNECTION FOR ORACLE.But when i use the
connection in vb.net i get the following error
error:ORA-12154 :TNS:could not resolve servicename
Click to expand...
 
Back
Top