Sql Server 2005 and Linked Server RRS feed

  • Question

  • I am trying to create a linked server to an access database from sql server 2005 (64 bit) on a window 2003 r2 64 bit machine.  i get the error message :Cannot create an instance of OLE DB provider "Microsoft.jet.oledb.4.0" for linked server "SSIDB_LO2". The linked server is attached, but it is not using the jet ole db provider, and i also noticed that in the provider list the Microsoft.jet.oledb.4.0 is not listed.  i think that is my problem.  how do get Microsoft.jet.oledb.4.0 in that list?
    Thursday, August 31, 2006 7:14 PM