Connect string using MS Oracle ODBC driver. help.

I am trying to figure out how to use the Microsoft Oracle ODBC driver to connect to an Oracle Database. I can not get it to work. I used the following connect string for Oracle's ODBC driver and it worked fine:

"ODBC;DSN=MyOracleDSN;DBQ=ServiceName.world;DBA=W;UID=UserName;PWD=Password;
"

The string I am trying to use to connect to my Oracle database using the Microsoft ODBC driver is as follows:

"ODBC;DSN=MyMSDSN;SERVER=ServiceName.world;DBA=W;UID=UserName;PWD=Password;"

It generates an error with an ORA12154 - TNS:could not resolve service name.

Now why is it that the Oracle ODBC driver was able to resolve the service name but the Microsoft driver could not? I checked my ORANAMES.ORA file and everything looks ok to me.

I have tried many various permutations in the connect string. Such as Using the "DBQ" parameter instead of "Server". I know there is a "DATABASE=" but I do not really understand how to use it and I can not find any decent documentation that explains it. As far as I know, there is no way in Oracle to actaully give your database a name. Its only refered to by it SID. I am running my database on my local machine and I am trying to connect to it locally. I do not have a Names Server setup and I do not even understand how to do that in the first place (the documentation is terrible).

I setup my service name with Net8 Easy Config. Using TCP.

Please help.

Brad

--
To reply to me, remove the "_nospam" from my address. Received on Wed May 26 1999 - 13:59:31 CDT