Thread: Linked Servers
View Single Post
  #1 (permalink)  
Old March 31st, 2005, 05:01 AM
anothervbaddict anothervbaddict is offline
Authorized User
 
Join Date: Jul 2003
Location: , , United Kingdom.
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default Linked Servers

:( Does anyone have an examples of how to link a password protected MSAccess database into SQL Server 2000 please?

I've tried using the following stored procedures:
sp_addlinkedserver
sp_addlinkedsrvlogin

The actual link is created fine, but selecting the Tables produces:
 
Quote:
quote:Error 7399: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication failed.


The actual parameters used for the stored procedures are:
sp_addlinkedserver:
@server='TestDB'
@provider='Microsoft.Jet.OLEDB.4.0'

(I've then tried @datasrc or @provstr separately)
@datasrc='c:\test.mdb'
@provstr='Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\test.mdb;Jet OLEDB:Database Password=xyz'

sp_addlinkedsrvlogin:
@rmtsrvname='TestDB'
@useself='False'
@locallogin=Null
@rmtuser='Admin'
@rmtpassword='xyz'

If anyone can shed any light on this matter or show me what I'm doing wrong, would be very grateful.

Thanks in advance.
Carl

Reply With Quote