I'm trying to link a SQLBase database from ADP to my SQL Server so that I can use it with other databases in the SQL Server 2000. However, I'm having issue trying to create the link.
When linking, in the General tab, I put in the linked Server name, select the Gupta SQLBase OLE DB Provider, put in product name, data source (assume this is a datasource that is already connecting to this database), and provider string which similar to the following: DSN=SQLBase Island;SERVER=SERVER1;DATABASE=PAYROLL;
However, no luck. Anyone able to successfully done this or know how to go about getting this to work?