[unixODBC-support] unixODBC and PervasiveSQL

Nick Gorham nick.gorham at easysoft.com
Thu Jul 10 09:29:24 BST 2008


Franco Brusatti wrote:

>Hi all,
>
>I'm in a big trouble. I need to connect Pervasive SQL Database in a windows server from my ubuntu.I test everything but I couldn't.
>
>I have installed unixODBC-2.2.11. I don't know where get the PervasiveSQL driver so I donwnload a trial version of the DB server and I installed it to get libsrde.so and libodbcci.so that saw in some examples of configurations.
>Do you know some driver that allows to do
>connections of this kind? Any response will be helpful because I don't
>have more ideas.
>
>My /etc/odbc.ini 
>*********************************************
>[ODBC Data Sources]
>DEMODATA    = Pervasive ODBC 
>DEFAULTDB   = Pervasive ODBC 
>LINUXTESTDB = Pervasive ODBC
>
>[DEMODATA]
>Description = Pervasive ODBC Engine Interface
>DBQ         = DEMODATA
>Server      =  192.168.3.51
>User        = 
>Password    =
>Driver      = Pervasive 
>OpenMode    = 0
>
>[DEFAULTDB]
>Driver      = /usr/local/psql/lib/libodbcci.so
>DBQ         = DEFAULTDB
>Server      = 192.168.3.51
>Port        = 1583
>
>[LINUXTESTDB]
>Driver      = Pervasive
>DBQ        = LINUXTESTDB
>*********************************************
>
>
>My /etc/odbcinst.ini
>*********************************************
>[Pervasive]
>Description     = Pervasive
>Driver          = /usr/local/psql/lib/libsrde.so
>#Driver          = /usr/local/psql/lib/libodbcci.so
>#I don't know what driver I should use to connect with pervasive
>*********************************************
>
>$ isql -w DEMODATA
>$ isql -w DEFAULTDB
>$ isql -w LINUXTESTDB
>
>$ [S1000][unixODBC][Pervasive][ODBC Engine Interface][Data Record Manager]Cannot locate the named database you specified(Btrieve Error 2301)
>  
>
This seems to offer some suggestions about what ini entries to try

http://cs.pervasive.com/forums/t/10794.aspx

-- 
Nick Gorham
Easysoft Limited
http://www.easysoft.com, http://www.unixODBC.org




More information about the unixODBC-support mailing list