Обсуждение: Delphi7, ADO, ODBC and PostgreSQL connection problems
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
..
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.
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/
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/
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/
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
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
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/
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/