Db2 driver s sqlsetconnectattr failed

 · Hey all, need a little expert advice. I haven't used SQL Server all that much, so I'm hoping this is a simple fix. I've built a workflow that copies data from some Access DB tables and loads it into a SQL Server that is located on the same machine. I'm using the scheduler, also on the same local m.  · Symptoms. When you try to set a connection attribute of an ODBC connection where connection pooling is enabled by using ODBC Driver API with Microsoft SQL Server ODBC Driver, you receive the following error message: IM [Microsoft] [ODBC Driver Manager] Driver's SQLSetConnectAttr failed. Note The ODBC Driver documentation . Running the command binddb2pkg server database DB2_admin password [port] causes the following error: EXCEPTION: [DataDirect][ODBC DB2 Wire Protocol driver]Optional feature not implemented. [DataDirect][ODBC DB2 Wire Protocol driver]Driver's SQLSetConnectAttr failed. [DataDirect][ODBC DB2 Wire Protocol driver]Connection refused.

DB2® CLI is unable to allocate memory required to support execution or completion of the function. It is likely that process-level memory has been exhausted for the application process. Consult the operating system configuration for information on process-level memory limitations. HY Invalid argument value. DataDirect Connection fails with "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed" with the Connect for ODBC SQL Server Wire Protocol driver. [DataDirect][ODBC DB2 Wire Protocol driver][DB2]Unknown error: SQLCODE [DataDirect][ODBC DB2 Wire Protocol driver]Driver's SQLSetConnectAttr failed. Cause This error can happen if the DB2 Alias id different than the DB2 database name.

TDS is a protocol relevant for Sybase RDBMS and Microsoft SQL-server. You cannot use freeTDS to connect to a Db2 RDBMS. Folks, Below is the error i am getting while doing the run data viewer in server[DataDirect][ODBC lib] Driver's SQLSetConnectAttr failed. This error is known to occur if DB2 Authentication is set to SERVER_ENCRYPT in the database instance. This means the instance is expecting.