Re: Delphi7, ADO, ODBC and PostgreSQL connection problems

From: "Mikhail Umorin" <mikeumo(at)onebox(dot)com>
To: Inoue(at)tpf(dot)co(dot)jp, mikeumo(at)onebox(dot)com
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Delphi7, ADO, ODBC and PostgreSQL connection problems
Date: 2003-09-17 01:04:05
Message-ID: B0014272499@vljcms08.ucmretail.internal.callsciences.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

here it is up until the message appears. After that I stopped the trace.

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLAllocEnv
HENV * 1F6EB570

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x1F6EB570 ( 0x01c4ff7c)

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLGetEnvAttr
SQLHENV 01C4FF7C
SQLINTEGER 201 <unknown>
SQLPOINTER [Unknown attribute 201]
SQLINTEGER 4
SQLINTEGER * 0x006FEEBC

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLGetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 01C4FF7C
SQLINTEGER 201 <unknown>
SQLPOINTER [Unknown attribute 201]
SQLINTEGER 4
SQLINTEGER * 0x006FEEBC (527113474)

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLAllocEnv
HENV * 1F6EB574

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x1F6EB574 ( 0x01b501c0)

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLSetEnvAttr
SQLHENV 01B501C0
SQLINTEGER 201 <unknown>
SQLPOINTER [Unknown attribute 201]
SQLINTEGER -6

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 01B501C0
SQLINTEGER 201 <unknown>
SQLPOINTER [Unknown attribute 201]
SQLINTEGER -6

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLAllocConnect
HENV 01C4FF7C
HDBC * 006FF5EC

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 01C4FF7C
HDBC * 0x006FF5EC ( 0x01b50260)

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLGetInfoW
HDBC 01B50260
UWORD 10 <SQL_ODBC_VER>
PTR 0x006FF5B8
SWORD 22
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 10 <SQL_ODBC_VER>
PTR 0x006FF5B8
SWORD 22
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLSetConnectAttrW
SQLHDBC 01B50260
SQLINTEGER 101 <SQL_ATTR_ACCESS_MODE>
SQLPOINTER 0x00000001
SQLINTEGER -6

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS)
SQLHDBC 01B50260
SQLINTEGER 101 <SQL_ATTR_ACCESS_MODE>
SQLPOINTER 0x00000001 (BADMEM)
SQLINTEGER -6

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLSetConnectAttrW
SQLHDBC 01B50260
SQLINTEGER 103 <SQL_ATTR_LOGIN_TIMEOUT>
SQLPOINTER 0x0000000F
SQLINTEGER -6

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS)
SQLHDBC 01B50260
SQLINTEGER 103 <SQL_ATTR_LOGIN_TIMEOUT>
SQLPOINTER 0x0000000F (BADMEM)
SQLINTEGER -6

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLDriverConnectW
HDBC 01B50260
HWND 00000000
WCHAR * 0x1F7D8B70 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7D8B70
SWORD 8
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLDriverConnectW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
HWND 00000000
WCHAR * 0x1F7D8B70 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7D8B70
SWORD 8
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLGetInfoW
HDBC 01B50260
UWORD 77 <SQL_DRIVER_ODBC_VER>
PTR 0x006FF5B0
SWORD 24
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 77 <SQL_DRIVER_ODBC_VER>
PTR 0x006FF5B0
SWORD 24
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLGetInfoW
HDBC 01B50260
UWORD 79 <SQL_POS_OPERATIONS>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 79 <SQL_POS_OPERATIONS>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLGetInfoW
HDBC 01B50260
UWORD 83 <SQL_STATIC_SENSITIVITY>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 83 <SQL_STATIC_SENSITIVITY>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLGetInfoW
HDBC 01B50260
UWORD 78 <SQL_LOCK_TYPES>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 78 <SQL_LOCK_TYPES>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLGetInfoW
HDBC 01B50260
UWORD 81 <SQL_GETDATA_EXTENSIONS>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 81 <SQL_GETDATA_EXTENSIONS>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLGetInfoW
HDBC 01B50260
UWORD 72 <SQL_TXN_ISOLATION_OPTION>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 72 <SQL_TXN_ISOLATION_OPTION>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLGetInfoW
HDBC 01B50260
UWORD 82 <SQL_BOOKMARK_PERSISTENCE>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 82 <SQL_BOOKMARK_PERSISTENCE>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLGetInfoW
HDBC 01B50260
UWORD 44 <SQL_SCROLL_OPTIONS>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 44 <SQL_SCROLL_OPTIONS>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLGetInfoW
HDBC 01B50260
UWORD 43 <SQL_SCROLL_CONCURRENCY>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 43 <SQL_SCROLL_CONCURRENCY>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLGetInfoW
HDBC 01B50260
UWORD 144 <SQL_DYNAMIC_CURSOR_ATTRIBUTES1>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 144 <SQL_DYNAMIC_CURSOR_ATTRIBUTES1>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLGetInfoW
HDBC 01B50260
UWORD 150 <SQL_KEYSET_CURSOR_ATTRIBUTES1>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 150 <SQL_KEYSET_CURSOR_ATTRIBUTES1>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLGetInfoW
HDBC 01B50260
UWORD 167 <SQL_STATIC_CURSOR_ATTRIBUTES1>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 167 <SQL_STATIC_CURSOR_ATTRIBUTES1>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLGetInfoW
HDBC 01B50260
UWORD 146 <SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 146 <SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLGetInfoW
HDBC 01B50260
UWORD 151 <SQL_KEYSET_CURSOR_ATTRIBUTES2>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 151 <SQL_KEYSET_CURSOR_ATTRIBUTES2>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLGetInfoW
HDBC 01B50260
UWORD 168 <SQL_STATIC_CURSOR_ATTRIBUTES2>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 168 <SQL_STATIC_CURSOR_ATTRIBUTES2>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLGetInfoW
HDBC 01B50260
UWORD 111 <SQL_NEED_LONG_DATA_LEN>
PTR 0x006FF38C
SWORD 512
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 111 <SQL_NEED_LONG_DATA_LEN>
PTR 0x006FF38C
SWORD 512
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLGetInfoW
HDBC 01B50260
UWORD 16 <SQL_DATABASE_NAME>
PTR 0x00000000
SWORD 0
SWORD * 0x006FF592

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 16 <SQL_DATABASE_NAME>
PTR 0x00000000
SWORD 0
SWORD * 0x006FF592 (0)

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLGetInfoW
HDBC 01B50260
UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR>
PTR 0x006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR>
PTR 0x006FF594 (1)
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLGetInfoW
HDBC 01B50260
UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR>
PTR 0x006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR>
PTR 0x006FF594 (1)
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLGetInfoW
HDBC 01B50260
UWORD 46 <SQL_TXN_CAPABLE>
PTR 0x006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 46 <SQL_TXN_CAPABLE>
PTR 0x006FF594 (2)
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLSetConnectAttrW
SQLHDBC 01B50260
SQLINTEGER 1 <SQL_ATTR_MAX_ROWS>
SQLPOINTER 0x00000000
SQLINTEGER -6

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS)
SQLHDBC 01B50260
SQLINTEGER 1 <SQL_ATTR_MAX_ROWS>
SQLPOINTER 0x00000000
SQLINTEGER -6

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLSetConnectAttrW
SQLHDBC 01B50260
SQLINTEGER 0 <SQL_ATTR_QUERY_TIMEOUT>
SQLPOINTER 0x00000000
SQLINTEGER -6

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS)
SQLHDBC 01B50260
SQLINTEGER 0 <SQL_ATTR_QUERY_TIMEOUT>
SQLPOINTER 0x00000000
SQLINTEGER -6

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLGetInfoW
HDBC 01B50260
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x006FF344
SWORD 52
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x006FF344
SWORD 52
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLGetInfoW
HDBC 01B50260
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x006FF344
SWORD 52
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x006FF344
SWORD 52
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLGetInfoW
HDBC 01B50260
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x006FF344
SWORD 52
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x006FF344
SWORD 52
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLGetFunctions
HDBC 01B50260
UWORD 999
UWORD * 0x01251EE4

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLGetFunctions with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 999
UWORD * 0x01251EE4 (4294967294)

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLGetInfoW
HDBC 01B50260
UWORD 1 <SQL_ACTIVE_STATEMENTS>
PTR 0x006FF5D4
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 1 <SQL_ACTIVE_STATEMENTS>
PTR 0x006FF5D4 (0)
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLGetConnectAttrW
SQLHDBC 01B50260
SQLINTEGER 109 <SQL_ATTR_CURRENT_CATALOG>
SQLPOINTER 0x006FF39C
SQLINTEGER 514
SQLINTEGER * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLGetConnectAttrW with return code 0 (SQL_SUCCESS)
SQLHDBC 01B50260
SQLINTEGER 109 <SQL_ATTR_CURRENT_CATALOG>
SQLPOINTER 0x006FF39C
SQLINTEGER 514
SQLINTEGER * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 ENTER SQLGetInfoW
HDBC 01B50260
UWORD 26 <SQL_DEFAULT_TXN_ISOLATION>
PTR 0x006FF5A0
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff2d20b-fff2fd37 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 26 <SQL_DEFAULT_TXN_ISOLATION>
PTR 0x006FF5A0 (2)
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff ENTER SQLAllocEnv
HENV * 1F6EB570

LaraSchedVCL fff25db7-fff25fff EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x1F6EB570 ( 0x01c4ff7c)

LaraSchedVCL fff25db7-fff25fff ENTER SQLGetEnvAttr
SQLHENV 01C4FF7C
SQLINTEGER 201 <unknown>
SQLPOINTER [Unknown attribute 201]
SQLINTEGER 4
SQLINTEGER * 0x006FEEBC

LaraSchedVCL fff25db7-fff25fff EXIT SQLGetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 01C4FF7C
SQLINTEGER 201 <unknown>
SQLPOINTER [Unknown attribute 201]
SQLINTEGER 4
SQLINTEGER * 0x006FEEBC (527113474)

LaraSchedVCL fff25db7-fff25fff ENTER SQLAllocEnv
HENV * 1F6EB574

LaraSchedVCL fff25db7-fff25fff EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x1F6EB574 ( 0x01b501c0)

LaraSchedVCL fff25db7-fff25fff ENTER SQLSetEnvAttr
SQLHENV 01B501C0
SQLINTEGER 201 <unknown>
SQLPOINTER [Unknown attribute 201]
SQLINTEGER -6

LaraSchedVCL fff25db7-fff25fff EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 01B501C0
SQLINTEGER 201 <unknown>
SQLPOINTER [Unknown attribute 201]
SQLINTEGER -6

LaraSchedVCL fff25db7-fff25fff ENTER SQLAllocConnect
HENV 01C4FF7C
HDBC * 006FF5EC

LaraSchedVCL fff25db7-fff25fff EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 01C4FF7C
HDBC * 0x006FF5EC ( 0x01b50260)

LaraSchedVCL fff25db7-fff25fff ENTER SQLGetInfoW
HDBC 01B50260
UWORD 10 <SQL_ODBC_VER>
PTR 0x006FF5B8
SWORD 22
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 10 <SQL_ODBC_VER>
PTR 0x006FF5B8
SWORD 22
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff ENTER SQLSetConnectAttrW
SQLHDBC 01B50260
SQLINTEGER 101 <SQL_ATTR_ACCESS_MODE>
SQLPOINTER 0x00000001
SQLINTEGER -6

LaraSchedVCL fff25db7-fff25fff EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS)
SQLHDBC 01B50260
SQLINTEGER 101 <SQL_ATTR_ACCESS_MODE>
SQLPOINTER 0x00000001 (BADMEM)
SQLINTEGER -6

LaraSchedVCL fff25db7-fff25fff ENTER SQLSetConnectAttrW
SQLHDBC 01B50260
SQLINTEGER 103 <SQL_ATTR_LOGIN_TIMEOUT>
SQLPOINTER 0x0000000F
SQLINTEGER -6

LaraSchedVCL fff25db7-fff25fff EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS)
SQLHDBC 01B50260
SQLINTEGER 103 <SQL_ATTR_LOGIN_TIMEOUT>
SQLPOINTER 0x0000000F (BADMEM)
SQLINTEGER -6

LaraSchedVCL fff25db7-fff25fff ENTER SQLDriverConnectW
HDBC 01B50260
HWND 00000000
WCHAR * 0x1F7D8B70 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7D8B70
SWORD 8
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>

LaraSchedVCL fff25db7-fff25fff EXIT SQLDriverConnectW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
HWND 00000000
WCHAR * 0x1F7D8B70 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7D8B70
SWORD 8
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>

LaraSchedVCL fff25db7-fff25fff ENTER SQLGetInfoW
HDBC 01B50260
UWORD 77 <SQL_DRIVER_ODBC_VER>
PTR 0x006FF5B0
SWORD 24
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 77 <SQL_DRIVER_ODBC_VER>
PTR 0x006FF5B0
SWORD 24
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff ENTER SQLGetInfoW
HDBC 01B50260
UWORD 79 <SQL_POS_OPERATIONS>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 79 <SQL_POS_OPERATIONS>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff ENTER SQLGetInfoW
HDBC 01B50260
UWORD 83 <SQL_STATIC_SENSITIVITY>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 83 <SQL_STATIC_SENSITIVITY>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff ENTER SQLGetInfoW
HDBC 01B50260
UWORD 78 <SQL_LOCK_TYPES>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 78 <SQL_LOCK_TYPES>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff ENTER SQLGetInfoW
HDBC 01B50260
UWORD 81 <SQL_GETDATA_EXTENSIONS>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 81 <SQL_GETDATA_EXTENSIONS>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff ENTER SQLGetInfoW
HDBC 01B50260
UWORD 72 <SQL_TXN_ISOLATION_OPTION>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 72 <SQL_TXN_ISOLATION_OPTION>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff ENTER SQLGetInfoW
HDBC 01B50260
UWORD 82 <SQL_BOOKMARK_PERSISTENCE>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 82 <SQL_BOOKMARK_PERSISTENCE>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff ENTER SQLGetInfoW
HDBC 01B50260
UWORD 44 <SQL_SCROLL_OPTIONS>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 44 <SQL_SCROLL_OPTIONS>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff ENTER SQLGetInfoW
HDBC 01B50260
UWORD 43 <SQL_SCROLL_CONCURRENCY>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 43 <SQL_SCROLL_CONCURRENCY>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff ENTER SQLGetInfoW
HDBC 01B50260
UWORD 144 <SQL_DYNAMIC_CURSOR_ATTRIBUTES1>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 144 <SQL_DYNAMIC_CURSOR_ATTRIBUTES1>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff ENTER SQLGetInfoW
HDBC 01B50260
UWORD 150 <SQL_KEYSET_CURSOR_ATTRIBUTES1>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 150 <SQL_KEYSET_CURSOR_ATTRIBUTES1>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff ENTER SQLGetInfoW
HDBC 01B50260
UWORD 167 <SQL_STATIC_CURSOR_ATTRIBUTES1>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 167 <SQL_STATIC_CURSOR_ATTRIBUTES1>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff ENTER SQLGetInfoW
HDBC 01B50260
UWORD 146 <SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 146 <SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff ENTER SQLGetInfoW
HDBC 01B50260
UWORD 151 <SQL_KEYSET_CURSOR_ATTRIBUTES2>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 151 <SQL_KEYSET_CURSOR_ATTRIBUTES2>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff ENTER SQLGetInfoW
HDBC 01B50260
UWORD 168 <SQL_STATIC_CURSOR_ATTRIBUTES2>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 168 <SQL_STATIC_CURSOR_ATTRIBUTES2>
PTR 006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff ENTER SQLGetInfoW
HDBC 01B50260
UWORD 111 <SQL_NEED_LONG_DATA_LEN>
PTR 0x006FF38C
SWORD 512
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 111 <SQL_NEED_LONG_DATA_LEN>
PTR 0x006FF38C
SWORD 512
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff ENTER SQLGetInfoW
HDBC 01B50260
UWORD 16 <SQL_DATABASE_NAME>
PTR 0x00000000
SWORD 0
SWORD * 0x006FF592

LaraSchedVCL fff25db7-fff25fff EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 16 <SQL_DATABASE_NAME>
PTR 0x00000000
SWORD 0
SWORD * 0x006FF592 (0)

LaraSchedVCL fff25db7-fff25fff ENTER SQLGetInfoW
HDBC 01B50260
UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR>
PTR 0x006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR>
PTR 0x006FF594 (1)
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff ENTER SQLGetInfoW
HDBC 01B50260
UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR>
PTR 0x006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR>
PTR 0x006FF594 (1)
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff ENTER SQLGetInfoW
HDBC 01B50260
UWORD 46 <SQL_TXN_CAPABLE>
PTR 0x006FF594
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 46 <SQL_TXN_CAPABLE>
PTR 0x006FF594 (2)
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff ENTER SQLSetConnectAttrW
SQLHDBC 01B50260
SQLINTEGER 1 <SQL_ATTR_MAX_ROWS>
SQLPOINTER 0x00000000
SQLINTEGER -6

LaraSchedVCL fff25db7-fff25fff EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS)
SQLHDBC 01B50260
SQLINTEGER 1 <SQL_ATTR_MAX_ROWS>
SQLPOINTER 0x00000000
SQLINTEGER -6

LaraSchedVCL fff25db7-fff25fff ENTER SQLSetConnectAttrW
SQLHDBC 01B50260
SQLINTEGER 0 <SQL_ATTR_QUERY_TIMEOUT>
SQLPOINTER 0x00000000
SQLINTEGER -6

LaraSchedVCL fff25db7-fff25fff EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS)
SQLHDBC 01B50260
SQLINTEGER 0 <SQL_ATTR_QUERY_TIMEOUT>
SQLPOINTER 0x00000000
SQLINTEGER -6

LaraSchedVCL fff25db7-fff25fff ENTER SQLGetInfoW
HDBC 01B50260
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x006FF344
SWORD 52
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x006FF344
SWORD 52
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff ENTER SQLGetInfoW
HDBC 01B50260
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x006FF344
SWORD 52
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x006FF344
SWORD 52
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff ENTER SQLGetInfoW
HDBC 01B50260
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x006FF344
SWORD 52
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x006FF344
SWORD 52
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff ENTER SQLGetFunctions
HDBC 01B50260
UWORD 999
UWORD * 0x01251EE4

LaraSchedVCL fff25db7-fff25fff EXIT SQLGetFunctions with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 999
UWORD * 0x01251EE4 (4294967294)

LaraSchedVCL fff25db7-fff25fff ENTER SQLGetInfoW
HDBC 01B50260
UWORD 1 <SQL_ACTIVE_STATEMENTS>
PTR 0x006FF5D4
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 1 <SQL_ACTIVE_STATEMENTS>
PTR 0x006FF5D4 (0)
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff ENTER SQLGetConnectAttrW
SQLHDBC 01B50260
SQLINTEGER 109 <SQL_ATTR_CURRENT_CATALOG>
SQLPOINTER 0x006FF39C
SQLINTEGER 514
SQLINTEGER * 0x00000000

LaraSchedVCL fff25db7-fff25fff EXIT SQLGetConnectAttrW with return code 0 (SQL_SUCCESS)
SQLHDBC 01B50260
SQLINTEGER 109 <SQL_ATTR_CURRENT_CATALOG>
SQLPOINTER 0x006FF39C
SQLINTEGER 514
SQLINTEGER * 0x00000000

LaraSchedVCL fff25db7-fff25fff ENTER SQLGetInfoW
HDBC 01B50260
UWORD 26 <SQL_DEFAULT_TXN_ISOLATION>
PTR 0x006FF5A0
SWORD 4
SWORD * 0x00000000

LaraSchedVCL fff25db7-fff25fff EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 01B50260
UWORD 26 <SQL_DEFAULT_TXN_ISOLATION>
PTR 0x006FF5A0 (2)
SWORD 4
SWORD * 0x00000000

--
Mikhail Umorin
mikeumo(at)onebox(dot)com

-----Original Message-----
From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
Sent: Wed, 17 Sep 2003 09:02:52 +0900
To: Mikhail Umorin <mikeumo(at)onebox(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] Delphi7, ADO, ODBC and PostgreSQL connection problems

Mikhail Umorin wrote:
>
> Hello --
> How to set up PostgreSQL ODBC provider so I can access PostgreSQL database
> on a LAN? I use ODBC3.0 driver from GBorg (psqlodbc.dll) on WinME and
> PostgreSQL 7.3.2 on Mandrake 9.1. So far I tried setting up
> File DSN and get rintime error: "Object or provider is not capable of performing requested operation". (log provided below)I
> specified server IP address, database name, user and password in the provider entry
> (through Control Panel) and then used TADOConnection to connect to ODBC
> provider. The error comes up when I set Connected property of the connection object to True.
> I do not want to use VitaVoom SQL connection driver as the free (demo)
> version requires running Delphi.
> Thanks,

I see no serious error in the log.
Could you send me the ODBC trace ?

regards,
Hiroshi Inoue
http://www.geocities.jp/inocchichichi/psqlodbc/

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2003-09-17 01:30:51 Re: Delphi7, ADO, ODBC and PostgreSQL connection problems
Previous Message Hiroshi Inoue 2003-09-17 00:02:52 Re: Delphi7, ADO, ODBC and PostgreSQL connection problems