We have numerous apps which use a named DSN using SQLSRV32.dll for an ODBC connection from our Windows XP-Pro SP3 32 bit machines client access to remote windows 2003 based SQL servers (mix of 2005 and 2008). On migrating to Windows 7, this dll will
not allow the apps to use the newly constructed DSN (using SQLSRV32.dll with ODBC), even though a test connection is sucessful (abbeit much slower than seen on the XP-Pro machines). What must I use on the Windows 7 64 bit machine to allow a
DSN to be used by the migrated apps?
- I have descerned through Google that WDAC is now the tool to use, but I am cluless how to use it.
- The expectations from the app on the Windows XP-Pro and on the Windows 7 64 bit machines is to use a DSN to connect to SQL servers on Windows 2003.
I would appreciate any advice, and thanks!
View Complete Post