RE: Error from FoxPro connection in Visual Basic 6

Hi Julian:

Try installing the VFP ODBC driver on the server. Get if from this link:

http://www.msdn.microsoft.com/vfoxpro/downloads/updates/default.aspx

Look at the bottom of the page.

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 HAS ARRIVED!! --*
Read about all the new features of VFP9 here:
http://msdn.microsoft.com/vfoxpro/

*--Purchase VFP 9.0 here:
http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
69-4500-8bf2-3f06689f4ab3&type=ovr

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/gp/lifeselectindex
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003


>I am getting an error in a program written in VB6 when connecting to a VFP
>free table directory. It works on the deveopment machine (XP Pro SP2) and
>not on the server where the app is to run.

>The (pertinent) code is as follows

Dim CONN As New ADODB.Connection

cnFox = "Driver={Microsoft Visual FoxPro Driver}; " _
& "SourceType=DBF;" _
& "SourceDB=c:\foxprodata;" _
& "Exclusive=No;" _
& "Collate=Machine;" _
& "NULL=NO;" _
& "DELETED=NO;" _
& "BACKGROUNDFETCH=NO"

CONN.ConnectionString = cnFox

>This is where it fails with Error #-2147467259


>The program references "Microsoft ActiveX Data Objects 2.8"

>The Server is running "MDAC 2.8 RTM"
>The Development machine is running "MDAC 2.8 SP1 on Windows XP SP2"

>Neither one of these MDACs supposedly have a driver for FoxPro

>The OLE DB Provider for Visual FoxPro 9.0 doesn't seem to be installed on
my
>development machine. And the ODBC drivers are different.

>The "Microsoft FoxPro Driver" in the ODBC panel on the Server is not
present
>The "Microsoft FoxPro Driver" in the ODBC panel on the Development machine
>reports version 4.00.6304.00

>The "Microsoft Visual FoxPro Driver" in the ODBC panel on the Server
reports
>version 1.00.02.00
>The "Microsoft Visual FoxPro Driver" in the ODBC panel on the Development
>machine reports version 6.00.8167.00

>The "Microsoft FoxPro VFP Driver" in the ODBC panel on the Server reports
>version 1.00.02.00
>The "Microsoft FoxPro VFP Driver" in the ODBC panel on the Development
>machine reports version 6.00.8167.00



>What (at the minimum) is needed to be installed on the server to allow
this
>to go through?

>Julian

.

Relevant Pages

  • RE: ODBC-Server Middleware
    ... We have the need to use ODBC. ... see only those datasources which were configured on the server. ... animal with the combination of Sequelink and Informix though the conception ... The ODBC driver usually is used by the application. ...
    (comp.databases.informix)
  • Re: ODBC drivers for MSSQL
    ... There are at least two ways, and you may or may not need an ODBC driver ... both Sybase and MS SQL Server speak dialects of. ... letting it know that unixODBC is its driver manager at build time, ...
    (comp.os.vms)
  • Re: Database Model - Class, objects and interaction [LONG]
    ... If there is an ODBC client C, and a database server S with ODBC ... Well, I just ran a perl script this morning, it has these lines in it, ... Windows datasource, it's a SQL Server ODBC driver, written by ...
    (comp.object)
  • Re: call failed 3146
    ... I have a vb program that connects to odbc to an sqlexpress server. ... the latest 'n greatest video/sound driver for your card is generally a wise ...
    (comp.lang.basic.visual.database)
  • core install of Solaris 9 (sparc) package list can be trimmed ?
    ... This is a server that will have very specific reasons ... system SUNWadmr System & Network Administration Root ... system SUNWeu8os American English/UTF-8 L10N For OS Environment User Files ... system R SUNWfcip Sun FCIP IP/ARP over FibreChannel Device Driver ...
    (comp.unix.solaris)