?
Solved

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

Posted on 2010-01-12
11
Medium Priority
?
595 Views
Last Modified: 2013-11-24
microsoft visual fox 9.0 sp2
0
Comment
Question by:mauropolo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
11 Comments
 
LVL 42

Expert Comment

by:pcelba
ID: 26291657
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
 

Author Comment

by:mauropolo
ID: 26291880
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
 

Author Comment

by:mauropolo
ID: 26291893
...
i forget:
Windows 7 professional 64 bit
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
LVL 42

Expert Comment

by:pcelba
ID: 26291962
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
 

Author Comment

by:mauropolo
ID: 26291985
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
 
LVL 42

Expert Comment

by:pcelba
ID: 26292006
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
 

Author Comment

by:mauropolo
ID: 26292739
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
 

Accepted Solution

by:
mauropolo earned 0 total points
ID: 26292769
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
 
LVL 42

Expert Comment

by:pcelba
ID: 26292911
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
 
LVL 42

Expert Comment

by:pcelba
ID: 26292920
Sorry, it seems you found it earlier...
0
 
LVL 42

Expert Comment

by:pcelba
ID: 26292957
So, please select your post ID:26292769 as the accepted solution.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question