Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

psqlODBC driver and COM+

7 views
Skip to first unread message

Eric

unread,
May 28, 2002, 3:38:31 PM5/28/02
to
I have been doing some experimenting with the PostgreSQL odbc driver.
Using a standard VB exe, I have been able to successfully connect to
the remote database and execute queries against it. However, when I
put the same code into a COM+ application, the connection fails with
the error 'Unknown connect option (Set)'. So I turned on odbc tracing
and the following snippet was logged after trying to connect:

VB6 380-228 ENTER SQLSetConnectAttrW
SQLHDBC 05A71730
SQLINTEGER 1207 <SQL_ATTR_ENLIST_IN_DTC>
SQLPOINTER 0x06A70104
SQLINTEGER -6

VB6 380-228 EXIT SQLSetConnectAttrW with return code -1
(SQL_ERROR)
SQLHDBC 05A71730
SQLINTEGER 1207 <SQL_ATTR_ENLIST_IN_DTC>
SQLPOINTER 0x06A70104
SQLINTEGER -6

DIAG [S1009] Unknown connect option (Set) (205)

I did some looking into the SQL_ATTR_ENLIST_IN_DTC connection
attribute and found that it was introduced in odbc3 and for an odbc
driver to work with COM+ (or MTS), it must be supported. So I tried to
use the beta PostgreSQL+ driver--which I believe is an odbc3
version--and it too did not work. The error I got was 羨utomation
error'. Does anyone know if this attribute will be supported in the
new odbc3 version of the driver? Has anyone tried to use the odbc
driver with COM+ (or MTS) and can offer advice/suggestions?

Thanks!

0 new messages