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

  • Are you still around? Or does somebody else know how to solve this? I'm trying to do the same thing, also using SQL Server 2005. I'm getting this error-

    OLE DB provider "MSDASQL" for linked server "ABS" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".

    OLE DB provider "MSDASQL" for linked server "ABS" returned message "[Sybase][ODBC Driver][SQL Anywhere]Unable to start specified database: Access is denied.".

    Msg 7303, Level 16, State 1, Line 2

    Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "ABS".

    I'm wondering what other settings you had set up.