Re: confused about *nix ODBC drivers - Mailing list pgsql-interfaces

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