Wrox Home  
Search P2P Archive for: Go

  Return to Index  

sql_language thread: problem with linked server


Message #1 by Junisan Fred <junisan@k...> on Thu, 14 Jun 2001 10:56:38 +0700
I am evaluating the sql server 2000 and have problem when using the linked
server to connect the Access database.
The tstaccess.mdb using database password without spesific userID and
password.   I mean that I just set the database password, and leave the
userID = Admin password = null.
File tstaccess.mdb located in folder sharedir.   The folder "sharedir" in
"testserver" has been set for sharing, with paramater for Everyone, full
control.

Following the sql guide, I set the linked server option in Enterprise
Manager as follow:
On general tab
Linked Server = TestLinked
Provider name = Microsoft Jet 4.0 OLEDB Provider
product name = OLE DB Provider for Jet
datasource = \\testserver\sharedir\tstaccess.mdb
provider string 

On security tab
selected Be made without using a security context

On server options tab
selected: Data access, RPC, use remote collation

When click OK, the linked server added to the list.  But when accessing
tables I got this message:
"Error 7399: OLEDB provider 'Microsoft.Jet.OLEDB.4.0' reported an error."

I knew its probably becouse the database password, but I dont know how to
include the parameter to the linked server options, how to type it
correctly, and where I should put it ?

Could anyone that have the similar case and the solution for it to help me
with this problem ??? Please.
Thanks in advance.

Regards,
Sun



  Return to Index