×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

SQLBase 5.0.1 to SQL Server

SQLBase 5.0.1 to SQL Server

SQLBase 5.0.1 to SQL Server

(OP)
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!

RE: SQLBase 5.0.1 to SQL Server

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 !

RE: SQLBase 5.0.1 to SQL Server

(OP)
Thank you so much!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close