title: Set up a linked server to Sybase (from SQL Server Management Studio)
body: <p>I've given a task to import data from Sybase to SQL server 2012, and I figured that the easiest way for me (I am a beginner) to do this is to set up a linked server from SQL server to the Sybase and import data from there. </p>
  
  <p>The Sybase and the SQL server are not on the same computer, but I can remote-access to either one from my computer just fine. I am having a difficulty in trying to set up a link in between these two, though, and I would greatly appreciate any help.</p>
  
  <p>On the Sybase, the System DSN only has SQL Anywhere 12 CustDB right now. Can this work as the ODBC driver, or do I have to install a Sybase ODBC driver? </p>
  
  <p>Also, I have not come across from my research yet, but is there a way to import data from Sybase to SQL server just by using a SQL script? I understand if there were, it would probably be out of my league, but still...</p>
  
  <p>Thanks!</p>