Viewing 5 posts - 1 through 6 (of 6 total)
EXECUTE sp_addlinkedserver 'North', 'OLE DB Provider for Jet',
'Microsoft.Jet.OLEDB.4.0','C:\Practice Files\Northwind.mdb'
Msg 15028, Level 16, State 1, Procedure sp_MSaddserver_internal, Line 89
The server 'North' already exists.
SELECT * FROM North...Customers
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked...
February 5, 2009 at 2:48 am
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "North" returned message "The Microsoft Jet database engine cannot open the file 'C:\Practice Files\Northwind.mdb'. It is already opened exclusively by another user,...
February 4, 2009 at 2:48 am
Well, it didn't display any error messages, so I suppose that it worked.
February 3, 2009 at 4:41 am
1. Check if the file "C:\Practice Files\Northwind.mdb" exists on the location on your local machine
This file is in this location
2. Check the service account has permissions on the file (go...
February 3, 2009 at 2:29 am
Thanx Ramesh, but I don't know how to do this as Sql Server is on my local machine.
February 2, 2009 at 2:21 am
Viewing 5 posts - 1 through 6 (of 6 total)