Thread: odbc with MS-Query

odbc with MS-Query

From
BELLON Michel
Date:
Hi

With PostgreSQL 7.1.2 on NT 4 with cygwin, psqlodbc 7.01.00.05, MS-QUERY
8.00e

The register for the DSN used is described by :

[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\Certification]
"Driver"="C:\\WINDOWS\\SYSTEM\\psqlodbc.dll"
"Description"=""
"Database"="certification"
"Servername"="hestia"
"Port"="5432"
"Username"="rpm"
"Password"="rpm"
"ReadOnly"="0"
"ShowOidColumn"="1"
"FakeOidIndex"="1"
"RowVersioning"="0"
"ShowSystemTables"="1"
"Protocol"="6.4"
"ConnSettings"=""


and

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL]
"APILevel"="1"
"ConnectFunctions"="YYN"
"Driver"="C:\\WINDOWS\\SYSTEM\\psqlodbc.dll"
"DriverODBCVer"="02.50"
"FileUsage"="0"
"Setup"="C:\\WINDOWS\\SYSTEM\\psqlodbc.dll"
"SQLLevel"="1"
"UsageCount"=dword:00000002
"Fetch"="100"
"CommLog"="0"
"Optimizer"="1"
"Ksqo"="1"
"UniqueIndex"="0"
"ReadOnly"="0"
"UseDeclareFetch"="1"
"UnknownSizes"="0"
"TextAsLongVarchar"="0"
"UnknownsAsLongVarchar"="0"
"BoolsAsChar"="1"
"Parse"="0"
"CancelAsFreeStmt"="0"
"MaxVarcharSize"="254"
"MaxLongVarcharSize"="8190"
"ExtraSysTablePrefixes"="pg_;"
"ConnSettings"=""
"CPTimeout"="<non listé>"



MSQRY32 a causé une défaillance de pile dans le module PSQLODBC.DLL à
0157:013b6c27.
Registres :
EAX=00004414 CS=0157 EIP=013b6c27 EFLGS=00010206
EBX=00000000 SS=015f ESP=0060dbf0 EBP=0060dc3c
ECX=00601bf8 DS=015f ESI=00000000 FS=4d37
EDX=00000000 ES=015f EDI=00c40530 GS=0000
Octets à CS : EIP :
85 01 3d 00 10 00 00 73 ec 2b c8 8b c4 85 01 8b
Etat de la pile :
00000018 013aabfa 1f70c0c3 013e39c4 00000000 fffffffd 00000000 fffffffd
00000000 fffffffd 00c409b4 00000018 00c40448 00c40530 00000000 00c409b4


Some times ago, I obtainded very often
Error returned by SQL server
Internal Error : SQLSetScrollOptions

and in the psqlodbc_####.log :
STATEMENT ERROR: func=SQLSetScrollOptions, desc='Function not implemented',
errnum=0, errmsg='(NULL)'

Michel BELLON
LCIE - Informatique appliquée
33 (0)1 40 95 60 35


RE: odbc with MS-Query

From
"Hiroshi Inoue"
Date:
> -----Original Message-----
> From: BELLON Michel
>
> Hi
>
> With PostgreSQL 7.1.2 on NT 4 with cygwin, psqlodbc 7.01.00.05, MS-QUERY
> 8.00e
>
> The register for the DSN used is described by :
>
> [HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\Certification]
> "Driver"="C:\\WINDOWS\\SYSTEM\\psqlodbc.dll"
> "Description"=""
> "Database"="certification"
> "Servername"="hestia"
> "Port"="5432"
> "Username"="rpm"
> "Password"="rpm"
> "ReadOnly"="0"
> "ShowOidColumn"="1"
> "FakeOidIndex"="1"
> "RowVersioning"="0"
> "ShowSystemTables"="1"
> "Protocol"="6.4"
> "ConnSettings"=""
>
>
> and
>
> [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL]
> "APILevel"="1"
> "ConnectFunctions"="YYN"
> "Driver"="C:\\WINDOWS\\SYSTEM\\psqlodbc.dll"
> "DriverODBCVer"="02.50"
> "FileUsage"="0"
> "Setup"="C:\\WINDOWS\\SYSTEM\\psqlodbc.dll"
> "SQLLevel"="1"
> "UsageCount"=dword:00000002
> "Fetch"="100"
> "CommLog"="0"
> "Optimizer"="1"
> "Ksqo"="1"
> "UniqueIndex"="0"
> "ReadOnly"="0"
> "UseDeclareFetch"="1"
> "UnknownSizes"="0"
> "TextAsLongVarchar"="0"
> "UnknownsAsLongVarchar"="0"
> "BoolsAsChar"="1"
> "Parse"="0"
> "CancelAsFreeStmt"="0"
> "MaxVarcharSize"="254"
> "MaxLongVarcharSize"="8190"
> "ExtraSysTablePrefixes"="pg_;"
> "ConnSettings"=""
> "CPTimeout"="<non listé>"
>
>
>
> MSQRY32 a causé une défaillance de pile dans le module PSQLODBC.DLL à
> 0157:013b6c27.
> Registres :
> EAX=00004414 CS=0157 EIP=013b6c27 EFLGS=00010206
> EBX=00000000 SS=015f ESP=0060dbf0 EBP=0060dc3c
> ECX=00601bf8 DS=015f ESI=00000000 FS=4d37
> EDX=00000000 ES=015f EDI=00c40530 GS=0000
> Octets à CS : EIP :
> 85 01 3d 00 10 00 00 73 ec 2b c8 8b c4 85 01 8b
> Etat de la pile :
> 00000018 013aabfa 1f70c0c3 013e39c4 00000000 fffffffd 00000000 fffffffd
> 00000000 fffffffd 00c409b4 00000018 00c40448 00c40530 00000000 00c409b4
>

Please try the latest driver 7.01.0006.

regards,
Hiroshi Inoue