March 3, 2008 at 5:02 pm
When I try to run this from SQL2K5, 64-bit
select * FROMOPENROWSET
(
'Microsoft.Jet.OLEDB.4.0',
'\\10.100.0.29\D$\company balance.mdb';
'admin';'',[PLUS COMPANY MASTER]
)
I get this
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.
But I can do it fine from a 32-bit box. Doing a quick google it looks like you can't hit access from a 64-bit server. Can anyone confirm that or tell me how to do it?
Thanks,
Jason
The Redneck DBA
March 3, 2008 at 8:35 pm
"Noted that the Microsoft OLE DB Provider for Jet, used for Access and Excel databases, is not available in a 64-bit version."
http://technet.microsoft.com/en-us/library/ms141766.aspx
"...native 64-bit applications (such as the 64-bit versions of SQL Server) cannot access data stored in MDB files through ODBC, OLE DB, or any other means, except through intermediate 32-bit software that acts as a proxy for the 64 bit client."
http://en.wikipedia.org/wiki/Microsoft_Jet_Database_Engine
Try this: How to read Access database data from 64-bit SQL Server 2005
http://gorm-braarvig.blogspot.com/2005/11/access-database-from-sql-200564.html
March 4, 2008 at 5:28 am
You can use SQL Server Integration Services also to read access data.
Susantha
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply