pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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
Message-ID: <001b01beb529$c3d11a20$0a01a8c0@biddersparadise.com> (raw)

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




view thread (7+ messages)  latest in thread

Message-ID: <001b01beb529$c3d11a20$0a01a8c0@biddersparadise.com>
Permalink:  ../001b01beb529$c3d11a20$0a01a8c0@biddersparadise.com/
Also on:    postgresql.org/message-id/001b01beb529$c3d11a20$0a01a8c0@biddersparadise.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: gdaswani@odc.net
  Subject: Re: hacked unixodbc driver..
  In-Reply-To: <001b01beb529$c3d11a20$0a01a8c0@biddersparadise.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox