Hello,
I have been trying for a VERY LONG time to get PostgreSQL 7.0.x to talk
to various odbc managers such as unixODBC and OpenLink iODBC which is
the latest.
The problem is that no matter what I try, I am getting the errors that
it cannot connect to the database server.
My development system is a PIII 500Mhz running Mandrake Linux 7.2 and I
have installed the Postgresql 7.0.3 mdk rpms and also Postgresql-odbc
7.0.3-8mdk.rpm as well with the drivers.
With OpenLink iODBC version 2.50-3, my configuration files are:
odbc.ini
;
; odbc.ini
;
[ODBC Data Sources]
OpenLink = OpenLink (MT)
[PostgreSQL]
Description = PostgreSQL driver for Linux
Driver = PostgreSQL
Trace = Yes
TraceFile = /tmp/sql.log
Host = localhost
ServerType = PostgreSQL
FetchBufferSize = 99
UserName =
Password =
Database =
ServerOptions =
ConnectOptions =
Options =
ReadOnly = no
Port = 5432
;Protocol = 6.4
;RowVersioning = No
;ShowSystemTables = No
;ShowOidColumn = No
;FakeOidIndex = No
;ConnSettings =
------------------------------------------------------------------
and odbcinst.ini
------------------------------------------------------------------
[PostgreSQL]
Description = PostgreSQL driver for Linux
Driver = /usr/lib/libodbcpsql.so
Setup = /usr/lib/libodbcpsqlS.so
FileUsage = 1
-------------------------------------------------------------------
I have tried to simply run the "postgresql" script located in the
/etc/init.d directory and also have tried to run:
su -l postgres -c "postmaster -i -d 2 -p 5432 -D /var/lib/pgsql/data "
but in every case it seems to be the same thing and I am not sure if
your drivers are working.
My goal is to use PosegreSQL 7.0.3 with MetaHTML to interface to some
HTML code for our site being developed.
Can you please help???
Best Regards,
Lonnie Cumberland
------------------------------------------------------------------