| mhr100 2005-06-24, 7:23 am |
| 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=N
o;Null=No;Collate=Ma
chine;BackgroundFetc
h=No;Exclusive=No;So
urceType=DBF;SourceD
B=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::Initi
alize
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::GetCol
umnsInfo
returned 0x80004005: ].
The file definitely exists.
So, any clues? TReally stumped on this one...
Cheers
--
Mark Robinson
|