From: | "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu> |
---|---|
To: | Aleksey Demakov <avd(at)gcom(dot)ru>, MrLinux(at)applix(dot)com, Gerald Gryschuk <ggryschuk(at)scf(dot)sk(dot)ca> |
Cc: | Postgres Hackers List <hackers(at)postgresql(dot)org> |
Subject: | Re: [INTERFACES] psqlodbc |
Date: | 1998-07-31 02:44:56 |
Message-ID: | 35C12FA8.3C363743@alumni.caltech.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-interfaces |
> > 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...
From | Date | Subject | |
---|---|---|---|
Next Message | Vadim Mikheev | 1998-07-31 02:46:30 | Re: [HACKERS] proposals for LLL, part 2 (locking) |
Previous Message | Vadim Mikheev | 1998-07-31 02:27:29 | Re: [HACKERS] join problems: FATAL 1: palloc failure: memory exhausted |
From | Date | Subject | |
---|---|---|---|
Next Message | Reynald pro | 1998-07-31 09:23:56 | Re: How to connect Postgres via ODBC |
Previous Message | Jackson, DeJuan | 1998-07-30 18:13:51 | RE: [INTERFACES] How to connect Postgres via ODBC |