Re: confused about *nix ODBC drivers

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(at)joerdens(dot)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