Openrowset with Foxpro

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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;BackgroundFetch=No;Exclusive=No;SourceType=DBF;SourceDB=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
.

Relevant Pages

  • Re: Windows 2003 slow serving dbf files
    ... DBF files are often rather large, ... you're moving them down the network pipe at a speed that's 1/1000th ... that's a lot of data moving back and forth. ... > I just setup a new Windows 2003 server acting as a PDC for a small (7 ...
    (microsoft.public.win2000.networking)
  • Re: How to connect into remote server
    ... There's always the option of going with some sort of open source database like MySQL. ... If you develop a web application and run it on a web server (Internet Information Server) on your local area network, then you'd use your web browser to connect. ... ASP.NET + SQL server database ...
    (microsoft.public.dotnet.framework.aspnet)
  • Network Load Balancing & Application_Start() not firing & Session clues
    ... SQL Server database is storing session information ... Edit web.config on each webserver to force them to reload the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Framework, which one to use ?
    ... blown multitier win32 GUI application accessing a SQL server database. ... We have been using Flex for our client and it works well as the front ... OpenLaszlo as a framework, although I haven't tried it personally. ...
    (comp.lang.java.gui)
  • Re: How to error-proof Doug Steels "FixConnections"?
    ... rather than letting them type in the server and database name. ... you could also store the information in a table in the front-end. ... SQL Server database from the backup, how to get rid of the annoying ...
    (microsoft.public.access.externaldata)