An ODBC or .NET DataProvider driver for Centura SQLbase is required

Question

For the Client, we need to import data from the old

Centura SQLBase 7.5.1 

Database. The best way would be to directly connect from .Net to the client database, but I cannot find the driver or .Net Connector to use.

So far I have learned that the company behind the product is currently: http://www.unify.com/ But before I contact them, is there a freely available driver / connector for SQLBase?

Answer 1

It was hard to find, but in the end I found a download:

http://support.guptatechnologies.com/supportwiki/index.php/SQLBase_Driver_Packs

To get the result, you should query your favorite search engine for "SQLBase Driver Packs" instead of ".NET Data Provider". The installer contains the ODBC / .NET / OLEDB and JDBC drivers.

However, I could not connect to my database in any way, because the installer (I tried installing 9.0.1 and 10.0.0) was broken.

Failed to get 10.0.0 to work, but for version 9.x I manually copied these files:

 - SQLBaseUtil.dll - MFC71.dll - msvcr71.dll - msvcp71.dll 

from the installation path to my system32 folder. This worked for Windows XP and Windows 7, but for Windows 7 I also needed to determine the path to the ini file in the connection string:

 var connectionString = "data source=ISLAND;" + "uid=sysadm;pwd=sysadm;" + "ini=C:\\Program Files\\Gupta\\SQLBase901\\sql.ini";