Hello,
I'm trying to create a linked server to an unecrypted, no security Access database. I have tried many different variations. I keep getting an "Unspecified error" SQL ERROR: 7303 when trying to connect. Has anyone ever come across this?
EXEC sp_addlinkedserver
@server = 'MP2',
@provider = 'Microsoft.Jet.OLEDB.4.0',
@srvproduct = '',
@datasrc = 'F:\MP2\MP2.MDB'
GO
EXEC sp_addlinkedsrvlogin
@rmtsrvname = 'MP2',
@useself='False',
@rmtuser='admin',
@rmtpassword='password'
I'm trying to create a linked server to an unecrypted, no security Access database. I have tried many different variations. I keep getting an "Unspecified error" SQL ERROR: 7303 when trying to connect. Has anyone ever come across this?
EXEC sp_addlinkedserver
@server = 'MP2',
@provider = 'Microsoft.Jet.OLEDB.4.0',
@srvproduct = '',
@datasrc = 'F:\MP2\MP2.MDB'
GO
EXEC sp_addlinkedsrvlogin
@rmtsrvname = 'MP2',
@useself='False',
@rmtuser='admin',
@rmtpassword='password'