Hi,

I have created a linked server in SQL 2005 that uses an ODBC with that
connection string:

@datasrc=N'eTimeDB', @provstr=N'Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=D:\DBFFiles;Extended Properties=dBASE IV;User ID=Admin;Password='


I can easily do this from the server itself:

SELECT * FROM OPENQUERY( ETimeODBC13, 'SELECT * FROM EMP')

The problem, is when I try to execute that SELECT statement from a remote
machine using QUery Analyzer, I got this error:

Cannot initialize the data source object of OLE DB provider "MSDASQL" for
linked server "ETimeODBC13".
OLE DB provider "MSDASQL" for linked server "ETimeODBC13" returned message
"[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".
OLE DB provider "MSDASQL" for linked server "ETimeODBC13" returned message
"[Microsoft][ODBC dBase Driver]Invalid connection string attribute Password".


How could we resolve this?

Thank you a lot