Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

ODBC driver for unixodbc

13 views
Skip to first unread message

Thomas Kenyon

unread,
Feb 26, 2009, 8:36:56 AM2/26/09
to
Does anyone know where I can get a unixodbc driver for Pervasive 2000i ?

TIA for any help.

BtrieveBill

unread,
Feb 26, 2009, 5:25:51 PM2/26/09
to
I doubt one was ever created. There was a Linux engine, which had an
ODBC driver, but I'm not thinking it'd work on Unix.

Thomas Kenyon

unread,
Feb 26, 2009, 7:02:47 PM2/26/09
to
BtrieveBill wrote:
> I doubt one was ever created. There was a Linux engine, which had an
> ODBC driver, but I'm not thinking it'd work on Unix.
>
Damn, I've read about using unixodbc with pervasive but I guess 2000 may
be too old. (unixodbc is the most common odbc API used in linux)

The shared object in question appears to be called libodbcci.so .
This apaprently used to be available from pervasives site in a tarball.

The linux examples set are still available, but they expect you to
already have the odbc driver. (presumably it expects you to be running
pervasive on the linux machine).

Bre-x

unread,
Apr 13, 2009, 11:16:50 AM4/13/09
to
This is how i did it. I use the 8.70 Client, but you can use your 2000
client


# tar zxf Pervasive.SQL_8.70_Client_Linux.tar.gz
# cd Pervasive.SQL_8.70_Client_Linux
# tar zxf Pervasive.SQL-Client-8.70-014.000.i486.tar.gz
# mkdir /usr/local/psql
# cp -Rv psqlclient/* /usr/local/psql
# cd /usr/local/psql
# etc/clientpostinstall.shAdd a DSN for your dba server

# bin/dsnadd -dsn=dba -host=<your dba server> -sdsn=<the servers
DSN>Move the current odbc.ini out of the way and create a symlink to
the psql odbc.ini in /etc

# cd /etc
# mv odbc.ini odbc.old
# ln -s /usr/local/psql/etc/odbc.iniCreate symlinks for all the odbc
drivers from psql to /usr/lib

# cd /usr/lib/
# ln -s /usr/local/psql/lib/* ./Test the odbc connection

# isql -v dbaAt the prompt do a sql select statement e.g.

SELECT * FROM BKICMSTR

Thomas Kenyon

unread,
Nov 19, 2009, 5:21:00 AM11/19/09
to

Thanks, the problem is, that I only have the windows version of the
Server (CDs) And I can't find a linux client on them.

Zhadnost

unread,
Nov 19, 2009, 7:35:20 AM11/19/09
to
On Nov 19, 10:21 am, Thomas Kenyon <t...@art-it-services.co.uk> wrote:
>
> Thanks, the problem is, that I only have the windows version of the
> Server (CDs) And I can't find a linux client on them.

I just checked the CDs again, and there's only a windows and DOS
client.

Thomas Kenyon

unread,
Nov 22, 2009, 6:26:51 AM11/22/09
to
I've fished the driver out of an update package, (I've not got it
working yet, but that may be a unixodbc problem).
0 new messages