| Computers Forum Index » Computer - Databases - Btrieve » ODBC driver for unixodbc... |
|
Page 1 of 1 |
|
| Author |
Message |
| Thomas Kenyon... |
 Posted: Thu Feb 26, 2009 7:36 pm |
|
|
|
Guest
|
Does anyone know where I can get a unixodbc driver for Pervasive 2000i ?
TIA for any help. |
|
|
| Back to top |
|
|
|
| BtrieveBill... |
| Posted: Fri Feb 27, 2009 4:25 am |
|
|
|
Guest
|
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 wrote:
Quote: Does anyone know where I can get a unixodbc driver for Pervasive 2000i ?
TIA for any help. |
|
|
| Back to top |
|
|
|
| Thomas Kenyon... |
| Posted: Fri Feb 27, 2009 6:02 am |
|
|
|
Guest
|
BtrieveBill wrote:
Quote: 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). |
|
|
| Back to top |
|
|
|
| Bre-x... |
| Posted: Mon Apr 13, 2009 3:16 pm |
|
|
|
Guest
|
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 |
|
|
| Back to top |
|
|
|
| Bre-x... |
| Posted: Mon Apr 13, 2009 3:16 pm |
|
|
|
Guest
|
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 |
|
|
| Back to top |
|
|
|
| Zhadnost... |
| Posted: Thu Nov 19, 2009 12:35 pm |
|
|
|
Guest
|
On Nov 19, 10:21 am, Thomas Kenyon <t... at (no spam) art-it-services.co.uk> wrote:
Quote:
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. |
|
|
| Back to top |
|
|
|
| Thomas Kenyon... |
| Posted: Thu Nov 19, 2009 3:21 pm |
|
|
|
Guest
|
Bre-x wrote:
Quote: 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
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. |
|
|
| Back to top |
|
|
|
| Thomas Kenyon... |
| Posted: Sun Nov 22, 2009 4:26 pm |
|
|
|
Guest
|
Zhadnost wrote:
Quote: On Nov 19, 10:21 am, Thomas Kenyon <t... at (no spam) 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.
I've fished the driver out of an update package, (I've not got it
working yet, but that may be a unixodbc problem). |
|
|
| Back to top |
|
|
|
|
