ODBC connect from Linux to Postgresql db server

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

Responses

Browse pgsql-interfaces by date

  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