Using ODBC from a Non FPDOS App for accessing FPD DBFs

[SSDESIGN]

A non FPD application needs to read and write to several FPD DBFs. If what I've been told is correct, using ODBS for VFP v7 will do the job (VFP v7 has been loaded onto the WIN2K development computer). I've located the "ODBC Data Source Administrator" in the Control Panel. What needs to done now in the application for accessing the DBFs? I've Google searched to no avail. Thanks for any assistance.

 

[JRB-Bldr]

While I have not used the VFP ODBC connection from a non-VFP application, it is supposed to work.

I would suggest that you look at thread184-760746

The link referenced by Jim Osieczonek (jimoo) provides some good general information on how to set up the connection string

For additional connection string recommendations, you might also want to look at (Free Table)

http://www.sqlkingdom.com/connectionstring/Visual-FoxPro.shtm

And Craig Boyd's (craigsboyd) post lets you know how to create a test method for the ODBC connection in Windows - external to any application.

Good Luck,


JRB-Bldr
VisionQuest Consulting
Business Analyst & CIO Consulting Services
CIOServices@yahoo.com

 

[alvechurchdata]

Are you sure you should be using the VFP 7 ODBC connection? Fox DOS had a different file structure and you might be better off with an older version of the ODBC driver. Yo might be able to get away with using a dBase driver.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[SSDESIGN]

Thanks for the Great response...
I've been unable to locate Craig Boyd's (craigsboyd) post on testing the ODBC connection. How would I find it...
Thanks again...

 

[TheRambler]

It is in the same thread, see 1:40 post.

Create a plain old text file on your desktop and rename it so it is something like "TEST.UDL" (the important part is changing the extension from txt to udl). Then double-click on that blank file and you should get a "Data Link Properties" dialog box that comes up. Finish filling out the information in this dialog, test your connection, and then once you have finished, you can open the udl file in a text editor and it will contain the connection string so you can cut and paste it into your code or whatever. I can never remember all the parts and proper syntax for connection strings so I use this shortcut to save me time and mistakes.