Skip site navigation (1) Skip section navigation (2)

hacked unixodbc driver..

From: "George Henry C(dot) Daswani" <gdaswani(at)odc(dot)net>
To: <pgsql-interfaces(at)postgresql(dot)org>
Subject: hacked unixodbc driver..
Date: 1999-06-12 23:17:37
Message-ID: 001b01beb529$c3d11a20$0a01a8c0@biddersparadise.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
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


Responses

pgsql-interfaces by date

Next:From: Brent WaldropDate: 1999-06-13 06:11:20
Subject: odbc update problems?
Previous:From: Abd-Allah Abdul KarimDate: 1999-06-11 02:22:45
Subject: PSQLODBC FAQ

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group