How do create a linked server to SQL Anywhere 16?

I need to create a linked server in SQL Server 2012. What parameters would I use connecting to the demo database suing SAOLEDB.16?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

The code shown in Download Via Linked Server is for SQL Anywhere 11, but it may give you some ideas.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Breck,

Thanks. I did try this. It does not seem to work. On a Windows 7 (x64bit) machine there is no Microsoft OLEDB for ODBC (MSDASQL). There are samples from Sybase There are two providers on SQL Server 2012 that can be used for creating linked servers: MSDASQL SAOLEDB.16

The first choice will not work. There isn't enough documentation for using SAOLEDB.16. It is not super urgent for me, plain academic interest.

> The first choice will not work.

Be wary of bold statements 🙂

Microsoft lists MSDASQL as the "Microsoft OLE DB Provider for ODBC" in the Help topic for SQL Server 2014 sp_addlinkedserver.

According to Microsoft's Data Access Technologies Road Map "MSDASQL ships with the Windows operating system".

Check this location on Windows 7...

C:\\Program Files\\Common Files\\System\\Ole DB\\msdasql.dll

FWIW, on 64-bit systems, there should also be a msdasql.dll in the 32-bit program files directory, i.e.

C:\\Program Files (x86)\\Common Files\\System\\Ole DB\\msdasql.dll

Nevertheless, since SQL Server 2012 only comes as 64-bit software AFAIK, you will have to use the 64-bit OLEDB drivers for linked servers, no matter whether you will use the MSDASQL or SAOLEDB drivers...

SAOLEDB is perfect for this. There is no MSDASQL(x64) on Windows 7 OS.