odbc with MS-Query - Mailing list pgsql-odbc

From BELLON Michel
Subject odbc with MS-Query
Date
Msg-id 61D1EAA01DEFD111B5D60008C724E5E997E18A@HERMES
Whole thread Raw
Responses RE: odbc with MS-Query
List pgsql-odbc
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


pgsql-odbc by date:

Previous
From: Cedar Cox
Date:
Subject: Re: Postgresql/Cold Fusion cfinsert date problems
Next
From: Paul Haddon
Date:
Subject: Re: Postgresql/Cold Fusion cfinsert date problems