pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL, ODBC and Applix Data
3+ messages / 3 participants
[nested] [flat]
* PostgreSQL, ODBC and Applix Data
@ 1999-01-19 20:32 William D. McCoy <wdmccoy@geo.umass.edu>
1999-01-20 01:09 ` Re: [INTERFACES] PostgreSQL, ODBC and Applix Data Thomas G. Lockhart <lockhart@alumni.caltech.edu>
0 siblings, 1 reply; 3+ messages in thread
From: William D. McCoy @ 1999-01-19 20:32 UTC (permalink / raw)
To: pgsql-interfaces@hub.org
Has anyone managed to access PostgreSQL using Applix Data via ODBC?
Can it be done? If so, please contact me and give me some hints.
Thanks.
(Sorry to repeat the message that I sent yesterday. When I didn't see
my message I realized I was not subscribed to pgsql-interfaces, but
was only getting messages from other pgsql lists that were Cc'd to
this list. My message and any replies are not in the archives, but it
is perhaps to soon for that. So if you answered my message to the
list already, could you please resend your answer to me?)
--
William D. McCoy
Geosciences
University of Massachusetts
Amherst, MA 01003
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] PostgreSQL, ODBC and Applix Data
1999-01-19 20:32 PostgreSQL, ODBC and Applix Data William D. McCoy <wdmccoy@geo.umass.edu>
@ 1999-01-20 01:09 ` Thomas G. Lockhart <lockhart@alumni.caltech.edu>
0 siblings, 0 replies; 3+ messages in thread
From: Thomas G. Lockhart @ 1999-01-20 01:09 UTC (permalink / raw)
To: William D. McCoy <wdmccoy@geo.umass.edu>; +Cc: pgsql-interfaces@hub.org
> Has anyone managed to access PostgreSQL using Applix Data via ODBC?
> Can it be done? If so, please contact me and give me some hints.
> Thanks.
Yes. Both "standalone" and "integrated" installations of psqlODBC are
available, where the integrated installation is done from within a full
from-source Postgres installation.
You should use Postgres v6.4.2 (or v6.4) and look in the chapter on ODBC
in the integrated docs (under postgres.html).
Good luck.
- Tom
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re:[INTERFACES] PostgreSQL, ODBC and Applix Data
@ 1999-01-20 09:11 Rolf Luettecke <rluettecke@gcd.de>
0 siblings, 0 replies; 3+ messages in thread
From: Rolf Luettecke @ 1999-01-20 09:11 UTC (permalink / raw)
To: pgsql-interfaces@hub.org
William D. McCoy wrote:
>
> > Has anyone managed to access PostgreSQL using Applix Data via ODBC?
> > Can it be done? If so, please contact me and give me some hints.
>
I´ve installed Postgres 6.4x and libpsqlodbc 0.25 on HOST1, installed
applix on WORKSTATION2, made an entry in
$HOME/.odbc.ini, for example:
[ODBC Data Sources]
psg01=PostgreSQL on HOST1
[psg01]
Trace=1
TraceFile=/var/log/psg01.log
Driver=/opt/applix/axdata/axshlib/lib/libpsqlodbc.so.0.25
Description="Data-Warehouse on HOST1"
Servername=host1.domain.de
Port=5432
Database=warehouse
ReadOnly=0
TextAsLongVarchar=0
had a quick look at $APPLIX/axdata/axnet.cnf:
setenvFor elfodbc /ax/axexec/axdata/axshlib
libFor elfodbc /opt/applix/axdata/axshlib/lib
Then I setup an appropriate entry in the postgres access-control file
$PGDATA/pg_hba.conf.
Restart applix/axdata, select server (the entry from .odbc.ini must appear),
select the new dsn, provide username and password - voila my tables.
Any typo´s, did I forgot something :-))
Yes, I did, happy 1999 to all - especially to Tom, Peter, Byron and trotfhcap.
---------------------------
Rolf Lüttecke
GCD - Systemhaus mbH
49084 Osnabrück
Internet Business Solutions
rluettecke@gcd.de
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1999-01-20 09:11 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-01-19 20:32 PostgreSQL, ODBC and Applix Data William D. McCoy <wdmccoy@geo.umass.edu>
1999-01-20 01:09 ` Thomas G. Lockhart <lockhart@alumni.caltech.edu>
1999-01-20 09:11 Re:[INTERFACES] PostgreSQL, ODBC and Applix Data Rolf Luettecke <rluettecke@gcd.de>
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