installation of odbc

From: Wolfgang Meiners <WolfgangMeiners01(at)web(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: installation of odbc
Date: 2003-11-16 15:09:23
Message-ID: 200311161609.23665.WolfgangMeiners01@web.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Halle there,
excuse my bad english, but this is not my native language.

I have a problem, installing odbc-support for postgresql.

The situation: I have suse linux 8.2 with postgrsql 7.3.2-24 and openoffice
1.02-30. I downloaded postgresql 7.3.4 and installed it from sources. i tried
out pgaccess3, PhpPgsql and pgsql and everything worked fine.

Then i downloaded and installed OpenOffice.org 1.1 and wanted to connect from
this to Postgresql via odbc. For this, i downloaded psqlodbc-07.03.0200 and
installed this from sources via
./configure,
make
make install

This gave me the file
/usr/local/lib/psqlodbc.so

I tried to connect via ODBCConfig and found out, that i need files
psqlodbc.so, and
libpsqlodbcS.so, for the setup. The only psqlodbdS.so file, i found in my
system was
/usr/lib/unixODBC/libodbcpsqlS.so
and so i took this file. The result is, i can not connect to postgresql via
OpenOffice or unixODBC's DataManager. I get the errormessage
[unixODBC]Missing server name, port, or database name in call to CC_connect.

I believe, the error is the wrong setup-file
/usr/lib/unixODBC/libodbcpsqlS.so, which probably belongs to postgresql
7.3.2-24 from suse linux. But i did not find any information about a
postgresql version in psqlodbc-07.03.0200. Additionaly, i found no
information about the setup-file
libodbcpsqlS.so

So i need help in the correct installation of postgresql with odbc support.
Thank you very much for all informations.
Wolfgang Meiners

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Oliver Elphick 2003-11-16 19:43:14 Re: installation of odbc
Previous Message Philippe Lang 2003-11-16 13:24:19 MS Access, Unicode, Conversions & Foreign languages characters