Hello,
I hacked the unix odbc driver that comes with the postgresql 6.5
snapshots and incorporated the GetPrivateProfileString Parsing functions
from the IODBC driver manager (libiodbc-2.50.2). The current unix odbc
driver that comes with postgresql has a very buggy GetPrivateProfileString
and it dumps core from time to time, plus it's not too compatible with tabs
and nulls on fields which the libiodbc GetPrivateProfileString doesn't have
a problem with. It also incorporates the latest odbc src (windows)..
I've used this driver with Solaris X86 2.7 / RedHat linux 6.0 without any
problems...
It also works great with PHP 3.0.9 and DBD-ODBC-20.. :) This way I can run
the same php scripts on both windows and linux/solaris platforms.. :)
you will need http://www.openlinksw.com/iodbc and download the latest iodbc
driver manager..
(2.50.2) compile and install it, make sure it puts it's odbc.ini in /etc
grab the hacked unix odbc driver from
http://www.odc.net/~gdaswani/sources/odbc.tar.gz
tar -zxvf the file on your ~postgresql-snapshot src/interfaces dir..
The remake postgres with
./configure --prefix=FILLINPREFIX --with-odbc --with-odbcinst=/etc
an example odbc.ini file.
/etc/odbc.ini
;
;
;
[ODBC Data Sources]
Openlink = Openlink (MT)
template1 = template1
[template1]
Driver = /opt/pgsql/lib/libpsqlodbc.so
Description = PostgreSQL Template1 Database
Servername = localhost
Username =
Password =
Database = template1
Protocol = 6.4
Options =
ReadOnly = no
Debug = 0
Comm = 1
(If Debug = 1, puts debugging info on /tmp and if Comm = 1, puts debugging
info on /tmp)..
George Daswani