|
Home > Archive > microsoft.public.sqlserver.server > June 2002 > linked server problem
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
linked server problem
|
|
|
| hi im trying to add a linked server to my access 2000 database.
but get the foll error
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: Could not find installable ISAM.]
sp_addlinkedserver
@server = "Northwinds",
@srvproduct = "Access 2000",
@Provider = "Microsoft.Jet.OLEDB.4.0",
@datasrc = "e:\db1.mdb"
exec sp_addlinkedsrvlogin
@rmtsrvname = "Northwinds",
@useself = "false",
@locallogin = "sa",
@rmtuser = "uid",
@rmtpassword = "pass2"
where do i specify the system database?
its c:\sysdb.mdw
/thanx
| |
| Jun Chen[MS] 2002-06-26, 4:25 am |
| Hi,
For information about how to specify system database and how to link the
server, please refer to the BOL, under the topic "OLE DB Provider for Jet"
Thanks,
Jun Chen
This posting is provided "AS IS" with no warranties, and confers no rights.
|
|
|
|
|