[issue?] SQLDriverConnect will clear existing connect attribute setting. - Mailing list pgsql-odbc

Hi,

I have a library to connect different database with ODBC. Found it’s not work on postgresql by setting autocommit off.

            SQLSetConnectAttr(hDbc,

                SQL_ATTR_AUTOCOMMIT,

                (SQLPOINTER) SQL_AUTOCOMMIT_OFF,

                0)

        SQLDriverConnect(hDbc,

                         GetDesktopWindow(),

                         wszConnStr,

                         SQL_NTS,

                         NULL,

                         0,

                         NULL,

                         SQL_DRIVER_COMPLETE);

After checked the source, found that

PGAPI_Connect init the connection attribute/option in CC_conninfo_init.

So I have to set connect Attribute  after Connect. Is this expected?

SQLDriverConnect -> SQLSetConnectAttr

It’s different with ODBC interface expected(allocate -> set -> connect).  

Thanks

Best Regards

Ivan