HY000 Driver did not supply an error! on connecting to the PostgreSQL

[GoogleCodeExporter]

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)

Original issue reported on code.google.com by krzyszto...@gmail.com on 16 May 2012 at 7:04

[GoogleCodeExporter]

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.

Original comment by krzyszto...@gmail.com on 16 May 2012 at 10:50

[GoogleCodeExporter]

Can you provide an ODBC trace for me to look at?

Original comment by dkleeham...@gmail.com on 22 Jun 2012 at 9:36

[GoogleCodeExporter]

Windows ODBC trace is here -> http://pastebin.com/RCji91PU
If it is not sufficient, give some clues for generate proper trace dump.

Original comment by krzyszto...@gmail.com on 22 Jun 2012 at 11:53

[GoogleCodeExporter]

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.

Original comment by mkleehammer on 24 Jun 2012 at 11:25

• Changed state: Hold

[GoogleCodeExporter]

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".

Original comment by krzyszto...@gmail.com on 25 Jun 2012 at 12:16