How do create a linked server to SQL Anywhere 16?

[Former Member]

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

[Breck_Carter]

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

[Former Member]

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.

[Breck_Carter]

> 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

[VolkerBarth]

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...

[Former Member]

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

[Breck_Carter]

> There is no MSDASQL(x64) on Windows 7 OS

That is not true... please stop saying it.

It is located here...

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