<< Smartphones in the enterprise | Matching SQL server 2005 version to service pack >>

SQL server 64-bit and linked servers

by Joe Hunter 1. February 2011 22:12

Frustratingly the 64-bit version of SQL server does not support Jet OLE DB so bang goes any applications which need to export data to Access…Not sure if there is an alternative.

Abstract below is from this MSDN article

Some .NET Framework Data Providers and native OLE DB providers might not be available in 64-bit versions. For example, the Microsoft OLE DB Provider for Jet, which connects to Access databases and Excel spreadsheets, is not available in a 64-bit version.

Tags: linked server

SQL Server

Exporting data from SQL Server to Access using a Linked ServerSo I found out the hard way that to export data from SQL Server to Microsoft Access requires that th...How to transfer the logins and the passwords between instances of SQL Server 2005 and SQL Server 2008Reference is here Now...how to put this into a stored procedure? Getting the SQL server instance name using T-SQLHandy @@ function for getting the SQL server instance name using T-SQL: SELECT @@servername

SQL server 64-bit and linked servers

Advertisement

Tag cloud

Page List