Home Forums Programming Connecting Create linked server from SQL server 2005 to Sybase SQL Anywhere 5.0 RE: Create linked server from SQL server 2005 to Sybase SQL Anywhere 5.0

  • Hmm, well it seems to be working now. I simply changed the way I called the select statement. I read here that SQL Anywhere doesnt support the catalog name, i.e.

    SELECT * FROM MyLinkedServer.CatologName.TableOwner.Table

    Here, CatologName would be the database name. I just had to log into Sybase Central, look at the table and figure out the name for the owner and use

    SELECT * FROM MyLinkedServer..TableOwner.Table