SQLBase 5.0.1 to SQL Server 1

[swatkins72]

I am having trouble locating an ODBC driver that will still work with the old 16-bit SQLBase. Does anyone know how I can connect from SQL Server to this older database. I have read the threads but they are all relating to the new versions of SQLBase. Thanks!

 

[doomdumas]

HI,
I learned that you should use SQLBase (old compatible version) to unload your database in a .sql file.
this way you can import it in almost all type of database.
I used those command in SQL Talk (using SQLBase 5.2 to deserve my old database)
SET SERVER SERVER1
CONNECT MyOldDataBaseName
UNLOAD DATABASE DATA_AND_SQL.SQL

after thoses command, I got a big file named DATA_AND_SQL.SQL containing all SQL to build the entire Database with data. You can run this .SQL file in another DB and it's done !

 

[swatkins72]

Thank you so much!