question

DarrellBurns-1376 avatar image
0 Votes"
DarrellBurns-1376 asked Cathyji-msft answered

Linked server to a Sybase / SQLAnywhere database

I've been beating my head against a wall trying to create a linked server to a SQLAnywhere 11 database from SQL Server (12.0). Can't seem to get the parameters right.
Since I can't seem to get my hands on a copy of SAOLEDB.12 I'm stuck using MSDASQL as the provider. But I can't get past this error message...

OLE DB provider "MSDASQL" for linked server "myserver" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".

EXEC master.dbo.sp_addlinkedserver @server=N'MyServer'
,@srvproduct=N'SQL Anywhere'
,@provider=N'MSDASQL'
,@datasrc=N'SQLAnywhere64'
,@provstr=N'host=ServerName;dbn=DatabaseName'

ODBC System Data sources...

129987-datasources.png


sql-server-generalsql-server-transact-sql
datasources.png (15.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered Cathyji-msft edited

Hi @DarrellBurns-1376,

SQL Anywhere installation brings in ODBC drivers, both x32 bit and x64bit. Please using SQL Anywhere OLE DB Provider to create linked server. Under Server Objects node in SQL Server you can find Linked Servers with the providers that allows you to create linked servers as below screenshot.
130015-screenshot-2021-09-08-105520.jpg

If the SQL Anywhere OLE DB Provider did not exist in your environment , you can download drivers from below link.

SAP SQL Anywhere Database Client Download

Please also check if below blog could help you.

Creating a linked server to SAP/Sybase SQL Anywhere 16 server in SQL Server 2012 Express


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DarrellBurns-1376 avatar image
0 Votes"
DarrellBurns-1376 answered

Hello Cathy. Yes, I already installed the Sybase Central management console for SQL Anywhere 12. I have installed the SQL Anywhere 12 driver, and created ODBC System DSNs for both 32- and 64-bit. What I can't find anywhere are the SAOLEDB providers. I've scoured the SAP site and the internet and haven't found a source. Do you know where I can download SAOLEDB 12?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered

Hi @DarrellBurns-1376,

Please check below link.

https://wiki.scn.sap.com/wiki/display/SQLANY/SAP+SQL+Anywhere+Database+Client+Download


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DarrellBurns-1376 avatar image
0 Votes"
DarrellBurns-1376 answered DarrellBurns-1376 edited

Yes, I downloaded and installed the SQL Anywhere client. It does not include the SAOLEDB provider.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered

Hi @DarrellBurns-1376,

Did you check that both x32 bit and x64bit SAOLED.12 are installed in your environment? Could you share us a screenshot about Providers from SSMS >Server Objects>Linked server >Providers in your environment?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.