I have installed the new version of the Postgre ODBC driver with the msi
installer provided, but I have a Visual Basic abnormal error when I try
to open a recordset.
The conn.open works without problem, the error happens only when I try
to open the recordset with the following code :
Dim rs As New ADODB.Recordset
Dim sqlStr as String
sqlStr = "SELECT * FROM tUsers"
rs.Open sqlStr, dbConn, adOpenStatic, adLockOptimistic, adCmdText
- My conn.ConnectionString is :
Provider=MSDASQL.1;Extended Properties="DRIVER={PostgreSQL-libpq};
DATABASE=mybase;SERVER=myserver;PORT=5432;SSLMODE=prefer;
UID=postgres;PWD=postgres;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=1;RowVersioning=1;
ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;
MaxLongVarcharSize=8190;Debug=1;CommLog=1;Optimizer=1;Ksqo=3;UseDeclareFetch=0;TextAsLongVarchar=1;
UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;
LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;
UseServerSidePrepare=0;LowerCaseIdentifier=0"
- And here is the log :
[ PostgreSQL version string = 'PostgreSQL 8.0.4 on i686-pc-mingw32,
compiled
by GCC gcc.exe (GCC) 3.4.2 (mingw-special)' ]
[ PostgreSQL version number = '8.0' ]
conn=131349608, query='set DateStyle to 'ISO''
conn=131349608, query='set geqo to 'OFF''
conn=131349608, query='set extra_float_digits to 2'
conn=131349608, query='select oid from pg_type where typname='lo''
[ Large Object oid = 17612 ]
conn=131349608, query='select pg_client_encoding()'
[ Client encoding = 'SQL_ASCII' (code = 0) ]
conn=131349608,
PGAPI_DriverConnect(out)='DRIVER={PostgreSQL-libpq};DATABASE=mybase;SERVER=myserver;
PORT=5432;SSLMODE=prefer;UID=postgres;PWD=xxxxxxxx;ReadOnly=0;
Protocol=6.4;FakeOidIndex=0;ShowOidColumn=1;RowVersioning=1;ShowSystemTables=0;C
onnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarc
harSize=8190;Debug=1;CommLog=1;Optimizer=1;Ksqo=3;UseDeclareFetch=0;TextAsLongVa
rchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSy
sTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsM
inus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0;LowerCaseIdentifier=0
'
DESCRIPTOR ERROR: func=PGAPI_SetDescField, desc='', errnum=11,
errmsg='bad param
eter number'
I hope you can help me.
Thanks in advance.
Thomas Chabaud
