Synametrics Technologies

Good morning, I get the following error whenever I open Winsql and attaempt to connect to a DB2 datasource: SQL Error State:IM004, Native Error Code:0,ODBC Error: [Microsoft][ODBC Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_ENV failed If I open the ODBC manager and test the connection, it succeeds. But if I launch Winsql and connect to the same DSN it failes with the error above. OS: Windows 7 Enterprise Any thoughts?

>Good morning, > >I get the following error whenever I open Winsql and attaempt to connect to a DB2 >datasource: > >SQL Error State:IM004, Native Error Code:0,ODBC Error: >[Microsoft][ODBC Driver Manager]Driver's SQLAllocHandle on >SQL_HANDLE_ENV failed > >If I open the ODBC manager and test the connection, it succeeds. But if I launch Winsql >and connect to the same DSN it failes with the error above. > >OS: Windows 7 Enterprise > >Any thoughts?

Most common reason for this error is that you are using a 64-bit driver. Since WinSQL is a 32bit app, you must use a 32-bit driver. Try using WinSQL DB2 Wire Protocol driver that comes with WinSQL. Imran.