The short answer would be to install the Pervasive PSQL client on the Ubuntu machine, create the ODBC Datasource name pointing to the database on the Windows machine and then use ODBC from within Ruby to access the data. Pervasive PSQL and Microsoft SQL Server are not the same product and the client for one cannot connect to the server of the other. In fact, this question mentions that FreeTDS doesn't work to Pervasive PSQL. I've never heard of using the FreeTDS driver to connect to Pervasive PSQL. You need to use the Pervasive Client ODBC driver.
Please helpĪs far as I know, the only way to access Pervasive PSQL from Ruby would be through ODBC. Not able to understand the above result and how to handle this. This program shows an interactive SQL processor There was a problem connecting to the server iodbctest Unable to connect: Adaptive Server is unavailable or does not exist Tsql -S pserver -U db_username -P db_password -d MyDatabasename In /etc/odbc.ini, client and database details Setup=/usr/lib/x86_64-linux-gnu/odbc/libtdsS.so Under /etc/odbcinst.ini, I have saved the driver info like below ĭriver=/usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so Thanks in advanceīelow is my configuration on linux machine I am trying to connect to a Pervasive Sql Server which is running on Windows machine from my Ruby application which is on Ubuntu Machine.
