ramlicious Blogs by Tina & Prabhu

August 11, 2010

Linked Server and Data connection string for Sybase

Filed under: SQL Server — Prabhuram @ 8:59 am

Here is the SQL Server Linked Server Properties for adding Sybase Data source

Provider: Select Sybase ASE OLE DB Provider from the list
Product Name: ASEOLEDB
Data source: Leave this blank
Provider string: Server Name=[server name],[port number];User Id=[user id];Password=[password]
Location: Leave this blank
Catalog: [database name]

Similarly here is a sample for adding Sybase Data Connection in Visual Studio using Server Explorer (using ODBC):

Driver={SYBASE ASE ODBC Driver};uid=[user id];pwd=[password];srvr=[server name];na=[server name],[port number];db=[database name]

Click Build button to update the Login information after typing in the connection string.

No Comments »

No comments yet.

RSS feed for comments on this post. TrackBack URL

Leave a comment

You must be logged in to post a comment.

Powered by WordPress