From: Frank Jördens <frank@joerdens.de>
To: Maarten Boekhold <Maarten.Boekhold@reuters.com>
Cc: pgsql-interfaces@postgresql.org, Thomas Lockhart <lockhart@alumni.caltech.edu>
Subject: Re: confused about *nix ODBC drivers
Date: Mon, 30 Oct 2000 16:30:49 +0100
Message-ID: <39FD9429.A07D2C62@joerdens.de> (raw)
References: <200010301154.MAA29984@rakete.joerdens.de>
Maarten Boekhold wrote:
> Openlink *does* allow you to download an evaluation copy of the multi-tier
> Universal Data Access set (that's the only one that works on UNIX, the
> single-tier editon is only available for windows platforms).
>
> Even if you use Openlink, you would need a separate driver manager. They
> actually recommend iODBC.
What does the multi-tier Universal Data Access set do exactly? Maybe I'm
still unclear about the term multi-tier. For instance, when I use the
Win32 PostgreSQL ODBC driver from my NT box to access the PostgreSQL
server on my Linux computer, is this not already 2-tier (because it
involves a client and a server on physically distinct computers)? Or is
it single tier (because physically distinctness has nothing to do with
it, and the setup just involves a straightforward client-server model
with the ODBC driver/driver manager to mediate between client and
server)?
Currently I am trying to get unixODBC to work, where the
/usr/local/etc/odbc.ini files looks like:
[PostgreSQL]
Description = Test to Postgres
Driver = PostgreSQL
Trace = Yes
TraceFile = sql.log (what's the absolute path? the user's
home dir? I don't find an sql.log file anyhwere.)
Database = intranet
Servername = localhost
UserName =
Password =
Port = 5432
Protocol = 7.1
ReadOnly = No
RowVersioning = No
ShowSystemTables = No
ShowOidColumn = No
FakeOidIndex = No
ConnSettings =
and /usr/local/etc/odbcinst.ini:
[PostgreSQL]
Driver = /usr/local/pgsql/lib/libpsqlodbc.so
FileUsage = 1
Since I've got a line
Servername = localhost
I could presumably also put in the IP address of some server, which
would satisfy my requirement - which is to have the client on a
different box than the server.
This doesn't work yet, though. When I do
------------------------ snip ------------------------
limedes:~ # isql PostgreSQL -v
------------------------ snap ------------------------
I get
------------------------ snip ------------------------
[unixODBC]Missing server name, port, or database name in call to
CC_connect.
[ISQL]ERROR: Could not SQLConnect
------------------------ snap ------------------------
also, what's funny is
------------------------ snip ------------------------
limedes:~ # odbcinst -i -d -f /usr/local/pgsql/etc/odbcinst.ini
[odbcinst] Driver installed. Usage count increased to 3. Target
directory is /usr/lib
------------------------ snap ------------------------
What's it mean by "Target directory is /usr/lib"? This may be the cause
of the problem. There is _nothing_ having anything to do with this setup
in /usr/lib, as far as I can see. I'll be searching for more clues . . .
Regards,
Frank
--
frank joerdens
joerdens new media
urbanstr. 116
10967 berlin
germany
e: frank@joerdens.de
t: +49 (0)30 69597650
f: +49 (0)30 7864046
h: http://www.joerdens.de
pgp public key: http://www.joerdens.de/pgp/frank_joerdens.asc
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: frank@joerdens.de, Maarten.Boekhold@reuters.com, lockhart@alumni.caltech.edu
Subject: Re: confused about *nix ODBC drivers
In-Reply-To: <39FD9429.A07D2C62@joerdens.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox