If you can connect with SQL Plus there should be no problem with your tns entry.

In the past I had this problem on some pc's when using SQLSTRINGConn but found
if I use a DNS entry it worked. So what I do is have an option to use a DNS entry or SQLSTRINGCONNECT in an INI file for the application.

You might find the SQLCON() with a DNS entry works for you though...

I've seen this before. I think something is wrong in the ODBC registry section.

You might have to reinstall ODBC. I did this by:
-removing all files with *odbc* on the system.
-removing all reg keys with odbc from the reigstry (two main ones:)
HKEY_LOCAL_MAHCINE\SOFTWARE\ODBC ??
HKEY_LOCAL_USER\SOFTWARE\ODBC ???

Then run the MDAC installer.

Of course do this with care!





>The error that I get is just a Generic Connectivity Error. Below is AError(x):
>

>x(1) = 1526
>x(2) = Connectivity Error:[Microsoft][ODBC driver for Oracle][Oracle]
>x(3) = [Microsoft][ODBC driver for Oracle][Oracle]
>x(4) = NA000
>x(5) = 0
>x(6) = 1
>

>
>Any other ideas?
>
>>Should not be a problem. I'm using version 2.573.7713.0
>>perhaps check the version of your odbc driver.
>>
>>What type of error do you get? Maybe it's another problem.
>>
>>First thing that comes to mind is that when you create the tnsnames entry
>>with the oracle 8 easy config wizard you need to select the version of the database as "Release 8.0 or 7 ...".