Friday, August 07, 2009

Microsoft Jet or MSDASQL for Linked Servers?

In SQL Server 2008 you can create linked servers with a variety of data sources as seen in this figure. Linked Servers are created using OLE DB technology and there are two possible ways that
you can connect to MS Access, using Microsoft.Jet.OLEDB.4.0 or MSDASQL.

The connection strings for these are:

; Everything after this line is an OLE DB initstring
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Microsoft Office\OFFICE11\SAMPLES\Northwind.mdb;Persist Security Info=False

; Everything after this line is an OLE DB initstring
Provider=MSDASQL.1;Persist Security Info=False;Data Source=FromAccess

Now which is better for a linked server? You will find the answer to this in the following article brought to you by SSWUG.ORG. This is site where you subscribe, but you can register as a guest to view this article.

Microsoft Access 2003 Linked Server on SQL Server 2008 using the JET and MSDASQL Providers

No comments: Protection Status