Connect SQL server (64-bit) to Sybase SQL Anywhere 5.0

[johngray0]

Hi,

The goal would be to import tables from Sybase into SQL server. This can be done manually, but how to do automatically?

I tried something like this:

EXEC sp_addlinkedserver
@server = 'Sybase SQL Anywhere 5.0',
@srvproduct = 'Sybase',
@provider = 'MSDASQL',
@datasrc = 'Dbf=\\s3k300dart01\'
GO

but no tables are returned and returns an exception (Cannot initialize data source object for linked server object....)

Is there another way to do this? Like a script to import tables?

Thank you,
John

[ck9663]

Here, read this...

Good Luck!!!

~~ CK