SQL Server Linked Server to SQLbase connection using an OLEDB provider

I am trying to connect from MS SQL Server using a linked server with an OLEDB connection to a SQLBASE database on a different host server but having difficulties formulating the Provider string/SQL Server Linked server and hoping someone can point me in the right direction.

In the SQL Server Linked server connection dialogue I have the following

Provider: Gupta SQLBase 12.2 OLE DB Provider
Product name:
Data source:
Provider string:

The SQLbase database and host information I have is

Host Windows Server = host01
SQLBase Server Name =server1
database = mydb
User = mylogin
password = password

What do I need to enter in the Data source and Provider string fields to establish a connection . Also is it possible to add isolation level of Read Only to this string ?

Any help greatly appreciated as I have zero knowlege of SQLbase but just need to extract data from the database on a regular basis

0 answers