F
Frank
I want to create a link between my SQL server database and an access
database. I used the following code with the querry analyzer.
_________________________________________________________
USE master
GO
EXEC sp_addlinkedserver
@server = frank
@provider = Microsoft.Jet.OLEDB.4.0.6218.0
@srvproduct = Microsoft OLE DB Provider for Jet,
@datasrc = C:\Documents and Settings\Frank Smith\Desktop\test.mdb
GO
_____________________________________________________________
However, I get the follwoing error message when running the querry:
Incorrect syntax near '@provider'.
What am I doing wrong?
Assistance is greatly apprecated.
Frank
database. I used the following code with the querry analyzer.
_________________________________________________________
USE master
GO
EXEC sp_addlinkedserver
@server = frank
@provider = Microsoft.Jet.OLEDB.4.0.6218.0
@srvproduct = Microsoft OLE DB Provider for Jet,
@datasrc = C:\Documents and Settings\Frank Smith\Desktop\test.mdb
GO
_____________________________________________________________
However, I get the follwoing error message when running the querry:
Incorrect syntax near '@provider'.
What am I doing wrong?
Assistance is greatly apprecated.
Frank