google-code-export / pyodbc

Automatically exported from code.google.com/p/pyodbc
MIT No Attribution
1 stars 0 forks source link

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

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
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 commented 9 years ago
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 commented 9 years ago
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 commented 9 years ago
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 commented 9 years ago
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

GoogleCodeExporter commented 9 years ago
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