Re: Delphi7, ADO, ODBC and PostgreSQL connection problems

Поиск
Список
Период
Сортировка
От Mikhail Umorin
Тема Re: Delphi7, ADO, ODBC and PostgreSQL connection problems
Дата
Msg-id B0014272499@vljcms08.ucmretail.internal.callsciences.com
обсуждение исходный текст
Ответ на Delphi7, ADO, ODBC and PostgreSQL connection problems  ("Mikhail Umorin" <mikeumo@onebox.com>)
Список 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@onebox.com



-----Original Message-----
From:     Hiroshi Inoue <Inoue@tpf.co.jp>
Sent:     Wed, 17 Sep 2003 09:02:52 +0900
To:       Mikhail Umorin <mikeumo@onebox.com>
Cc:       pgsql-odbc@postgresql.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/



В списке pgsql-odbc по дате отправления:

Предыдущее
От: Hiroshi Inoue
Дата:
Сообщение: Re: Delphi7, ADO, ODBC and PostgreSQL connection problems
Следующее
От: Hiroshi Inoue
Дата:
Сообщение: Re: Delphi7, ADO, ODBC and PostgreSQL connection problems