pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedODBC connect from Linux to Postgresql db server
5+ messages / 3 participants
[nested] [flat]
* ODBC connect from Linux to Postgresql db server
@ 1999-11-01 23:27 Aage J. Skjolingstad <Aages@aajs.com>
0 siblings, 1 reply; 5+ messages in thread
From: Aage J. Skjolingstad @ 1999-11-01 23:27 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] ODBC connect from Linux to Postgresql db server
@ 1999-11-03 21:15 Aage J. Skjolingstad <Aages@aajs.com>
parent: Aage J. Skjolingstad <Aages@aajs.com>
0 siblings, 1 reply; 5+ messages in thread
From: Aage J. Skjolingstad @ 1999-11-03 21:15 UTC (permalink / raw)
To: pgsql-interfaces
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.
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] ODBC connect from Linux to Postgresql db server
@ 1999-11-04 15:59 Thomas Lockhart <lockhart@alumni.caltech.edu>
parent: Aage J. Skjolingstad <Aages@aajs.com>
0 siblings, 0 replies; 5+ messages in thread
From: Thomas Lockhart @ 1999-11-04 15:59 UTC (permalink / raw)
To: Aage J. Skjolingstad <Aages@aajs.com>; +Cc: pgsql-interfaces
> 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: [INTERFACES] ODBC connect from Linux to Postgresql db server
@ 1999-11-04 16:30 Ansley, Michael <Michael.Ansley@intec.co.za>
0 siblings, 1 reply; 5+ messages in thread
From: Ansley, Michael @ 1999-11-04 16:30 UTC (permalink / raw)
To: 'Thomas Lockhart ' <lockhart@alumni.caltech.edu>; +Cc: pgsql-interfaces
I've just recently been to the unixODBC site, and they seem pretty keen on
maintaining 3.5 compliancy. I'm not sure if they've updated the PG driver,
but AFAIK we maintain 2.5 (or 2.0) compliancy (right??), so it might be an
idea to see what they've done and perhaps use anything useful.
MikeA
-----Original Message-----
From: Thomas Lockhart
To: Aage J. Skjolingstad
Cc: pgsql-interfaces@postgreSQL.org
Sent: 11/4/99 5:59 PM
Subject: Re: [INTERFACES] ODBC connect from Linux to Postgresql db server
> 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
************
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] ODBC connect from Linux to Postgresql db server
@ 1999-11-04 16:51 Thomas Lockhart <lockhart@alumni.caltech.edu>
parent: Ansley, Michael <Michael.Ansley@intec.co.za>
0 siblings, 0 replies; 5+ messages in thread
From: Thomas Lockhart @ 1999-11-04 16:51 UTC (permalink / raw)
To: Ansley, Michael <Michael.Ansley@intec.co.za>; +Cc: pgsql-interfaces
> I've just recently been to the unixODBC site, and they seem pretty keen on
> maintaining 3.5 compliancy. I'm not sure if they've updated the PG driver,
> but AFAIK we maintain 2.5 (or 2.0) compliancy (right??), so it might be an
> idea to see what they've done and perhaps use anything useful.
Patches accepted ;)
afaik there aren't any current maintainers who can take this on, but
if it interests someone, then there is a very useful role to fill...
- Thomas
--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~1999-11-04 16:51 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-11-01 23:27 ODBC connect from Linux to Postgresql db server Aage J. Skjolingstad <Aages@aajs.com>
1999-11-03 21:15 ` Aage J. Skjolingstad <Aages@aajs.com>
1999-11-04 15:59 ` Thomas Lockhart <lockhart@alumni.caltech.edu>
1999-11-04 16:30 RE: [INTERFACES] ODBC connect from Linux to Postgresql db server Ansley, Michael <Michael.Ansley@intec.co.za>
1999-11-04 16:51 ` Thomas Lockhart <lockhart@alumni.caltech.edu>
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