Message-ID: <001b01beb529$c3d11a20$0a01a8c0@biddersparadise.com>
From: "George Henry C. Daswani" <gdaswani@odc.net>
To: <pgsql-interfaces@postgresql.org>
Subject: hacked unixodbc driver..
Date: Sat, 12 Jun 1999 16:17:37 -0700
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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