Обсуждение: Re: Antw: Re: VBA 6 crashes with WIN2K, Postgres 8.1, why? which dll ??

> -----Original Message-----
> From: Thomas Holschen [mailto:Thomas.Holschen@hela-food.de]
> Sent: 06 January 2006 11:20
> To: Ludek Finstrle; Dave Page
> Cc: pgsql-odbc@postgresql.org
> Subject: Antw: Re: [ODBC] VBA 6 crashes with WIN2K, Postgres
> 8.1, why? which dll ??
>
> The Example is installed with MSI-Installer for psqlODBC 08.01.0101.
> It's installed as c:/Programme/psqlODBC/docs/howto-vb.html.

Nowhere in there does it mention updateable cursors - in fact, it was
written long before they were even added to the driver.

I just tested the example given, and with a few minor typo/thinko fixes
it works just fine *except* for the RecordCount which has been the
subject of recent discussion anyway.

Regards, Dave

In the VB debugger, watching   'CN' the cn.DefaultData immediately after
the connection has
' multi step error and it says to check the ole db status if applicable'

Following this it reads the first record, but ! the "rs.AbsolutPage,
rs.AbsolutePosition" is "adPosUnknown"

Is this a driver bug or I've missed up some setup, grant, odbc registry ???
.
Dave Page wrote:

>
>
>
>
>>-----Original Message-----
>>From: Thomas Holschen [mailto:Thomas.Holschen@hela-food.de]
>>Sent: 06 January 2006 11:20
>>To: Ludek Finstrle; Dave Page
>>Cc: pgsql-odbc@postgresql.org
>>Subject: Antw: Re: [ODBC] VBA 6 crashes with WIN2K, Postgres
>>8.1, why? which dll ??
>>
>>The Example is installed with MSI-Installer for psqlODBC 08.01.0101.
>>It's installed as c:/Programme/psqlODBC/docs/howto-vb.html.
>>
>>
>
>Nowhere in there does it mention updateable cursors - in fact, it was
>written long before they were even added to the driver.
>
>I just tested the example given, and with a few minor typo/thinko fixes
>it works just fine *except* for the RecordCount which has been the
>subject of recent discussion anyway.
>
>Regards, Dave
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: explain analyze is your friend
>
>
>

> -----Original Message-----
> From: linuxgps [mailto:linuxgps@invitel.hu]
> Sent: 06 January 2006 14:35
> To: Dave Page
> Cc: Thomas Holschen; Ludek Finstrle; pgsql-odbc@postgresql.org
> Subject: Re: Antw: Re: [ODBC] VBA 6 crashes with WIN2K,
> Postgres 8.1, why? which dll ??
>
>
>
> In the VB debugger, watching   'CN' the cn.DefaultData
> immediately after
> the connection has
> ' multi step error and it says to check the ole db status if
> applicable'

You get an error merely by opening the connection? Can we see the mylog
output please? FWIW, I'm not surprised the DefaultDatabase isn't
supported - you cannot change it with a PostgreSQL connection so it
doesn't make sense to have a 'default'.

Regard,s Dave

> -----Original Message-----
> From: linuxgps [mailto:linuxgps@invitel.hu]
> Sent: 06 January 2006 17:53
> To: Dave Page
> Cc: Thomas Holschen; Ludek Finstrle; pgsql-odbc@postgresql.org
> Subject: Re: Antw: Re: [ODBC] VBA 6 crashes with WIN2K,
> Postgres 8.1, why? which dll ??
>
> I've attached the log.

That doesn't show a crash at startup, nor is it even generated by the
test code we were discussing - there's almost 1MB of output caused by
SQLTables which is not used by the test program. I'm guessing you sent
the wrong log - mine from a single run of the program was 64KB btw.

Regards, Dave.

Sorry Dave,
 you're right that was the log on the other machine.

Here is  the log of app crashed with  memory exception

Dave Page wrote:

>
>
>
>
>>-----Original Message-----
>>From: linuxgps [mailto:linuxgps@invitel.hu]
>>Sent: 06 January 2006 17:53
>>To: Dave Page
>>Cc: Thomas Holschen; Ludek Finstrle; pgsql-odbc@postgresql.org
>>Subject: Re: Antw: Re: [ODBC] VBA 6 crashes with WIN2K,
>>Postgres 8.1, why? which dll ??
>>
>>I've attached the log.
>>
>>
>
>That doesn't show a crash at startup, nor is it even generated by the
>test code we were discussing - there's almost 1MB of output caused by
>SQLTables which is not used by the test program. I'm guessing you sent
>the wrong log - mine from a single run of the program was 64KB btw.
>
>Regards, Dave.
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: Don't 'kill -9' the postmaster
>
>
>

[1548]globals.extra_systable_prefixes = 'dd_;'
[1548][[SQLAllocHandle]][1548]**** in PGAPI_AllocEnv **
[1548]** exit PGAPI_AllocEnv: phenv = 36649776 **
[1548][[SQLSetEnvAttr]] att=200,2
[1548][[SQLAllocHandle]][1548]PGAPI_AllocConnect: entering...
[1548]**** PGAPI_AllocConnect: henv = 36649776, conn = 36649832
[1548]EN_add_connection: self = 36649776, conn = 36649832
[1548]       added at i =0, conn->henv = 36649776, conns[i]->henv = 36649776
[1548][SQLGetInfo(30)][1548]PGAPI_GetInfo: entering...fInfoType=77
[1548]PGAPI_GetInfo: p='03.00', len=5, value=0, cbMax=12
[1548][[SQLSetConnectAttr]] 103
[1548]PGAPI_SetConnectAttr 103
[1548]PGAPI_SetConnectOption: entering fOption = 103 vParam = 15
[1548][SQLDriverConnect][1548]PGAPI_DriverConnect: entering...
[1548]**** PGAPI_DriverConnect: fDriverCompletion=0, connStrIn='DSN=hpuj;UID=postgres;PWD=xxxxxxx;Database=postgres;'
[1548]our_connect_string = 'DSN=hpuj;UID=postgres;PWD=xxxxxxx;Database=postgres;'
[1548]attribute = 'DSN', value = 'hpuj'
[1548]copyAttributes:
DSN='hpuj',server='',dbase='',user='',passwd='xxxxx',port='',sslmode='',onlyread='',protocol='',conn_settings='',disallow_premature=-1)
[1548]attribute = 'UID', value = 'postgres'
[1548]copyAttributes:
DSN='hpuj',server='',dbase='',user='postgres',passwd='xxxxx',port='',sslmode='',onlyread='',protocol='',conn_settings='',disallow_premature=-1)
[1548]attribute = 'PWD', value = 'xxxxx'
[1548]copyAttributes:
DSN='hpuj',server='',dbase='',user='postgres',passwd='xxxxx',port='',sslmode='',onlyread='',protocol='',conn_settings='',disallow_premature=-1)
[1548]attribute = 'Database', value = 'postgres'
[1548]copyAttributes:
DSN='hpuj',server='',dbase='postgres',user='postgres',passwd='xxxxx',port='',sslmode='',onlyread='',protocol='',conn_settings='',disallow_premature=-1)
[1548]globals.extra_systable_prefixes = 'dd_;'
[1548]globals.extra_systable_prefixes = 'dd_;'
[1548]our_connect_string = 'DSN=hpuj;UID=postgres;PWD=xxxxxxx;Database=postgres;'
[1548]attribute = 'DSN', value = 'hpuj'
[1548]CopyCommonAttributes:
A7=100;A8=8192;A9=0;B0=254;B1=8190;B2=1;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[1548]attribute= 'UID',
value= 'postgres' 
[1548]CopyCommonAttributes:
A7=100;A8=8192;A9=0;B0=254;B1=8190;B2=1;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[1548]attribute= 'PWD',
value= 'xxxxx' 
[1548]CopyCommonAttributes:
A7=100;A8=8192;A9=0;B0=254;B1=8190;B2=1;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[1548]attribute=
'Database',value = 'postgres' 
[1548]CopyCommonAttributes:
A7=100;A8=8192;A9=0;B0=254;B1=8190;B2=1;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[1548]CC_connect:
entering...
[1548]CC_connect(): DSN = 'hpuj', server = '192.168.1.31', port = '5432', sslmode = 'prefer', database = 'postgres',
username= 'postgres', password='xxxxx' 
[1548]connecting to the server
[1548]connecting to the database  using 192.168.1.31 as the server
[1548]the size is 18
[1548]connection to the database succeeded.
[1548]connection to the database succeeded.
[1548]CC_lookup_pg_version: entering...
[1548]PGAPI_AllocStmt: entering...
[1548]**** PGAPI_AllocStmt: hdbc = 36649832, stmt = 36643048
[1548]CC_add_statement: self=36649832, stmt=36643048
[1548]PGAPI_ExecDirect: entering...
[1548]recycle statement: self= 36643048
[1548]PDATA_free_params:  ENTER, self=36643480
[1548]**** PGAPI_ExecDirect: hstmt=36643048, statement='select version()'
[1548]PGAPI_ExecDirect: calling PGAPI_Execute...
[1548]PGAPI_Execute: entering...
[1548]PGAPI_Execute: clear errors...
[1548]recycle statement: self= 36643048
[1548]PDATA_free_params:  ENTER, self=36643480
[1548]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=16, stmt='select version()'
[1548]   stmt_with_params = 'select version()'
[1548]       Sending SELECT statement on stmt=36643048, cursor_name='SQL_CUR022F20E8'
[1548]send_query(): conn=36649832, query='select version()'
[1548]in QR_Constructor
[1548]exit QR_Constructor
[1548]in TL_Constructor
[1548]exit TL_Constructor
[1548]send_query: done sending query
[1548]QR_fetch_tuples: cursor = '', self->cursor=0
[1548]QR_fetch_tuples: past CI_read_fields: num_fields = 1
[1548]MALLOC: tuple_size = 100, size = 800
[1548]     done sending the query:
[1548]extend_column_bindings: entering ... self=36643184, bindings_allocated=0, num_columns=1
[1548]exit extend_column_bindings
[1548]PGAPI_ExecDirect: returned 0 from PGAPI_Execute
[1548]PGAPI_Fetch: stmt = 36643048, stmt->result= 36643712
[1548]manual_result = 1, use_declarefetch = 0
[1548]**** SC_fetch: manual_result
[1548]extend_getdata_info: entering ... self=36643404, gdata_allocated=0, num_columns=1
[1548]exit extend_gdata_info
[1548]fetch: cols=1, lf=0, opts = 36643184, opts->bindings = 36666032, buffer[] = 0
[1548]PGAPI_GetData: enter, stmt=36643048
[1548]     value = 'PostgreSQL 8.1.0 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)'
[1548]**** PGAPI_GetData: icol = 0, fCType = 1, field_type = 25, value = 'PostgreSQL 8.1.0 on i686-pc-mingw32, compiled
byGCC gcc.exe (GCC) 3.4.2 (mingw-special)' 
[1548]copy_and_convert: field_type = 25, fctype = 1, value = 'PostgreSQL 8.1.0 on i686-pc-mingw32, compiled by GCC
gcc.exe(GCC) 3.4.2 (mingw-special)', cbValueMax=128 
[1548]DEFAULT: len = 88, ptr = 'PostgreSQL 8.1.0 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw-special)'
[1548]    SQL_C_CHAR, default: len = 88, cbValueMax = 128, rgbValueBindRow = 'PostgreSQL 8.1.0 on i686-pc-mingw32,
compiledby GCC gcc.exe (GCC) 3.4.2 (mingw-special)' 
[1548]Got the PostgreSQL version string: 'PostgreSQL 8.1.0 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw-special)'
[1548]Extracted PostgreSQL version number: '8.1'
[1548]PGAPI_FreeStmt: entering...hstmt=36643048, fOption=1
[1548]QResult: in DESTRUCTOR
[1548]TupleList: in DESTRUCTOR
[1548]TupleList: exit DESTRUCTOR
[1548]QResult: free memory in, fcount=101
[1548]QResult: free memory out
[1548]QResult: exit DESTRUCTOR
[1548]SC_Destructor: self=36643048, self->result=0, self->hdbc=36649832
[1548]APD_free_params:  ENTER, self=36643300
[1548]IPD_free_params:  ENTER, self=36643364
[1548]PDATA_free_params:  ENTER, self=36643480
[1548]ARDFields_free 22f2170 bookmark=22f2330[1548]ARD_unbind_cols freeall=1 allocated=1 bindings=22f7ab0
[1548]reset_a_column_binding: entering ... self=36643184, bindings_allocated=1, icol=1
[1548]APD_free_params:  ENTER, self=36643300
[1548]IPD_free_params:  ENTER, self=36643364
[1548]GDATA_unbind_cols freeall=1 allocated=1 gdata=22f7ad8
[1548]SC_Destructor: EXIT
[1548]CC_send_settings: entering...
[1548]PGAPI_AllocStmt: entering...
[1548]**** PGAPI_AllocStmt: hdbc = 36649832, stmt = 36643048
[1548]CC_add_statement: self=36649832, stmt=36643048
[1548]PGAPI_ExecDirect: entering...
[1548]recycle statement: self= 36643048
[1548]PDATA_free_params:  ENTER, self=36643480
[1548]**** PGAPI_ExecDirect: hstmt=36643048, statement='set DateStyle to 'ISO''
[1548]PGAPI_ExecDirect: calling PGAPI_Execute...
[1548]PGAPI_Execute: entering...
[1548]PGAPI_Execute: clear errors...
[1548]recycle statement: self= 36643048
[1548]PDATA_free_params:  ENTER, self=36643480
[1548]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=22, stmt='set DateStyle to 'ISO''
[1548]   stmt_with_params = 'set DateStyle to 'ISO''
[1548]      it's NOT a select statement: stmt=36643048
[1548]send_query(): conn=36649832, query='set DateStyle to 'ISO''
[1548]in QR_Constructor
[1548]exit QR_Constructor
[1548]The query was executed successfully and the query did not return any result
[1548]send_query: done sending query
[1548]QR_fetch_tuples: cursor = '', self->cursor=0
[1548]QR_fetch_tuples: past CI_read_fields: num_fields = 0
[1548]MALLOC: tuple_size = 100, size = 0
[1548]PGAPI_ExecDirect: returned 0 from PGAPI_Execute
[1548]CC_send_settings: result 0, status 1 from set DateStyle
[1548]PGAPI_ExecDirect: entering...
[1548]recycle statement: self= 36643048
[1548]QResult: in DESTRUCTOR
[1548]QResult: free memory in, fcount=101
[1548]QResult: free memory out
[1548]QResult: exit DESTRUCTOR
[1548]PDATA_free_params:  ENTER, self=36643480
[1548]**** PGAPI_ExecDirect: hstmt=36643048, statement='set geqo to 'OFF''
[1548]PGAPI_ExecDirect: calling PGAPI_Execute...
[1548]PGAPI_Execute: entering...
[1548]PGAPI_Execute: clear errors...
[1548]recycle statement: self= 36643048
[1548]PDATA_free_params:  ENTER, self=36643480
[1548]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=17, stmt='set geqo to 'OFF''
[1548]   stmt_with_params = 'set geqo to 'OFF''
[1548]      it's NOT a select statement: stmt=36643048
[1548]send_query(): conn=36649832, query='set geqo to 'OFF''
[1548]in QR_Constructor
[1548]exit QR_Constructor
[1548]The query was executed successfully and the query did not return any result
[1548]send_query: done sending query
[1548]QR_fetch_tuples: cursor = '', self->cursor=0
[1548]QR_fetch_tuples: past CI_read_fields: num_fields = 0
[1548]MALLOC: tuple_size = 100, size = 0
[1548]PGAPI_ExecDirect: returned 0 from PGAPI_Execute
[1548]CC_send_settings: result 0, status 1 from set geqo
[1548]PGAPI_ExecDirect: entering...
[1548]recycle statement: self= 36643048
[1548]QResult: in DESTRUCTOR
[1548]QResult: free memory in, fcount=101
[1548]QResult: free memory out
[1548]QResult: exit DESTRUCTOR
[1548]PDATA_free_params:  ENTER, self=36643480
[1548]**** PGAPI_ExecDirect: hstmt=36643048, statement='set extra_float_digits to 2'
[1548]PGAPI_ExecDirect: calling PGAPI_Execute...
[1548]PGAPI_Execute: entering...
[1548]PGAPI_Execute: clear errors...
[1548]recycle statement: self= 36643048
[1548]PDATA_free_params:  ENTER, self=36643480
[1548]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=27, stmt='set extra_float_digits to
2'
[1548]   stmt_with_params = 'set extra_float_digits to 2'
[1548]      it's NOT a select statement: stmt=36643048
[1548]send_query(): conn=36649832, query='set extra_float_digits to 2'
[1548]in QR_Constructor
[1548]exit QR_Constructor
[1548]The query was executed successfully and the query did not return any result
[1548]send_query: done sending query
[1548]QR_fetch_tuples: cursor = '', self->cursor=0
[1548]QR_fetch_tuples: past CI_read_fields: num_fields = 0
[1548]MALLOC: tuple_size = 100, size = 0
[1548]PGAPI_ExecDirect: returned 0 from PGAPI_Execute
[1548]CC_send_settings: result 0, status 1 from set extra_float_digits
[1548]PGAPI_FreeStmt: entering...hstmt=36643048, fOption=1
[1548]QResult: in DESTRUCTOR
[1548]QResult: free memory in, fcount=101
[1548]QResult: free memory out
[1548]QResult: exit DESTRUCTOR
[1548]SC_Destructor: self=36643048, self->result=0, self->hdbc=36649832
[1548]APD_free_params:  ENTER, self=36643300
[1548]IPD_free_params:  ENTER, self=36643364
[1548]PDATA_free_params:  ENTER, self=36643480
[1548]ARDFields_free 22f2170 bookmark=22f2358[1548]ARD_unbind_cols freeall=1 allocated=0 bindings=0
[1548]APD_free_params:  ENTER, self=36643300
[1548]IPD_free_params:  ENTER, self=36643364
[1548]GDATA_unbind_cols freeall=1 allocated=0 gdata=0
[1548]SC_Destructor: EXIT
[1548]CC_lookup_lo: entering...
[1548]PGAPI_AllocStmt: entering...
[1548]**** PGAPI_AllocStmt: hdbc = 36649832, stmt = 36643048
[1548]CC_add_statement: self=36649832, stmt=36643048
[1548]PGAPI_ExecDirect: entering...
[1548]recycle statement: self= 36643048
[1548]PDATA_free_params:  ENTER, self=36643480
[1548]**** PGAPI_ExecDirect: hstmt=36643048, statement='select oid from pg_type where typname='lo''
[1548]PGAPI_ExecDirect: calling PGAPI_Execute...
[1548]PGAPI_Execute: entering...
[1548]PGAPI_Execute: clear errors...
[1548]recycle statement: self= 36643048
[1548]PDATA_free_params:  ENTER, self=36643480
[1548]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=42, stmt='select oid from pg_type
wheretypname='lo'' 
[1548]   stmt_with_params = 'select oid from pg_type where typname='lo''
[1548]       Sending SELECT statement on stmt=36643048, cursor_name='SQL_CUR022F20E8'
[1548]send_query(): conn=36649832, query='select oid from pg_type where typname='lo''
[1548]in QR_Constructor
[1548]exit QR_Constructor
[1548]in TL_Constructor
[1548]exit TL_Constructor
[1548]send_query: done sending query
[1548]QR_fetch_tuples: cursor = '', self->cursor=0
[1548]QR_fetch_tuples: past CI_read_fields: num_fields = 1
[1548]MALLOC: tuple_size = 100, size = 800
[1548]     done sending the query:
[1548]extend_column_bindings: entering ... self=36643184, bindings_allocated=0, num_columns=1
[1548]exit extend_column_bindings
[1548]PGAPI_ExecDirect: returned 0 from PGAPI_Execute
[1548]PGAPI_Fetch: stmt = 36643048, stmt->result= 36643712
[1548]manual_result = 1, use_declarefetch = 0
[1548]PGAPI_FreeStmt: entering...hstmt=36643048, fOption=1
[1548]QResult: in DESTRUCTOR
[1548]TupleList: in DESTRUCTOR
[1548]TupleList: exit DESTRUCTOR
[1548]QResult: free memory in, fcount=101
[1548]QResult: free memory out
[1548]QResult: exit DESTRUCTOR
[1548]SC_Destructor: self=36643048, self->result=0, self->hdbc=36649832
[1548]APD_free_params:  ENTER, self=36643300
[1548]IPD_free_params:  ENTER, self=36643364
[1548]PDATA_free_params:  ENTER, self=36643480
[1548]ARDFields_free 22f2170 bookmark=22f2358[1548]ARD_unbind_cols freeall=1 allocated=1 bindings=22f24e8
[1548]reset_a_column_binding: entering ... self=36643184, bindings_allocated=1, icol=1
[1548]APD_free_params:  ENTER, self=36643300
[1548]IPD_free_params:  ENTER, self=36643364
[1548]GDATA_unbind_cols freeall=1 allocated=0 gdata=0
[1548]SC_Destructor: EXIT
[1548]CC_lookup_characterset: entering...
[1548]send_query(): conn=36649832, query='select pg_client_encoding()'
[1548]in QR_Constructor
[1548]exit QR_Constructor
[1548]in TL_Constructor
[1548]exit TL_Constructor
[1548]send_query: done sending query
[1548]QR_fetch_tuples: cursor = '', self->cursor=0
[1548]QR_fetch_tuples: past CI_read_fields: num_fields = 1
[1548]MALLOC: tuple_size = 100, size = 800
[1548]QResult: in DESTRUCTOR
[1548]TupleList: in DESTRUCTOR
[1548]TupleList: exit DESTRUCTOR
[1548]QResult: free memory in, fcount=101
[1548]QResult: free memory out
[1548]QResult: exit DESTRUCTOR
[1548]send_query(): conn=36649832, query='set client_encoding to 'WIN1250''
[1548]in QR_Constructor
[1548]exit QR_Constructor
[1548]The query was executed successfully and the query did not return any result
[1548]send_query: done sending query
[1548]QR_fetch_tuples: cursor = '', self->cursor=0
[1548]QR_fetch_tuples: past CI_read_fields: num_fields = 0
[1548]MALLOC: tuple_size = 100, size = 0
[1548]QResult: in DESTRUCTOR
[1548]QResult: free memory in, fcount=101
[1548]QResult: free memory out
[1548]QResult: exit DESTRUCTOR
[1548]CC_connect: returning...
[1548]szConnStrOut =
'DSN=hpuj;DATABASE=postgres;SERVER=192.168.1.31;PORT=5432;SSLMODE=prefer;UID=postgres;PWD=xxxxxxx;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=8192;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=8190;Debug=1;CommLog=0;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;;LFConversion=1;UpdatableCursors=0;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0;LowerCaseIdentifier=0'
len=589,1024
[1548]PGAPI_DriverConnect: returning 0
[1548][[SQLGetDiagRec]]
[1548]PGAPI_GetDiagRec entering rec=1[1548]**** PGAPI_ConnectError: hdbc=36649832 <0>
[1548]enter CC_get_error
[1548]enter CC_create_errormsg
[1548]msg = ''
[1548]exit CC_create_errormsg
[1548]exit CC_get_error
[1548]CC_Get_error returned nothing.
[1548]PGAPI_GetDiagRec exiting 100
[1548][SQLGetFunctions][1548][SQLGetInfo(30)][1548]PGAPI_GetInfo: entering...fInfoType=23
[1548]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=2
[1548][SQLGetInfo(30)][1548]PGAPI_GetInfo: entering...fInfoType=24
[1548]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=2
[1548][SQLGetInfo(30)][1548]PGAPI_GetInfo: entering...fInfoType=79
[1548]PGAPI_GetInfo: p='<NULL>', len=4, value=3, cbMax=4
[1548][SQLGetInfo(30)][1548]PGAPI_GetInfo: entering...fInfoType=83
[1548]PGAPI_GetInfo: p='<NULL>', len=4, value=0, cbMax=4
[1548][SQLGetInfo(30)][1548]PGAPI_GetInfo: entering...fInfoType=78
[1548]PGAPI_GetInfo: p='<NULL>', len=4, value=1, cbMax=4
[1548][SQLGetInfo(30)][1548]PGAPI_GetInfo: entering...fInfoType=81
[1548]PGAPI_GetInfo: p='<NULL>', len=4, value=15, cbMax=4
[1548][SQLGetInfo(30)][1548]PGAPI_GetInfo: entering...fInfoType=72
[1548]PGAPI_GetInfo: p='<NULL>', len=4, value=10, cbMax=4
[1548][SQLGetInfo(30)][1548]PGAPI_GetInfo: entering...fInfoType=82
[1548]PGAPI_GetInfo: p='<NULL>', len=4, value=90, cbMax=4
[1548][SQLGetInfo(30)][1548]PGAPI_GetInfo: entering...fInfoType=44
[1548]PGAPI_GetInfo: p='<NULL>', len=4, value=17, cbMax=4
[1548][SQLGetInfo(30)][1548]PGAPI_GetInfo: entering...fInfoType=43
[1548]PGAPI_GetInfo: p='<NULL>', len=4, value=1, cbMax=4
[1548][SQLGetInfo(30)][1548]PGAPI_GetInfo: entering...fInfoType=144
[1548]PGAPI_GetInfo30: p='<NULL>', len=4, value=0, cbMax=4
[1548][SQLGetInfo(30)][1548]PGAPI_GetInfo: entering...fInfoType=150
[1548]PGAPI_GetInfo30: p='<NULL>', len=4, value=4687, cbMax=4
[1548][SQLGetInfo(30)][1548]PGAPI_GetInfo: entering...fInfoType=167
[1548]PGAPI_GetInfo30: p='<NULL>', len=4, value=4687, cbMax=4
[1548][SQLGetInfo(30)][1548]PGAPI_GetInfo: entering...fInfoType=146
[1548]PGAPI_GetInfo30: p='<NULL>', len=4, value=1, cbMax=4
[1548][SQLGetInfo(30)][1548]PGAPI_GetInfo: entering...fInfoType=151
[1548]PGAPI_GetInfo30: p='<NULL>', len=4, value=1, cbMax=4
[1548][SQLGetInfo(30)][1548]PGAPI_GetInfo: entering...fInfoType=168
[1548]PGAPI_GetInfo30: p='<NULL>', len=4, value=1, cbMax=4
[1548][SQLGetInfo(30)][1548]PGAPI_GetInfo: entering...fInfoType=111
[1548]PGAPI_GetInfo: p='N', len=1, value=0, cbMax=512
[1548][SQLGetInfo(30)][1548]PGAPI_GetInfo: entering...fInfoType=16
[1548]PGAPI_GetInfo: p='', len=0, value=0, cbMax=0
[1548][SQLGetInfo(30)][1548]PGAPI_GetInfo: entering...fInfoType=23
[1548]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=4
[1548][SQLGetInfo(30)][1548]PGAPI_GetInfo: entering...fInfoType=24
[1548]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=4
[1548][SQLGetInfo(30)][1548]PGAPI_GetInfo: entering...fInfoType=46
[1548]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=4
[1548][[SQLSetConnectAttr]] 1
[1548]PGAPI_SetConnectAttr 1
[1548]PGAPI_SetConnectOption: entering fOption = 1 vParam = 0
[1548]SetStmtOption(): SQL_MAX_ROWS, vParam = 0
[1548][[SQLSetConnectAttr]] 0
[1548]PGAPI_SetConnectAttr 0
[1548]PGAPI_SetConnectOption: entering fOption = 0 vParam = 0
[1548]SetStmtOption: SQL_QUERY_TIMEOUT, vParam = 0
[1548][SQLGetInfo(30)][1548]PGAPI_GetInfo: entering...fInfoType=6
[1548]PGAPI_GetInfo: p='PSQLODBCA.DLL', len=13, value=0, cbMax=52
[1548][SQLGetInfo(30)][1548]PGAPI_GetInfo: entering...fInfoType=6
[1548]PGAPI_GetInfo: p='PSQLODBCA.DLL', len=13, value=0, cbMax=52
[1548][SQLGetInfo(30)][1548]PGAPI_GetInfo: entering...fInfoType=6
[1548]PGAPI_GetInfo: p='PSQLODBCA.DLL', len=13, value=0, cbMax=52
[1548][SQLGetInfo(30)][1548]PGAPI_GetInfo: entering...fInfoType=6
[1548]PGAPI_GetInfo: p='PSQLODBCA.DLL', len=13, value=0, cbMax=48
[1548][SQLGetInfo(30)][1548]PGAPI_GetInfo: entering...fInfoType=1
[1548]PGAPI_GetInfo: p='<NULL>', len=2, value=0, cbMax=4
[1548][[SQLGetConnectAttr]] 109
[1548]PGAPI_GetConnectAttr 109
[1548]PGAPI_GetConnectOption: entering...
[1548][SQLGetInfo(30)][1548]PGAPI_GetInfo: entering...fInfoType=26
[1548]PGAPI_GetInfo: p='<NULL>', len=4, value=2, cbMax=4
[1548][[SQLAllocHandle]][1548]PGAPI_AllocStmt: entering...
[1548]**** PGAPI_AllocStmt: hdbc = 36649832, stmt = 36643048
[1548]CC_add_statement: self=36649832, stmt=36643048
[1548][[SQLGetStmtAttr]] Handle=36643048 10010
[1548]PGAPI_GetStmtAttr Handle=36643048 10010
[1548][[SQLGetStmtAttr]] Handle=36643048 10011
[1548]PGAPI_GetStmtAttr Handle=36643048 10011
[1548][[SQLGetStmtAttr]] Handle=36643048 10012
[1548]PGAPI_GetStmtAttr Handle=36643048 10012
[1548][[SQLGetStmtAttr]] Handle=36643048 10013
[1548]PGAPI_GetStmtAttr Handle=36643048 10013
[1548][[SQLSetStmtAttr]] Handle=36643048 18,10
[1548]PGAPI_SetStmtAttr Handle=36643048 18,10
[1548][[SQLSetStmtAttr]] Handle=36643048 18,0
[1548]PGAPI_SetStmtAttr Handle=36643048 18,0
[1548][[SQLSetStmtAttr]] Handle=36643048 17,1241416
[1548]PGAPI_SetStmtAttr Handle=36643048 17,1241416
[1548][[SQLSetStmtAttr]] Handle=36643048 17,0
[1548]PGAPI_SetStmtAttr Handle=36643048 17,0
[1548][[SQLSetDescField]] h=36643268 rec=1 field=1004 val=12f148
[1548]PGAPI_SetDescField h=36643268 rec=1 field=1004 val=12f148,0
[1548]DESCRIPTOR ERROR: func=PGAPI_SetDescField, desc='', errnum=11, errmsg='bad parameter number'
[1548][[SQLGetDiagRec]]
[1548]PGAPI_GetDiagRec entering rec=1

What type of cursor are you using.
The sample in the MSDN (VB6 era help) says to use Client side cursor to enable AbsolutePosition,
AbsolutePage.

I guess it makes sense. A server side cursor is a pointer to records on the server. A ForwardOnly cursor
pulls back the recordset but only gives you a pointer to it, but doesn't know how many records are in the
set or how to page it before it has gone to the end -- and it can't go backward.

rule of thumb -- use:
rsCursorLocation = adUseClient
rs.open sql, cnn, adOpenStatic, adLockReadOnly, adCmdText ---- or something close to this

rs.Open sql, cnn -- also works



linuxgps wrote:

>
>
> In the VB debugger, watching   'CN' the cn.DefaultData immediately after
> the connection has
> ' multi step error and it says to check the ole db status if applicable'
>
> Following this it reads the first record, but ! the "rs.AbsolutPage,
> rs.AbsolutePosition" is "adPosUnknown"
>
> Is this a driver bug or I've missed up some setup, grant, odbc registry ???
> .
> Dave Page wrote:
>
>>
>>
>>
>>
>>> -----Original Message-----
>>> From: Thomas Holschen [mailto:Thomas.Holschen@hela-food.de] Sent: 06
>>> January 2006 11:20
>>> To: Ludek Finstrle; Dave Page
>>> Cc: pgsql-odbc@postgresql.org
>>> Subject: Antw: Re: [ODBC] VBA 6 crashes with WIN2K, Postgres 8.1,
>>> why? which dll ??
>>>
>>> The Example is installed with MSI-Installer for psqlODBC 08.01.0101.
>>> It's installed as c:/Programme/psqlODBC/docs/howto-vb.html.
>>>
>>
>>
>> Nowhere in there does it mention updateable cursors - in fact, it was
>> written long before they were even added to the driver.
>>
>> I just tested the example given, and with a few minor typo/thinko fixes
>> it works just fine *except* for the RecordCount which has been the
>> subject of recent discussion anyway.
>>
>> Regards, Dave
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 6: explain analyze is your friend
>>
>>
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend

> -----Original Message-----
> From: linuxgps [mailto:linuxgps@invitel.hu]
> Sent: 06 January 2006 22:18
> To: Dave Page
> Cc: Thomas Holschen; Ludek Finstrle; pgsql-odbc@postgresql.org
> Subject: Re: Antw: Re: [ODBC] VBA 6 crashes with WIN2K,
> Postgres 8.1, why? which dll ??
>
> Sorry Dave,
>  you're right that was the log on the other machine.
>
> Here is  the log of app crashed with  memory exception

What version of the driver is this? I can't see anything obviously wrong
in there :-(

Regards, Dave

> -----Original Message-----
> From: linuxgps [mailto:linuxgps@invitel.hu]
> Sent: 09 January 2006 16:37
> To: Dave Page
> Subject: Re: Antw: Re: [ODBC] VBA 6 crashes with WIN2K,
> Postgres 8.1, why? which dll ??
>
> I've  reinstalled the newest postgres v8.1.2 win32 msi
> (http://wwwmaster.postgresql.org/download/mirrors-ftp?file=bin
> ary%2Fv8.1.2%2Fwin32%2Fpostgresql-8.1.2-1.zip)
> from the pgfoundry
> http://wwwmaster.postgresql.org/download/mirrors-ftp?file=odbc
> %2Fversions%2Fdll%2Fpsqlodbc-08_01_0102.zip
> In the VB 6(SP6) the cn debugstring has the following value after the
> connection:
> debug1 Provider=MSDASQL.1;Extended
> Properties="DSN=compaq1;DATABASE=postgres;SERVER=localhost;POR
> T=5432;SSLMODE=prefer;UID=postgres;PWD=pgtest;ReadOnly=0;Proto
> col=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSys
> temTables=0;ConnSettings=;Fetch=100;Socket=8192;UnknownSizes=0
> ;MaxVarcharSize=254;MaxLongVarcharSize=8190;Debug=1;CommLog=1;
> Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;Unkno
> wnsAsLongVarchar=0;BoolsAsChar=1;Parse=1;CancelAsFreeStmt=0;Ex
> traSysTablePrefixes=dd_;;LFConversion=1;UpdatableCursors=0;Dis
> allowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;Us
> eServerSidePrepare=0;LowerCaseIdentifier=0"
> stepping to next program line:

The only differences I can see are that you have commlog turned on which
I do not, and you have Parse Statements turned on, which I don't. I know
which I'd lay money on being the culprit if it is one of those, but
perhaps you could turn the options off one at a time, testing after each
one.

Other that that, I'm stumped. Perhaps someone else can run the test and
see what happens. Or maybe someone else has an idea.

It might be worth posting the full VB project you are using, just in
case there's a copy n paste error or something in it.

Regards, Dave.

Hello,

  I'm sorry I'm out of problem. I don't monitor this thread as Dave
responds.

> > I've  reinstalled the newest postgres v8.1.2 win32 msi
> > (http://wwwmaster.postgresql.org/download/mirrors-ftp?file=bin
> > ary%2Fv8.1.2%2Fwin32%2Fpostgresql-8.1.2-1.zip)
> > from the pgfoundry
> > http://wwwmaster.postgresql.org/download/mirrors-ftp?file=odbc
> > %2Fversions%2Fdll%2Fpsqlodbc-08_01_0102.zip

Could you try the newer "development snapshot"? There is the newest one
here:
http://pgfoundry.org/tracker/index.php?func=detail&aid=1000510&group_id=1000125&atid=538
(at the bottom of the page - psqlodbc-setpos.zip)
Note: there is only two DLLs which replace files from realease version.

> Other that that, I'm stumped. Perhaps someone else can run the test and
> see what happens. Or maybe someone else has an idea.

Could you write me few lines about it? Maybe link to related archive.
I try to read this in archive but it's blind for me. There is several
threads and I don't know which one I may follow.

> It might be worth posting the full VB project you are using, just in
> case there's a copy n paste error or something in it.

It is the best for me if you create minimalistic example which show the
problem and send it to me compiled (I have no VB compiler or I know
nothing about it).

Regards,

Luf