×
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 => SQL Server

SQLBase => SQL Server

SQLBase => SQL Server

(OP)
Hi all,

Have any of you had any experience of importing data from and SQLBase DB into a SQL Server?

At present I cannot see a way to do this as I have installed SQLBase OLE DB 1.0.0 (that I downloaded from www.centurasoft.com) onto the SQL Server but it fails to register the sqlbaseoledb.dll file which I presume is because it cannot find a local SQLBase DB.

The present solution is having SQLBase and Access on the same machine and then a macro linked table in Access to SQLBase.  The SQL Server then uploads data from the Access DB.

Any idea's..?

Cheers,
Clive

RE: SQLBase => SQL Server

The SQeDB Provider 1.0.0 only works, if Centura SQLBase DB is present on the system...
Bye.

RE: SQLBase => SQL Server

(OP)
Is there no other ODBC driver which will allow me to go direct from SQL Server to SQLBase without using MS Access in between?

Thanks,
Clive

RE: SQLBase => SQL Server



Importing can be done easily via an ODBC connection. Date issues require using a DTS to resolve.

RE: SQLBase => SQL Server

We are doing it here we pull the data from SQLBase via RDO data extract.  Then we move the data off to another server covert to varchar and bcp into the sql datbase.

Hope this helps.

RE: SQLBase => SQL Server

I have exported a SQLBase to SQLServer by using DTS which comes with SQLSever. You need to create an ODBC connection to both databases to do this.

RE: SQLBase => SQL Server

Problem reading Binary data from a long varchar column in SQLBase 7.5.1 using rdo odbc connectivity.

Any help will be appreciated.

Thanx in advance
Jitendra

RE: SQLBase => SQL Server

i have a very old application called Frequent Filer which works with a gupta software to connect to a very old oracle database on a very old novell netware server.i want to connect the database via odbc or in another way. does anybody got an idea??THANKS

RE: SQLBase => SQL Server

We are exporting a large dataset with Varchars from a SQLBase server to a SQL Server.  ODBC and DTS are too slow.  We need to export to a flat file and then DTS into the SQL Server.  Any thoughts on the best way to do this?

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! Already a Member? Login

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