Import Gupta SQLBase database into SQL Server
It almost took me two days but I made it to import a SQLBase database into SQL Server. It looks like a lot of people in user groups had problems as well, that's why I don't bother anymore posting my problem, it's not getting answered anyway.
So for all you lot out there dealing with the same issue, here is what I did:
Now, first go to the Gupta website and download the SQLBase 9.0.1 Driver Pack for Windows from http://www.guptaworldwide.com/Products/SQLBase_Prod_Drivers_Download.aspx .
Make sure you reboot after the drivers have been installed. Next make a DSN to the SQLBase database engine. The information you need to enter is quite straight forward but keep in mind that you need to enter a UNC path to the sql.ini file of the machine where the database engine is installed at.
Next, within a DTS you should be able to import data by choosing a Gupta DSN or Gupta OLE DB Provider and voila!
It doesn't look that dificult at all but it still took me two days to get it working.
Now that I know a little SQLBase, I have to say it's a quite interesting product. I think I might fiddle with it for a while.