Connect to Sybase with a Linked Server

  • Ondrej

    Old Hand

    Points: 344

    Comments posted to this topic are about the item Connect to Sybase with a Linked Server

  • elfigha-915543

    Newbie

    Points: 1

    Bonjour

    can you write a similar post on how to create a linked server to Progress ?

  • jarick 15608

    Ten Centuries

    Points: 1238

    Am I the only one who really hates dealing with linked servers?

    To me hey just seem slow and problematic and modt developers don't know how to query them properly with openquery.

  • inna

    Newbie

    Points: 3

    Another place to download drivers - https://wiki.scn.sap.com/wiki/display/SQLANY/SAP+SQL+Anywhere+Database+Client+Download (I used SQL Anywhere 12).

    Then for a linked server you can use provider string as Provider=SAOLEDB.12; Eng =DBName; Uid =user; Pwd =password; Links =tcpip(Host=MachineName);

    Go to the linked server properties, Server Options, set RPC in and RPC out to true.

    In Linked Servers\Providers right click on SAOLEDB.12, check Allow Inprocess.

    After that you can browse the linked server catalogs.

    Or you can use Sybase Central (the shortcuts appears on your desktop after the driver installation) and use an ODBC source to connect. Create ODBC source with SQL Anywhere driver, action = Connect to a running database on another computer, Host = MachineName, Server name = DBName. From there you can see all DB objects and ER Diagram or run interactive SQL.

  • jarick 15608

    Ten Centuries

    Points: 1238

    I do like the option of using provider strings over ODBC DSN's when connecting to ODBC data sources a lot better.  It puts everything in one place and if you are doing SSIS development, you just need to have the drivers and not all of those DSN's.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply