Re: Linking a SQL database to an Access database.
- From: MGFoster <me@xxxxxxxxxxx>
- Date: Sat, 25 Mar 2006 21:08:11 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I believe you need quote delimiters on the parameters and commas between
each parameter:
@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'
This question probably would have been better posted in
microsoft.public.sqlserver.programming
Since your question is really about SQL Server.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBRCWxN4echKqOuFEgEQLgEQCg/GGB5tqtWhbxp6ua5khKhUWgUM0AoI3K
y8KNz8IxOwkgYri8V+n8bwVm
=SIh2
-----END PGP SIGNATURE-----
Frank wrote:
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'.
- Follow-Ups:
- References:
- Linking a SQL database to an Access database.
- From: Frank
- Linking a SQL database to an Access database.
- Prev by Date: Re: Pulling queriy criteria from a text box
- Next by Date: Re: Pulling queriy criteria from a text box
- Previous by thread: Linking a SQL database to an Access database.
- Next by thread: Re: Linking a SQL database to an Access database.
- Index(es):
Relevant Pages
|
