/*
EXEC sp_addlinkedserver
@server = '[type Linked Server Name]',
@provider = 'Microsoft.Jet.OLEDB.4.0',
@srvproduct = 'OLE DB Provider for Jet',
@datasrc = '\\servername\myAccessDBlocation\my.mdb'
GO
*/
EXEC sp_addlinkedserver
@server = '[type Linked Server Name]',
@provider = 'Microsoft.Jet.OLEDB.4.0',
@srvproduct = 'OLE DB Provider for Jet',
@datasrc = '\\servername\myAccessDBlocation\my.mdb'
GO
*/
EXEC sp_addlinkedserver
@server = 'sibr',
@provider = 'Microsoft.Jet.OLEDB.4.0',
@srvproduct = 'OLE DB Provider for Jet',
@datasrc = '\\tpadev01\[folder name]\[folder name]\[db name].mdb'
GO
No comments:
Post a Comment