the vfp odbc ole db provider give me an error when i run in windows seven

First of all you have to tell what error is it reporting. Then you could disclose more about the operating system version (32/64 bit, edition). Finaly you should tell how are you trying to use/call VFP OLE DB provider and attach some code to your question.

BTW, the product name does not contain the "ODBC" part. If yes then you should clarify what ODBC are you using.

Thank's for answer. First of all, the software that use this ODBC connection:

CONNECT TO [Provider=VFPOLEDB.1;Data Source=\\ACESERVER2\FIDELITY\FIDELITY\DATA\FIDELITY.DBC;Mode=Share Deny None;Extended Properties="";User ID="";Mask Password=False;Cache Authentication=False;Encrypt Password=False;Collating Sequence=GENERAL;DSN=""];

is Qlik and it run well without change and error in windows xp.

Executing the same script in windows 7 give me this error 'OLE DB connection failed'.

...
i forget:
Windows 7 professional 64 bit

VFP OLE DB provider is 32 bit application and it cannot be accessed from 64 bity applications. I don't know Qlik at all, so I cannot say if this is the reason.

I also suppose the \\ACESERVER2 is your computer having W7 as operating system installed, so you are accessing local data.

If the \\ACESERVER2 is a remote machine then it must allow access for user under which the VFP OLE DB is running on your local machine which is trying to connect. VFP OLE DB must be installed on local computer in this case.

ACESERVER2 is a Windows 2003 server where resides the VFP database FIDELITY. The client PC where i run the script work with Windows 7 pro 64 bit.

OK. You should also answer if the VFP OLE DB provider is installed on the client PC and if the client software (not OS) is 32 bit or 64 bit.

64 bit software cannot use 32 bit OLE DB providers.

Both of software, VFP OLE DB and Qlik is 32bit. In the same Qlik script there is another ODBC connection that work fine. I've t

This solution were published here at EE (https://www.experts-exchange.com/questions/25017170/How-to-Connect-Foxpro-with-Remote-System-using-system-DSN-in-php.html) and it should work for you :

First Please create System dsn with remote system db path

after that.,

use this connectionstring

Provider=VFPOLEDB.1;DSN=*********(your DSN);Mode=ReadWrite;Password="";Collating Sequence=MACHINE;

Sorry, it seems you found it earlier...

So, please select your post ID:26292769 as the accepted solution.