I have taken over an app which uses a SQL server database and links to some
dbf files. An existing proc uses the script below - this works on the live
server

SELECT * FROM OPENROWSET('MSDASQL', 'DRIVER={Microsoft foxpro vfp Driver
(*.dbf)};UID=;Deleted=No;Null=No;Collate=Machine;B ackgroundFetch=No;Exclusive=No;SourceType=DBF;Sour ceDB=c:\abc', 'SELECT * FROM T_MWKNO')

However I cant get this working on a develpment server. The error is:

OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Driver
does not support this function]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize
returned 0x80004005: ].

I cant set up a DSN using Microsoft foxpro vfp Driver. This could be a
problem! I have installed the latest updates from the MS site, but no luck

So also tried with the dbase driver - this allowed be to link to the table
using Access. But the Openrowset gave the error

OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC dBase Driver] The
Microsoft Jet database engine could not find the object 'T_MWKNO'. Make sure
the object exists and that you spell its name and the path name correctly.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IColumnsInfo::GetColumnsInfo
returned 0x80004005: ].

The file definitely exists.

So, any clues? TReally stumped on this one...

Cheers

--
Mark Robinson