ODBC issue in windows 7

[nasreen]

Hi All,

I have a project in vb6 developed under Windows XP. I use ODBC settings to connect to my database in SQL Server 2008. This work somoothly and prefectly in Windows XP

Now some of my clients change their OS to windows 7. My program doesn't work in Windows 7 and it says connection failure.

I have set correct ODBC settings in windows 7 but I don't know what is the error in my side.

I checked my source code installing VB6 in windows 7 and now I get following error message:

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

How can I solve this issue ?

Regards
Nasreen

[dilettante]

ODBC is way old technology, and SQL Server offers OLEDB Providers that provide better performance and more flexibility.

However most likely your trouble isn't Windows 7, but that your program is being run on 64-bit Windows for the first time. You probably are using a DSN, and you probably created it there using the wrong (64-bit) ODBC Administrator tool:

The 32-bit version of the ODBC Administrator tool and the 64-bit version of the ODBC Administrator tool display both the 32-bit user DSNs and the 64-bit user DSNs in a 64-bit version of the Windows operating system

The 64-bit ODBC Administrator tool can be invoked from Control Panel to manage user DSNs and system DSNs that are used by 64-bit processes. On a 64-bit operating system, the 32-bit ODBC Administrator tool is used for Windows on Windows 64 (WOW64) processes. You must directly invoke the 32-bit ODBC Administrator tool from the SysWoW64 folder. You can use the 32-bit ODBC Administrator tool to manage user DSNs and system DSNs that are used by WOW64 processes.

This is a very tired, old issue (ever since Win2K 64-bit came out) covered here many times in recent years. Consider moving away from ODBC or at least to DSN-less connection strings. 1993 is long gone.