My favorites | Sign in
Project Home Downloads Wiki Issues Source
New issue   Search
for
  Advanced search   Search tips   Subscriptions
Issue 263: HY000 Driver did not supply an error! on connecting to the PostgreSQL
1 person starred this issue and may be notified of changes. Back to list
Status:  Hold
Owner:  ----


Sign in to add a comment
 
Reported by krzyszto...@gmail.com, May 16, 2012
HY000 Driver did not supply an error! on connecting to the PostgreSQL

What steps will reproduce the problem?
1. ODBC Driver: PostgreSQL Unicode 8.03.04.000 (other versions were tested too, cant remember)
2. tested pyodbc versions 2.1.7, 2.1.11 (2.1.10-beta01), 3.0.5
3. python code http://pastebin.com/wGsA2YEH

What is the expected output? What do you see instead?
Expected:
(5, )

I get:
c:\Vaisala\instalki>bc.py
2.1.10-beta01
Traceback (most recent call last):
  File "c:\Vaisala\instalki\bc.py", line 4, in <module>
    con_pq = pyodbc.connect('DRIVER={PostgreSQL Unicode};SERVER=149.156.110.27;P
ORT=5432;DATABASE=meteo;USERNAME=meteo_adm;PASSWORD=zfs123')
pyodbc.Error: ('HY000', 'The driver did not supply an error!')

What version of the product are you using? On what operating system?
pyodbc versions 2.1.7, 2.1.11 (2.1.10-beta01), 3.0.5 on Windows XP Embedded

Please provide any additional information below.
Log from Windows ODBC Tracing http://pastebin.com/RCji91PU (from multiple (3,4?) bc.py runs)
May 16, 2012
#1 krzyszto...@gmail.com
It works with Python2.5 + pyodbc 2.1.7 on Windows 98 SE and Python2.6 + pyodbc 2.1.11 on Windows XP Home Edition.
Doesn't with Python 2.6 and 2.7.x + pyodbc 2.1.7, 2.1.11 (2.1.10-beta01), 3.0.5 on Windows XP Embedded.
Jun 22, 2012
#2 dkleeham...@gmail.com
Can you provide an ODBC trace for me to look at?
Jun 22, 2012
#3 krzyszto...@gmail.com
Windows ODBC trace is here -> http://pastebin.com/RCji91PU
If it is not sufficient, give some clues for generate proper trace dump.
Jun 24, 2012
Project Member #4 mkleehammer
I am able to connect pyodbc 3.0.6 on Windows, using the 8.03.04.000 driver to a remote PostgreSQL 9.1.0 on Linux.

What is the PostgreSQL server's version?  (Try "select version()" if you can connect in another tool.)

Thanks.
Status: Hold
Jun 24, 2012
#5 krzyszto...@gmail.com
My PostgreSQL Server version is "PostgreSQL 8.4.5 on i386-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.4.4 20100630 (Red Hat 4.4.4-10), 32-bit".
I am able to connect from *Windows XP Embedded* machine using psycopg2 (http://initd.org/psycopg/) and libpq - C library (both solutions aren't using ODBC Driver). When I am trying connect by any pyodbc version, it returns an pyodbc.Error: ('HY000', 'The driver did not supply an error!'). However, connection test done by "ODBC Data Source Administrator" (odbcad32.exe) returns "Connection successful".
Sign in to add a comment

Powered by Google Project Hosting