I did reinstall the MDAC but that produced no change. I have just recently discovered that the Oracle ODBC driver does work for the connection on that machine. I do hate having to switch drivers being 2 months into the project.
>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 ...".