Skip site navigation (1) Skip section navigation (2)

odbc with MS-Query

From: BELLON Michel <Michel(dot)Bellon(at)lcie(dot)fr>
To: pgsql-odbc(at)postgresql(dot)org
Subject: odbc with MS-Query
Date: 2001-06-26 10:41:56
Message-ID: 61D1EAA01DEFD111B5D60008C724E5E997E18A@HERMES (view raw or flat)
Thread:
Lists: 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


Responses

pgsql-odbc by date

Next:From: Olivier BergerDate: 2001-06-26 13:14:14
Subject: Quick HOWTO - connecting StarOffice Win or Lin to PostGreSQL using ODBC
Previous:From: DI HasenöhrlDate: 2001-06-26 10:37:14
Subject: How to combine multiple field primary key and Row Versioning

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group