December 8, 2009 at 8:38 am
Hi guys,
I have been trying to get to grips with linked servers today but have found it to be a very frustrating experience and none of what I've read online seems to work. I have had to simplify my goal so many times now that it has boiled-down to simply linking SQL Server 2005 to a locally-stored Access database and I still can't make even this work.
The Access database is located under E:\testdb.mdb. I have run the following command which executes fine but when I test it, it gives the error stated:
sp_addlinkedserver 'testdb', 'Access', 'Microsoft.Jet.OLEDB.4.0', 'E:\testdb.mdb'
Error given when tested:
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "testdb". OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "testdb" returned message "Unspecified error". (Microsoft SQL Server, Error: 7303"
I'm sure this is a simple error on my part but I can't find anything useful regardless of what I've read so thought I should post here.
Any assistance is very much appreciated,
Dan
December 8, 2009 at 9:09 am
32 or 64-bit SQL? If 64 I don't think you can get this to work..
CEWII
December 8, 2009 at 9:21 am
I recently posted a blog on Linked Server with Access DB.
You can visit the site in my signature, try the steps (in GUI) mentioned in my Blog on December 6th.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 8, 2009 at 2:47 pm
Very nice description on the site above. My bet is that it will take care of your problem.
For added security:
If your Access DB happens to joined a custom .MDW (user-security), you might want to add a user / password for the Linked Server.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply