dbTalk Databases Forums  

ODBC driver for unixodbc

comp.databases.btrieve comp.databases.btrieve


Discuss ODBC driver for unixodbc in the comp.databases.btrieve forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Thomas Kenyon
 
Posts: n/a

Default ODBC driver for unixodbc - 02-26-2009 , 07:36 AM






Does anyone know where I can get a unixodbc driver for Pervasive 2000i ?

TIA for any help.

Reply With Quote
  #2  
Old   
BtrieveBill
 
Posts: n/a

Default Re: ODBC driver for unixodbc - 02-26-2009 , 04:25 PM






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.

Reply With Quote
  #3  
Old   
Thomas Kenyon
 
Posts: n/a

Default Re: ODBC driver for unixodbc - 02-26-2009 , 06:02 PM



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).


Reply With Quote
  #4  
Old   
Bre-x
 
Posts: n/a

Default Re: ODBC driver for unixodbc - 04-13-2009 , 10:16 AM



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

Reply With Quote
  #5  
Old   
Thomas Kenyon
 
Posts: n/a

Default Re: ODBC driver for unixodbc - 11-19-2009 , 04:21 AM



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.

Reply With Quote
  #6  
Old   
Zhadnost
 
Posts: n/a

Default Re: ODBC driver for unixodbc - 11-19-2009 , 06:35 AM



On Nov 19, 10:21*am, Thomas Kenyon <t... (AT) art-it-services (DOT) 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.

Reply With Quote
  #7  
Old   
Thomas Kenyon
 
Posts: n/a

Default Re: ODBC driver for unixodbc - 11-22-2009 , 05:26 AM



Zhadnost wrote:
Quote:
On Nov 19, 10:21 am, Thomas Kenyon <t... (AT) art-it-services (DOT) 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).

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.