VFP, Vista, ODBC

[JICGreg]

I am using VFP 9.0 with SP1 on a new windows vista machine. I need to attach to files on my server via odbc. I select a system dsn, add a microsoft visual foxpro driver and receive the following error:

You must first install the current version of the Visual Foxpro ODBC Driver. A webpage is then listed to download vfpoledb.exe (which was installed with sp 1).

In looking at the system requirements, I noticed that vista is not listed as a supported os for this file.

Does this mean that odbc will not work with vista and vfp? Does anyone have suggestions/ideas?

Thanks

 

[Mike Lewis]

Does this mean that odbc will not work with vista and vfp?

I doubt if you'll have a problem, but why don't you just try it and see?

Also, I'm not clear why you need ODBC for this job. You should be able to connect directly to the files on the server.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[JICGreg]

I've tried to set up the connection. After hitting add and selecting the vfp driver, and hitting finish, it pops up the prior-mentioned error message and does not allow me to configure the connection at all.

The reason why I need odbc is that I am connecting the visual foxpro table so that it can be used by crystal reports.

 

[dgrewe]

You do not need to do anything.
VFP & Crystal will read the tables directly without drivers.

David W. Grewe Dave

 

[Mike Lewis]

JICGreg,

I can only repeat what I said earlier. You should be able to connect to the tables directly, without the need for ODBC. Just execute USE <full path to table name>.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[craigber]

Mike: Crystal will read Fox2x tables directly. It will not read other types of Fox DBFs directly.

JICGreg: Instead of using ODBC, you can use OLEDB/ADO to read Fox tables from Crystal Reports.

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports&quot;

 

[Mike Lewis]

Craig,

Mike: Crystal will read Fox2x tables directly. It will not read other types of Fox DBFs directly.

Come again. Where did Crystal come into the discussion?

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[ChrisRChamberlain]

Mike

Post No 3

The reason why I need odbc is that I am connecting the visual foxpro table so that it can be used by crystal reports.

FAQ184-2483​

Chris
PDFcommander.com
motrac.co.uk

 

[Mike Lewis]

Chris,

Thanks for that. I was confused because Craig addressed his reply to me rather than the original questioner.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[Olaf Doschke]

Hello,

Vista comes with some default ODBC drivers from 11/02/2006, one of them being VFP ODBC 1.00.02.00 - forget that one.

I tried installing VFP OLEDB. It will not show up in Data Sources (ODBC). Not because it's OLEDB, you see OLEDB providers there too, normally. I wonder why, it's 32 Bit Vista Ultimate, and I tried running the setup as admin, even turned off UAC and set the vfpoledb.exe to XP SP2 compatibility mode in it's properties. The registry entries are generated, especially in HKEY_CLASSES_ROOT.

No solution at hand.

Bye, Olaf.

 

[craigber]

Olaf:

I just checked on XP Pro and OLEDB Providers do not show up in ODBC Data Sources. The access methodology is entirely different for OLEDB and ODBC. You don't create a DSN to use OLEDB, so I wouldn't expect the Providers to be there.

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports&quot;

 

[Olaf Doschke]

Hi Craig,

thanks for investigating into this. I though I saw them there and I still think you can create a DSN based on an OLE DB data provider too. Nevertheless I also couldn't connect to a vfp database via a connectionstring. I'll retry later at home and report back if I got it working.

Bye, Olaf.

 

[Olaf Doschke]

Hi craig,

Rading the readme.htm of the vfp oledb provider helps. It requires MDAC 2.6, which is not preinstalled in Vista. But the MDAC install does not work even when started as Admin. It just uncompresses the install files and after that nothing happens, even if you set the mdac_typ.exe to win xp sp2 or win2000 compatibility mode.

By the way trying:

sqlstringconnect("Provider=vfpoledb.1;Data Source=...dbc")

does only pop up a dialog to choose or create a DSN. Which also makes me think the vfpoledb.dll should be available as a driver in Data Sources.

Bye, Olaf.

 

[craigber]

You're trying to mix ODBC and OLEDB/ADO. There are two entirely different access methodologies with different APIs.

Look at the Crystal articles on my website (

http://www.craigbertson.com)

to see how to use ADO with Crystal Reports.

Are you sure Vista doesn't come preinstalled with MDAC? Have you tried installing just the VFP OLE DB Provider?



Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports&quot;

 

[Olaf Doschke]

I now know what did not work: I made the connection to a corrupt dbc, I could even not open it with OPEN DATABASE, that was the problem...

So there is no problem using both ODBC (I installed that without problems) and OLEDB Provider in Vista.

Bye, Olaf.