Thread: ODBC connect from Linux to Postgresql db server

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

No much responce from the list, but I got it running anyway using
unixODBC.

Sure, I got some valuable help from Drew Whittle (NZ) and reading a bit
more at the http://www.unixodbc.org site, it compiled and installed on
my RH 6.1 whitout any problems, - even including a nice GUI.

One more question though for a novice: 

1) The Postgresql-odbc included w/ 6.5.2 is that different for the
unixODBC included driver ?

Sincerely,

Aage

"Aage J. Skjolingstad" wrote:
> 
> 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.
>

> One more question though for a novice:
> 1) The Postgresql-odbc included w/ 6.5.2 is that different for the
> unixODBC included driver ?

It may be very similar. My recollection is that there was a code fork
when someone from unixODBC took the code, because he didn't want to
bother updating us :(

But maybe there have been no changes??
                    - Thomas

-- 
Thomas Lockhart                lockhart@alumni.caltech.edu
South Pasadena, California