Windows 7 64 Bit - ODBC32 - Legacy App Problem

Posted by Arturo Caballero on Stack Overflow See other posts from Stack Overflow or by Arturo Caballero
Published on 2010-03-31T16:46:00Z Indexed on 2010/03/31 16:53 UTC
Read the original article Hit count: 501

Filed under:
|
|
|

Good day StackOverFlowlers,

I´m a little stuck (really stuck) with an issue with a legacy application on my organization.

I have a Windows 7 Enterprise 64 Bit machine, Access 2000 Installed and the Legacy App (Is built with something like VB but older) The App uses System ODBC in order to connect to a SQL 2000 DataBase on a Remote Server.

I created the ODCB using C:\Windows\SysWOW64\odbcad32.exe app in order to create a System DSN. I did not use the Windows 7 because it is not visible to the Legacy App.

I tested the ODBC connection with Access and worked ok, I can access the remote database.

Then I run the legacy App as Administrator and the App can see the ODBC, but I´m getting errors on credential validation and I´m getting this error:

    DIAG [08001] [Microsoft][ODBC SQL Server Driver][Multi-Protocol]SQL Server does not exist or access denied. (17) 

    DIAG [01000] [Microsoft][ODBC SQL Server Driver][Multi-Protocol]ConnectionOpen (Connect()). (53) 

    DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (0) 

I use Trusted Connection on the ODBC in order to validate the user by Domain Controller.

I think that the credentials are not being sent by the Legacy App to the ODBC, or something like that. I don´t have the source code of the Legacy App in order to debug the connection.

Also, I turned off the Firewall.

Any ideas??

Thanks in advance!

© Stack Overflow or respective owner

Related posts about sql

Related posts about odbc