Windows 7 ODBC SQL Connection fails

[opticalman]

I am using FVP8 frontend
SQL Express 2005 backend
The program has run successfully for 5 years on many XP machines.
I have installed it for the first time on a Windows 7 machine. The ODBC connection tests good through the Windows ODBC Open connection Manager, but when I launch my program I get the following error:
==========================================================
connection failed
SQLState '01000'
SQL Server Error 67
[Microsoft][ODBC SQL Server Driver][DBNETLIB][ConnectionOpen(Connect())
Connection failed:
SQL State '08001'
SQL Server Error 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB][SQL Server does not exist or access denied]
===========================================================
Any suggestions would be appreciated.
Thank you in advance
Jim Rumbaugh

 

[JRB-Bldr]

Since you say that things worked in XP, In Win7 and did you set up your ODBC SQL DSN with the 32-bit tool?

C:\Windows\SysWOW64\odbcad32.exe

Good Luck,
JRB-Bldr

 

[opticalman]

Thank you JRB-Bldr

That solved my problem.

Jim Rumbaugh