Original message: By: Dennis H.
I am having trouble connecting to DB2 via WinSQL, but only when executing in batch mode, via a *.wet file.
Current Set-up: WinSQL Professional v 10.0.154.694, running on Windows 7 Enterprise, 64-bit
When running the WinSQL 64-bit client, the error message is: 08-Aug-2016 18:14:07 [ERROR] {} - Unable to find license file for WinSQL drivers.
When running the WinSQL 32-bit client the error message is: 08-Aug-2016 18:14:07 [ERROR] {} - Unable to find license file for WinSQL drivers.
I would prefer to use the 64-bit version if possible. But for now I only want to get through my month-end any way I can.
After reading through the WinSQLKB, I have suspicions about the setting of Drivername within:
C:\Users\\AppData\Roaming\WinSQL\cache\DB2.info and C:\Users\\AppData\Roaming\WinSQL\cache\DB2\AIX64.info
Both of those files contain the following parameter setting: DB2CLI.DLL
According to your knowledge base, the driver parameter should be set to DB2CLIO.DLL when running in 64-bit mode.
I believe my ODBC manager configurations are correct, given that I can run my queries interactively. I also verified the driver references in both ODBC Managers
To access my 32-bit ODBC manager, I run: C:\Windows\SysWOW64\odbcad32.exe. Drivers in 32-bit mode correctly reference DB2CLI.DLL
To access my 64-bit ODBC manager, I run: C:\Windows\System32\odbcad32.exe. Drivers in 64-bit mode correctly reference DB2CLIO.DLL
I just need some help tweaking my system to recognize the same drivers in batch mode that I am using interactively.
Please advise.
