Pervasive ODBC connection from Linux Ubuntu 64bit - DSNADD not found

Question

I'm trying to connect to Pervasive via ODBC from an Ubuntu 64bit server.

I did the following things:

Installed unixodbc with apt-get command.
Downloaded the Pervasive SQL 64bit Client 11.20 from the Pervasive site (don't know if this is the correct one I have to install)
Extracted the archive and moved to /usr/local/psql

Now, in /usr/local/psql/bin I can only see:

No trace of dsnadd to set the connection driver and the DSN... What I did wrong?

(I'm a Linux novice so any kind of suggestion would be really appreciated)

score 1 · Accepted Answer · answered Jan 09 '13 at 19:00

1

You need the 64 bit driver if you are using a 64 bit application. If you have a 32 bit application, you need the 32 bit driver.

The dsnadd utility seems to be 32 bit. You would need to install the 32 bit client to get that tool.

answered Jan 09 '13 at 19:00

mirtheil

score 1 · Answer 2 · answered Mar 14 '16 at 19:26

I have been trying to get a pervasive client set up on ubuntu as well.

This article was helpful to me, and includes a version of dsnadd edited for 64 bit.

Read the script to be sure, but I don't think you even need this dsnadd utility, as you can edit the odbc.ini manually to do the same thing.

2 Answers2