Toad World® Forums

Connecting to DB2 via ODBC

The Toad Data Point Trial allowed me to connect to my DB2 database using ODBC without any problems. When I purchased the full version, I can no longer make a new connection. I receive the error:

[Microsoft][ODBC Driver Manager] Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed.

My ODBC driver is still working fine outside of Data Point. Any suggestions?

Using version 3.2.0.916

Worked around the problem by avoiding ODBC type connections and selecting the DB2-specific connection.

What type of DB2 connection are you trying to use? If LUW or Z/OS please use the native connection, not ODBC.

Also, TDP version 3.3 was released on June 20th. I would upgrade to that version.

Debbie

From: wpavao [mailto:bounce-wpavao@toadworld.com]

Sent: Monday, June 24, 2013 7:59 AM

To: toaddatapoint@toadworld.com

Subject: [Toad Data Point - Discussion Forum] Connecting to DB2 via ODBC

Connecting to DB2 via ODBC

Thread created by wpavao

The Toad Data Point Trial allowed me to connect to my DB2 database using ODBC without any problems. When I purchased the full version, I can no longer make a new connection. I receive the error:

[Microsoft][ODBC Driver Manager] Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed.

My ODBC driver is still working fine outside of Data Point. Any suggestions?

Using version 3.2.0.916

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from General
notifications altogether.

Toad Data Point - Discussion Forum

Flag
this post as spam/abuse.