Creating a connection.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hal - 07 Jan 2005 18:19 GMT

I'm VERY new to VFP so please go easy on me... I'm trying to create a
connection/remote view to a VFP database. I have tried to install the VFP
ODBC driver, but I keep getting the following error dialog box:

Visual FoxPro ODBC Error
You must first install the current version of the Visual FoxPro ODBC Driver.
Go to
............ Select Product Updates, then Visual FoxPro ODBC Driver.

I have VFP 8.0 SP1 so it should already be there.
OS: XP pro SP 2

How would I go about creating a connection????
TIA

Reply to this Message

Rick Bean - 07 Jan 2005 19:59 GMT

Hal,
Bad assumption. The current (latest and last?) ODBC driver is version - 6.1.8629.1. It was for VFP 6.0 and came in MDAC 2.6. You can get it at this link http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx.

If you are using any VFP 7, 8 or 9 fetaure in your database or tables, you'll need to use OLE DB, the latest version of this comes with VFP 9.0 - I'm not sure it's been released yet separately, but you can get the 8.0 SP1 version at http://www.microsoft.com/downloads/details.aspx?familyid=0f43eb58-7a94-4ae1-a59e
-965869cb3bc9&displaylang=en.

Rick

> I'm VERY new to VFP so please go easy on me... I'm trying to create a
> connection/remote view to a VFP database. I have tried to install the VFP
[quoted text clipped - 10 lines]
> How would I go about creating a connection????
> TIA

Reply to this Message

Hal - 07 Jan 2005 23:56 GMT

Rick, Thanks for the reply...
As I mentioned, I have VFP 8.0 SP1 - and I did already try the download as
well. I'm a little confused here though.....
How do I make a "connection/remote view" using OLE DB??? (The database I'm
trying to connect to has been converted to VFP 8.0)
My ODBC Data Source Administrator shows the driver to be 1.00.02.00 dated
8/4/2004 - ?????

HELP

Hal
Hal,
Bad assumption. The current (latest and last?) ODBC driver is version -
6.1.8629.1. It was for VFP 6.0 and came in MDAC 2.6. You can get it at this
link http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx.

If you are using any VFP 7, 8 or 9 fetaure in your database or tables,
you'll need to use OLE DB, the latest version of this comes with VFP 9.0 -
I'm not sure it's been released yet separately, but you can get the 8.0 SP1
version at
http://www.microsoft.com/downloads/details.aspx?familyid=0f43eb58-7a94-4ae1-a59e
-965869cb3bc9&displaylang=en.

Rick

> I'm VERY new to VFP so please go easy on me... I'm trying to create a
> connection/remote view to a VFP database. I have tried to install the VFP
[quoted text clipped - 11 lines]
> How would I go about creating a connection????
> TIA

Reply to this Message