Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pras2007
Posting Yak Master
216 Posts |
 Posted - 2010-12-05 : 15:14:28
|
| Hello All,I’m trying to create a link server to a Access 2007 database that is located in this directory: \\folder\Access Database\Customer.mdb.I executed the below script:EXEC sp_addlinkedserver @server = N'TESTING', @provider = N'Microsoft.ACE.OLEDB.12.0', @srvproduct = N'Access2007', @datasrc = N’\\folder\"Access Database"\Customer.mdbGO-- Set up login mapping using current user's security contextEXEC sp_addlinkedsrvlogin @rmtsrvname = N'TESTING', @useself = N'TRUE', @locallogin = NULL, @rmtuser = N'TESTING', @rmtpassword = ''GOWhen I tried to access the linked server I get the below error:Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "TESTING".OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "TESTING" returned message "folder\"Access Database"\Customer.mdb" is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.". (.Net SqlClient Data Provider)That path is correct and I’m able to access the Access 2007 database. Does anyone know what I’m doing wrong?Thanks. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-05 : 15:36:45
|
| The path needs to be mapped for the sql server service (probably).Might work if you ran a net use command to map a drive then used that for the remote path.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Need help creating Link Server for a Access 2007 d