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_addlinkedser ver
@server = 'Sybase SQL Anywhere 5.0',
@srvproduct = 'Sybase',
@provider = 'MSDASQL',
@datasrc = 'Dbf=\\s3k300da rt01\'
GO
but no tables are returned and returns an exception...
johngray0
Last Activity: Aug 10 '10, 10:15 PM
Joined: Jan 17 '10
Location:
-
Connect SQL server (64-bit) to Sybase SQL Anywhere 5.0
-
Linked tables in SQL Sever-ODBC connection
Newbie to SQL Sever here.
In access it is very easy to set up linked tables using ODBC, the behavior of which is needed to replicate in sql server.
In SQL Server (2008 in this case), I found it easy to import using OBDC using the import wizard. What is not straightforward is either: 1. automating the actions if the import wizard or 2. creating linked tables similar to access. We need auto-refresh of the data rather... -
Nico,
Thank you for the reply.
The pass-through query in Access sounds good. Now, as someone who has not tried this approach before, do you know of a resource that might outline the basic steps for doing this? Like a link to a tutorial, perhaps? The syntax at least, I can look up.
Th -
How to select subset of table with more than 255 columns?
I have a table that is being imported from Sybase that contains > 255 fields.
We only need a small subset of these fields, however, so the desired stored table is something Access can handle (~ 20 columns).
The connection setup is ODBC, and of course, an openrecordset command just gives the first 256 fields. When I do a SELECT on a fields not in the first 255, of course, there is an error.
Is there...
No activity results to display
Leave a comment: