April 25, 2007 at 9:54 am
I've linked an Access database to SQL Server 2005 express, and it works happily, so long as I run the stored procedures etc when I'm working directly on the server box. If I try to run it remotely ie. workstation on network using SSMSE, using a valid login, the database says it's linked, but eg. sp_tables_ex gives an error
"OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "MyAccessDatabase" returned message "Unspecified error".
Msg 7303, Level 16, State 1, Procedure sp_tables_ex, Line 41
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "MyAccessDatabase".
Any ideas on what's wrong?
April 30, 2007 at 9:22 am
In 2005 you have to use the surface area configuration tool to enable SQL Server to allow remote connections, all you need is covered in the link below by Microsoft. Hope this helps.
http://support.microsoft.com/kb/914277
Kind regards,
Gift Peddie
April 30, 2007 at 10:52 pm
Thanks for the reply. It already allows remote connections which are working fine to all databases. The only problem is the linked Access database...any other ideas?
May 1, 2007 at 9:08 am
The problem is related to Windows file permissions for the Access folder, try the link below for details.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=836809&SiteID=1
Kind regards,
Gift Peddie
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply