From: | "Aage J(dot) Skjolingstad" <Aages(at)aajs(dot)com> |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | ODBC connect from Linux to Postgresql db server |
Date: | 1999-11-01 23:27:59 |
Message-ID: | 381E21FF.966C8505@aajs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
Novice to Postgresql and Linux trying to get away from M$, but need lots
of help.
Have posted similar question at the list, but no response.
Here is my set-up, all connected via one hub and ethernet cards.
A) Postgresql db on one Linux box - RH 6.0 / Postgresql 6.5.2. Test
database running clean with postmaster -1up and running.
B) Test Webserver, WebSitePro on W98 with PsqlODBC and PgAdmin
installed. I used latest to transfer my db from Access to the db-server
(A).
This server is using iHTML from Inline for scripting and linking the web
pages / SQL commands. Everything here looks and works correct.
C) Test Webserver, Apache on Linux RH 6.0. iHTML installed and working.
Also installed is Postgresql (client) and postgresql-odbc 6.5.2.
Here is the problem:
I do not know how and I can not get "C" to connect to the database on
"A". I am using the ODBC Manger that came with iHTML which I believe is
the freeODBC. Have tried to configure iodbc.ini in hundred different
ways and used days reading mailing lists.
Only results; Error message: "Missing server name, port or database name
in call
to CC_connect".
Found one posting on iHTML's Conference Board, saying:
Quote:
changed the file dlg_specific.h in the postres odbc source. There was a
line with:
#define ODBC_INI ".odbc.ini"
I changed this to
#define ODBC_INI "/usr/ihtml/iodbc.ini" ... and it works.
Unquote.
Comments, and id any detailed instructions available, - will be
appreciated.
Regards,
Aage J. Skjolingstad
From | Date | Subject | |
---|---|---|---|
Next Message | StOo | 1999-11-02 11:01:16 | sequences |
Previous Message | Adolfo Diaz | 1999-11-01 13:00:50 | [INTERFACES] ODBC driver |