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.

Sorry, the comment form is closed at this time.

Powered by WordPress