Thread: Delphi7, ADO, ODBC and PostgreSQL connection problems

Delphi7, ADO, ODBC and PostgreSQL connection problems

From
"Mikhail Umorin"
Date:
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,

Mikhail.

--
Mikhail Umorin
mikeumo@onebox.com

here is an excerpt from mylog_xxxx.log (let me know if you need more info):

..
[-240017]READING ATTTYPMOD
[-240017]CI_read_fields: fieldname='pg_client_encoding', adtid=19, adtsize=64, atttypmod=-1
[-240017]QR_fetch_tuples: past CI_read_fields: num_fields = 1
[-240017]MALLOC: tuple_size = 100, size = 800
[-240017]next_tuple: inTuples = true, falling through: fcount = 101, fetch_count = 101
[-240017]qresult: len=9, buffer='SQL_ASCII'
[-240017]end of tuple list -- setting inUse to false: this = 33951312
[-240017]_next_tuple: 'C' fetch_total = 1 & this_fetch = 1
[-240017]send_query: got id = 'Z'
[-240017]QResult: in DESTRUCTOR
[-240017]QResult: free memory in, fcount=1
[-240017]row = 0, num_fields = 1
[-240017]free [lf=0] 33951568
[-240017]QResult: free memory out
[-240017]QResult: exit DESTRUCTOR
[-240017]CC_connect: returning...
[-240017]szConnStrOut = 'DRIVER={PostgreSQL
Legacy};DATABASE=lara;SERVER=192.168.1.2;PORT=5432;UID=lara;PWD=xxxxxxx;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=8190;Debug=1;CommLog=1;Optimizer=0;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=pg_;LFConversion=0;UpdatableCursors=0;DisallowPremature=0;TrueIsMinus1=0;BI=2;ByteaAsLongVarBinary=0;UseServerSidePrepare=0'
len=560,1024
[-240017]PGAPI_DriverConnect: returning 0
[-240017][SQLError][-240017]**** PGAPI_Error: henv=0, hdbc=32833656 hstmt=0
[-240017]**** PGAPI_ConnectError: hdbc=32833656 <512>
[-240017]enter CC_get_error
[-240017]enter CC_create_errormsg
[-240017]msg = ''
[-240017]exit CC_create_errormsg
[-240017]exit CC_get_error
[-240017]CC_Get_error returned nothing.
[-240017]**** PGAPI_Error exit code=100
[-240017][SQLGetFunctions][-240017]PGAPI_GetFunctions: entering...0
..



Re: Delphi7, ADO, ODBC and PostgreSQL connection problems

From
"Mikhail Umorin"
Date:
That was a log from the legacy driver (2.5) I tried just in case. I also tried Unicode (beta) with same "success". But
hereis the part of the log from the ODBC3.0 psqlodbc.dll driver (it has slightly different diagnostics): 

...
[-787737]READING ATTTYPMOD
[-787737]CI_read_fields: fieldname='pg_client_encoding', adtid=19, adtsize=64, atttypmod=-1
[-787737]QR_fetch_tuples: past CI_read_fields: num_fields = 1
[-787737]MALLOC: tuple_size = 100, size = 800
[-787737]next_tuple: inTuples = true, falling through: fcount = 101, fetch_count = 101
[-787737]qresult: len=9, buffer='SQL_ASCII'
[-787737]end of tuple list -- setting inUse to false: this = 33951312
[-787737]_next_tuple: 'C' fetch_total = 1 & this_fetch = 1
[-787737]send_query: got id = 'Z'
[-787737]QResult: in DESTRUCTOR
[-787737]QResult: free memory in, fcount=1
[-787737]row = 0, num_fields = 1
[-787737]free [lf=0] 33951568
[-787737]QResult: free memory out
[-787737]QResult: exit DESTRUCTOR
[-787737]CC_connect: returning...
[-787737]szConnStrOut =
'DRIVER={PostgreSQL};DATABASE=lara;SERVER=192.168.1.2;PORT=5432;UID=lara;PWD=xxxxxxx;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=1;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=1;MaxVarcharSize=254;MaxLongVarcharSize=8190;Debug=1;CommLog=1;Optimizer=0;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=pg_;LFConversion=0;UpdatableCursors=0;DisallowPremature=0;TrueIsMinus1=0;BI=2;ByteaAsLongVarBinary=0;UseServerSidePrepare=1'
len=553,1024
[-787737]PGAPI_DriverConnect: returning 0
[-787737][[SQLGetDiagRec]]
[-787737]PGAPI_GetDiagRec entering rec=1[-787737]**** PGAPI_ConnectError: hdbc=32833656 <0>
[-787737]enter CC_get_error
[-787737]enter CC_create_errormsg
[-787737]msg = ''
[-787737]exit CC_create_errormsg
[-787737]exit CC_get_error
[-787737]CC_Get_error returned nothing.
[-787737]PGAPI_GetDiagRec exiting 100
[-787737][SQLGetFunctions][-787737][SQLGetInfo(30)][-787737]PGAPI_GetInfo: entering...fInfoType=23
[-787737]PGAPI_GetInfo: p='<NULL>', len=2, value=1, cbMax=2
..
etc

Mikhail.

Re: Delphi7, ADO, ODBC and PostgreSQL connection problems

From
Hiroshi Inoue
Date:
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/

Re: Delphi7, ADO, ODBC and PostgreSQL connection problems

From
"Mikhail Umorin"
Date:
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/



Re: Delphi7, ADO, ODBC and PostgreSQL connection problems

From
Hiroshi Inoue
Date:

Mikhail Umorin wrote:
>
> here it is up until the message appears. After that I stopped the trace.

Unfortunately I could find no clue in the log.

How do you open the connection ?
Could you try to add a "lie=1" option to your connection string ?

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

Re: Delphi7, ADO, ODBC and PostgreSQL connection problems

From
"Thomas Wegner"
Date:
User DbExpress to connect to postgresql! This is the
best and fastest way from Delphi.

--

Thomas Wegner

""Mikhail Umorin"" <mikeumo@onebox.com> schrieb im Newsbeitrag
news:B0014792881@vljcms11.ucmretail.internal.callsciences.com...
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,

Mikhail.

--
Mikhail Umorin
mikeumo@onebox.com

here is an excerpt from mylog_xxxx.log (let me know if you need more info):

..
[-240017]READING ATTTYPMOD
[-240017]CI_read_fields: fieldname='pg_client_encoding', adtid=19,
adtsize=64, atttypmod=-1
[-240017]QR_fetch_tuples: past CI_read_fields: num_fields = 1
[-240017]MALLOC: tuple_size = 100, size = 800
[-240017]next_tuple: inTuples = true, falling through: fcount = 101,
fetch_count = 101
[-240017]qresult: len=9, buffer='SQL_ASCII'
[-240017]end of tuple list -- setting inUse to false: this = 33951312
[-240017]_next_tuple: 'C' fetch_total = 1 & this_fetch = 1
[-240017]send_query: got id = 'Z'
[-240017]QResult: in DESTRUCTOR
[-240017]QResult: free memory in, fcount=1
[-240017]row = 0, num_fields = 1
[-240017]free [lf=0] 33951568
[-240017]QResult: free memory out
[-240017]QResult: exit DESTRUCTOR
[-240017]CC_connect: returning...
[-240017]szConnStrOut = 'DRIVER={PostgreSQL
Legacy};DATABASE=lara;SERVER=192.168.1.2;PORT=5432;UID=lara;PWD=xxxxxxx;Read
Only=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSyste
mTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=
254;MaxLongVarcharSize=8190;Debug=1;CommLog=1;Optimizer=0;Ksqo=1;UseDeclareF
etch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=1;BoolsAsChar=1;Parse=0;Can
celAsFreeStmt=0;ExtraSysTablePrefixes=pg_;LFConversion=0;UpdatableCursors=0;
DisallowPremature=0;TrueIsMinus1=0;BI=2;ByteaAsLongVarBinary=0;UseServerSide
Prepare=0' len=560,1024
[-240017]PGAPI_DriverConnect: returning 0
[-240017][SQLError][-240017]**** PGAPI_Error: henv=0, hdbc=32833656 hstmt=0
[-240017]**** PGAPI_ConnectError: hdbc=32833656 <512>
[-240017]enter CC_get_error
[-240017]enter CC_create_errormsg
[-240017]msg = ''
[-240017]exit CC_create_errormsg
[-240017]exit CC_get_error
[-240017]CC_Get_error returned nothing.
[-240017]**** PGAPI_Error exit code=100
[-240017][SQLGetFunctions][-240017]PGAPI_GetFunctions: entering...0
..



---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend



Re: Delphi7, ADO, ODBC and PostgreSQL connection problems

From
"Mikhail Umorin"
Date:
like I already said I do not want to use dbExpress because
D7 pro does not come with Postgresql support (only MySQL and MS SQL Server) so, I must find a 3'rd party driver, which
wouldbe VitaVoom. But,what I can get for free requires running Delphi IDE at runtime or $150. I am not going to make
profitfrom my DB client, so the price is too steep for me.   
--
Mikhail Umorin
mikeumo@onebox.com


Re: Delphi7, ADO, ODBC and PostgreSQL connection problems

From
"Mikhail Umorin"
Date:
Hiroshi --
thanks for looking into my problem.
my connection string:
'Provider=MSDASQL.1;Persist Security Info=False;User ID=lara;DataSource=PostgreSQL30;Mode=Read;lie=1'

I tried it with your suggestion and the result is exactly the same.
that log excerpt did contain some error; what was it? I am a newbie to ADO/ODBC so, I can't tell. As far as I know,
TADOConnectionobject I use in my Delphi program is a wrapper around MS ADO API. 

Now, what I also discovered on PostgreSQL site was that 7.2 docs contained a chapter on ODBC and mentioned that one
mustrun odbc.sql on template1 in order to have ODBC-oriented functions in the database.  However, ODBC documentation is
absentin 7.3 (which I have) as well as odbc.sql. 
What's up with that?
Do I still need to run odbc.sql against template1, or ODBC API functions are already implemented there?

--
Mikhail Umorin
mikeumo@onebox.com



-----Original Message-----
From:     Hiroshi Inoue <Inoue@tpf.co.jp>
Sent:     Wed, 17 Sep 2003 10:30:51 +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:
>
> here it is up until the message appears. After that I stopped the trace.

Unfortunately I could find no clue in the log.

How do you open the connection ?
Could you try to add a "lie=1" option to your connection string ?

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



Re: Delphi7, ADO, ODBC and PostgreSQL connection problems

From
Hiroshi Inoue
Date:
Hi Mikhail,

Aren't you turning on the *Use Declare/Fetch* option ?
If so, please turn it off.

regards,
Hiroshi Inoue

Mikhail Umorin wrote:
>
> Hiroshi --
> thanks for looking into my problem.
> my connection string:
> 'Provider=MSDASQL.1;Persist Security Info=False;User ID=lara;DataSource=PostgreSQL30;Mode=Read;lie=1'
>
> I tried it with your suggestion and the result is exactly the same.
> that log excerpt did contain some error; what was it? I am a newbie to ADO/ODBC so, I can't tell. As far as I know,
TADOConnectionobject I use in my Delphi program is a wrapper around MS ADO API. 
>
> Now, what I also discovered on PostgreSQL site was that 7.2 docs contained a chapter on ODBC and mentioned that one
mustrun odbc.sql on template1 in order to have ODBC-oriented functions in the database.  However, ODBC documentation is
absentin 7.3 (which I have) as well as odbc.sql. 
> What's up with that?
> Do I still need to run odbc.sql against template1, or ODBC API functions are already implemented there?
>
> --
> Mikhail Umorin
> mikeumo@onebox.com
>
> -----Original Message-----
> From:     Hiroshi Inoue <Inoue@tpf.co.jp>
> Sent:     Wed, 17 Sep 2003 10:30:51 +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:
> >
> > here it is up until the message appears. After that I stopped the trace.
>
> Unfortunately I could find no clue in the log.
>
> How do you open the connection ?
> Could you try to add a "lie=1" option to your connection string ?
>
> regards,
> Hiroshi Inoue
>         http://www.geocities.jp/inocchichichi/psqlodbc/

--
Hiroshi Inoue
    http://www.geocities.jp/inocchichichi/psqlodbc/