Thursday, May 28, 2009

Data source name not found and no default driver specified + 2008 Server

If a 32 application, running on a 64 bit application is trying to connect to sql server, then the data source should be created in the ODBCAD32.exe under[C:\Windows\SysWOW64\].
If the data sources are just created in the ODBCAD32, it will be created in 64 bit version and you might get the error "Data source name not found and no default driver specified".
For more details refer this Microsoft article



No comments: