Dear all,
I’m trying to set up a connection to a PostgreSQL database as external data source. I’m using the odbc-postgresql
driver and I have two DSNs configured, one for ANSI and the other one for Unicode.
So far I’m able to connect to the two data sources via isql
and I’m also able to connect to the ANSI DSN via the Virtuoso Conductor. Unfortunately the Unicode DSN returns me a not easy to understand error:
My odbcinst.ini
is as follows:
[ODBC Drivers]
OpenLink Virtuoso=Installed
OpenLink Virtuoso (Unicode)=Installed
PostgresSQL ANSI=Installed
PostgresSQL Unicode=Installed
[OpenLink Virtuoso]
Driver=/opt/virtuoso/lib/virtodbc_r.so
[OpenLink Virtuoso (Unicode)]
Driver=/opt/virtuoso/lib/virtodbcu_r.so
[PostgreSQL ANSI]
Description=PostgreSQL ODBC driver (ANSI version)
Driver=/usr/lib/x86_64-linux-gnu/odbc/psqlodbca.so
Setup=/usr/lib/x86_64-linux-gnu/odbc/libodbcpsqlS.so
[PostgreSQL Unicode]
Description=PostgreSQL ODBC driver (Unicode version)
Driver=/usr/lib/x86_64-linux-gnu/odbc/psqlodbcw.so
Setup=/usr/lib/x86_64-linux-gnu/odbc/libodbcpsqlS.so
My odbc.ini
is as follows:
[ODBC Data Sources]
Local Virtuoso = OpenLink Virtuoso
Local Virtuoso (Unicode) = OpenLink Virtuoso
PostgreSQLdevANSI = PostgreSQL
PostgreSQLdevUnicode = PostgreSQL
[Local Virtuoso]
Driver = OpenLink Virtuoso
Address = localhost:1111
[Local Virtuoso (Unicode)]
Driver = OpenLink Virtuoso
Address = localhost:1111
[PostgreSQLdevANSI]
Description=PostgreSQL ANSI dev
Driver=PostgreSQL ANSI
Database=Test
Servername=localhost
UserName=www-data
Password=www-data
Port=5432
[PostgreSQLdevUnicode]
Description=PostgreSQL Unicode dev
Driver=PostgreSQL Unicode
Database=Test
Servername=localhost
UserName=www-data
Password=www-data
Port=5432
Could you please help me debug this?
Many thanks
Pasquale