| ORA-12154: TNS:could not resolve service name [message #39457] |
Thu, 18 July 2002 00:45  |
claudine
Messages: 5
Registered: March 1998
|
Junior Member |
|
|
I have a package that returns a recordset, and from an ASP page I have the following connection string:
strConnection = "Provider=MSDAORA.1;Password="& strEpsdevPassword &";User ID=" & strEpsdevUser & ";Data Source="& strEpsdevDSN &";Persist Security Info=True"
When I used this to open the connection on a server with oracle Release 8.1.5, it worked fine. But when I did the same on Oracle Release 8.0.4, it gave the following error: Script Error
Microsoft OLE DB Provider for Oracle [[Line:596, Character:6]] ORA-12154: TNS:could not resolve service name : ''
For connections to packages that don't return recordsets I used the follwing conn string, which I found doesn't work with recordset returns:
strConnection = "Driver={Microsoft ODBC for Oracle};Server=" & strEpsdevDSN &";Uid=" & strEpsdevUser & ";Pwd=" & strEpsdevPassword & ";"
Can anyone help?
|
|
|
|
| Re: ORA-12154: TNS:could not resolve service name [message #39633 is a reply to message #39457] |
Tue, 30 July 2002 01:43  |
Sudipta Choudhury
Messages: 8
Registered: July 2002
|
Junior Member |
|
|
Dear
Claudine
You have configure the tns service when you change the
server or version of Oracle and this service name add
in the tnsname.ora file. The service name can be anything but with ".world" within this service name you
write the sid,protocol etc.... try this, if you want more details about this pleze mail me
Sudipta
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
