odbc connection string dosen't work on windows 7

Question

I use ODBC connection for my application (controlpanel -> administrativetools -> odbc -> DSN) to sql server 2008, and windows authentication it works perfect on windows xp,

but now I run it on windows7 and sql server 2008 with sql server authentication. when I make the DSN and query the connection its ok and I got this message (TESTS COMPLETED SUCCESSFULLY!)

but when I run the application I got this error

(ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ''. ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ''.)

Its some thing wrong whit DSN but I dont know what it is ,

maybe Make DSN is diffrent in windows 7????

thanks alot

I think a little more and I found that Maybe my password doesn't save for my user, when I make that DSN?

How can I save it???

Solution

Isn't it 64 bit Win7 and 32 bit application?

If so you must configure ODBC DSN in 32 bit Windows subsystem. There are 2 version of odbcad32.exe in 64 bit versions of Windows. In c:\windows\system32 you will find 64 bit that configure ODBC for 64 bit applications and in c:\windows\syswow64 there is 32 bit version you should use to configure ODBC for 32 bit programs.