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
