Error

I used the following commands but it gave me following error:
EXEC sp_addlinkedserver dbf ,'Jet 4.0'
, 'Microsoft.Jet.OLEDB.4.0'
, 'D:\'
, NULL
, 'dBASE III'
GO
EXEC sp_addlinkedsrvlogin 'dbf', 'false', NULL, 'sa', 'mypassword'
SELECT TOP 10 * FROM dbf...doctor
************************************************
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication
failed.
[OLE/DB provider returned message: Cannot start your application. The
workgroup information file is missing or opened exclusively by another
user.]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IDBInitialize::Initialize returned 0x80040e4d: Authentication failed.].
************************************************
There is one doctor.dbf file in d: drive.
Waiting for your reply
Noor
If you're going against the Jet provider, the login is 'Admin' with a
blank password ('').
--Mary
On Tue, 30 Mar 2004 09:38:14 +0500, "Noorali Issani"
<naissani@.softhome.net> wrote:

>I used the following commands but it gave me following error:
>EXEC sp_addlinkedserver dbf ,'Jet 4.0'
> , 'Microsoft.Jet.OLEDB.4.0'
> , 'D:\'
> , NULL
> , 'dBASE III'
>GO
>EXEC sp_addlinkedsrvlogin 'dbf', 'false', NULL, 'sa', 'mypassword'
>
>SELECT TOP 10 * FROM dbf...doctor
>*********************************************** *
>Server: Msg 7399, Level 16, State 1, Line 1
>OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication
>failed.
>[OLE/DB provider returned message: Cannot start your application. The
>workgroup information file is missing or opened exclusively by another
>user.]
>OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
>IDBInitialize::Initialize returned 0x80040e4d: Authentication failed.].
>*********************************************** *
>There is one doctor.dbf file in d: drive.
>Waiting for your reply
>Noor
>