Sender: tgl@mythos.jpl.nasa.gov
Message-ID: <35C12FA8.3C363743@alumni.caltech.edu>
Date: Fri, 31 Jul 1998 02:44:56 +0000
From: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
Organization: Caltech/JPL
MIME-Version: 1.0
To: Aleksey Demakov <avd@gcom.ru>, MrLinux@applix.com,
	Gerald Gryschuk <ggryschuk@scf.sk.ca>
CC: Postgres Hackers List <hackers@postgresql.org>
Subject: Re: [INTERFACES] psqlodbc
References: <35BD35D5.AAFAFC7D@alumni.caltech.edu>
	<867m0y8oee.fsf@avd.gcom.ru> <35C0004C.309D442F@alumni.caltech.edu>
	<867m0vhikx.fsf@avd.gcom.ru>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

> > Anyway, I now have a sharable library, and ApplixWare is running. 
> > But I don't see any candidate servers...
> > I made a ~/.odbc.ini file...
> you need one other entry which corresponds to the Postgres entry...
> You'll then see a "Postgres Database" entry in the appropriate Data
> dialog box.

OK, I followed this suggestion from the Applix folks and it helped. Here
is the file which does better:

<start .odbc.ini file>
[ODBC Data Sources]
Postgres = Postgres Data

[Postgres]
Debug = 0
CommLog = 1
Driver = /opt/postgres/current/lib/libpsqlodbc.so

<eof>

An now Applix can see some candidates. I then got an error from Applix
regarding a missing library:

/opt/applix/axdata/elfodbc: can't load library 'libodbc.so'

which was apparently in the wrong directory in the Applix distribution.
So, I made a soft link to the normal directory area, and now Applix got
further, asking me for a username and password. However, I got the
following error after that:

/opt/applix/axdata/elfodbc: can't resolve symbol 'parse_statement'

When I run "nm" on /opt/postgres/current/lib/libpsqlodbc.so.0.24 I see
the following entry:

mythos> nm libpsqlodbc.so.0.24 | grep -i parse_statement
         U parse_statement

which indicates an unresolved symbol. So, I found that parse.c was not
being compiled by Makefile.unx (and my derivative) so got that compiled
and linked and things are much closer to working! :)

OK, so now I get an error message saying:

 missing a username, port, or server name

if I use an entry in .odbc.ini which only specifies the driver library
(as above), and I get a similar error message when I specify an
.odbc.ini entry which looks like:

[PostgresFull]
DSN = test
Server = localhost
UID = tgl
Port = 5432
Driver = /opt/postgres/current/lib/libpsqlodbc.so

If I explicitly type the server name (as "localhost") in the Applix
dialog box, I get a different error message:

axnet: Cannot launch gateway on server
not a tcp service in /etc/services

So, anyone have any other hints? What information must be in a real
.odbc.ini file for MySQL to work? I don't have much security turned on
in Postgres, but do have the TCP/IP option specified on the server.

Tried adding an entry in /etc/services, but that alone didn't change the
error message. Anyone have more hints?? :)

                     - Tom

Oh, btw I have started fixing up a makefile which actually fits into the
Postgres distribution...