Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 597
  • Last Modified:

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

microsoft visual fox 9.0 sp2
0
mauropolo
Asked:
mauropolo
  • 6
  • 5
1 Solution
 
pcelbaCommented:
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.
0
 
mauropoloAuthor Commented:
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'.
0
 
mauropoloAuthor Commented:
...
i forget:
Windows 7 professional 64 bit
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
pcelbaCommented:
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.
0
 
mauropoloAuthor Commented:
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.
0
 
pcelbaCommented:
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.
0
 
mauropoloAuthor Commented:
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
0
 
mauropoloAuthor Commented:
Now i try to change the connection string.
I configure a new DSN connection (see attacment).
Run...

Work fine! Problem solved

Thank you
Bye
Immagine.bmp
0
 
pcelbaCommented:
This solution were published here at EE (http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/PHP_Windows/Q_25017170.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;
0
 
pcelbaCommented:
Sorry, it seems you found it earlier...
0
 
pcelbaCommented:
So, please select your post ID:26292769 as the accepted solution.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now