Problem with a Server for database access

[SunStorm]

When the connection string have this format:
Driver={Microsoft ODBC for Oracle};UID=user;PWD=pass;Server=UNIX

The NTserver raise this error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS can't resolve the service name

Thanks
Thanks.
SunStorm

 

[link9]

Is that the name of your server? 'UNIX'

If it is, then for some reason, the server you are running this on doesn't know who that is --

Try using the ip address. You might also look into setting up a DSN for the database on the NT server, and then connecting like this:

con.open("DSN=dsnName;UID=;PWD=&quot

let me know if that helped.
Paul Prewett

 

[GlennBSI]

It's been a long time, but I recall having this myself.

Paul's suggestion about using the IP might do the trick, but what we had to do (if I'm remembering right) was to put the IP address of the server in either the hosts.sam or lmhost file on the web server. These files are in the winnt\system32\drivers\etc folder. I don't recall what the service name is supposed to be though. You need to talk to your dba.