| 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 |
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
Jun 22, 2012
Can you provide an ODBC trace for me to look at?
Jun 22, 2012
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
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
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". |