| Issue 176: | PostgreSQL Unicode Driver not able to connect | |
| 1 person starred this issue and may be notified of changes. | Back to list |
What steps will reproduce the problem?
1. pyodbc.connect("DRIVER={PostgreSQL Unicode};SERVER=servername;DATABASE=databasename;UID=myuser;PWD=mypass")
What is the expected output? What do you see instead?
Expects to connect to my database server. Get this error instead:
Error Traceback (most recent call last)
/tmp/<ipython console> in <module>()
Error: ('0', '[0] [unixODBC]c (0) (SQLDriverConnectW)')
What version of the product are you using? On what operating system?
Client system:
Ubuntu 11.04 amd64 kernel 2.6.38.2
unixodbc 2.2.14p2-2ubuntu1
python-pyodbc 2.1.7-1build1
python2.6 2.6.6-6ubuntu7
odbc-postgresql 1:08.03.0200-1.2
Database host system:
Debian 6.0 amd64 kernel 2.6.32-5-amd64 (default debian kernel image)
postgresql-8.4 8.4.7-0squeeze2
Please provide any additional information below.
Output of /etc/odbcinst.ini
[PostgreSQL ANSI]
Description = PostgreSQL ODBC driver (ANSI version)
Driver = /usr/lib/odbc/psqlodbca.so
Setup = /usr/lib/odbc/libodbcpsqlS.so
Debug = 0
CommLog = 1
UsageCount = 1
Threading = 2
[PostgreSQL Unicode]
Description = PostgreSQL ODBC driver (Unicode version)
Driver = /usr/lib/odbc/psqlodbcw.so
Setup = /usr/lib/odbc/libodbcpsqlS.so
Debug = 0
CommLog = 1
UsageCount = 1
Threading = 2
If I connect with the ANSI driver it works as intended.
May 23, 2011
#1
rhbl...@gmail.com
Sep 29, 2012
I'm pretty sure this works now. I run the OS/X PostgreSQL tests with the Unicode driver.
Status:
Complete
Sep 29, 2012
Brilliant, will check it out! |