You need to use the same PSQL client version as server version. The 'bitness' of the OS is not as important. If the application is 64 bit, you'll need the 64 bit driver. If the Ruby application is 32 bit, you need the 32 bit ODBC driver. You'll need to download and install the client appropriate for the application. You'll want to be on at least Pervasive PSQL v11.30, preferably Actian PSQL v13 (current version as of December 2018). 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 All workstations in the network get the free Zen Client installed and need not be licensed.įor specific licensing or product questions, please see our main product page.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. Each engine license can be installed to ONE server at a time. You can add more users to an existing server with a User Count Increase license (available in the same sizes).
This engine is licensed by using one "base" license per server, indicating the number of concurrent users that will be accessing that server. You can switch platforms and bit levels at any time. If you have fewer than 5 concurrent users and do not need this growth capability (nor 64-bit capabilities), check out the Workgroup Engine instead.Īt this time, the Zen v13 Server Engine is available for Windows 32-bit or Windows 64-bit, Linux 64-bit, and Mac OSX 64-bit. It is expandable to grow as your business grows. The Actian Zen v13 Server Engine (formerly PSQL v13 Server) is designed to host larger, multi-user systems storing data in the Microkernel format, also known as Btrieve.
0 kommentar(er)
