Re: Connecting to a FoxPro Database - VB6 on WindowsXP

From: stjulian (anonymous_at_discussions.microsoft.com)
Date: 03/23/05 

Date: Wed, 23 Mar 2005 18:23:17 -0500

Thank you for the the reply.

Yes, the quote before the X was put there by accident as I retyped the code
block eliminating references to variables for clarity.

cnCompany = "Driver={Microsoft Visual FoxPro Driver};" & _
     "SourceType=DBF;" & _
     "SourceDB=X:\SharedDatabase\;" & _
     "Exclusive=No;"

This update (Microsoft OLE DB Provider for Visual FoxPro 9.0) is an OLE DB
driver. I am not familiar. I get the same error after I install this. My
program is ADO. How could I implement this via code with a DSN-less
connection?

I appreciate your help on this.

Julian

"Cindy Winegarden" <cindy_winegarden@msn.com> wrote in message
news:OsOEdv8LFHA.2468@tk2msftngp13.phx.gbl...
> Hi Julian,
>
> The latest FoxPro and Visual FoxPro ODBC drivers and OLE DB data provider
> are not included in the latest MDAC packages. However, you can download
> both of them from http://msdn.microsoft.com/vfoxpro/downloads/updates .
> You will need to install whichever one you use on each machine where your
> app is installed to run.
>
> Did you copy the code you're using exactly? You appear to be missing some
> quotes in the third line of this part:
>
> cnCompany = "Driver={Microsoft Visual FoxPro Driver};" & _
> "SourceType=DBF;" & _
> "SourceDB="X:\SharedDatabase\;" & _
> "Exclusive=No;"
>
> --
> Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP
> cindy_winegarden@msn.com www.cindywinegarden.com
> Blog: http://spaces.msn.com/members/cindywinegarden
>
>
> "stjulian" <anonymous@discussions.microsoft.com> wrote in message
> news:%23gGsl%23yLFHA.3788@tk2msftngp13.phx.gbl...
>>I have an old application that I wish to modify for use on windows xp. As
>>I
>> am led to believe by the voices in my head that MDAC 2.8 in Windows XP
>> does
>> not have a provider for FoxPro. It works on windows 2000, albeit due to
>> the
>> constant applications of the MDAC du jour. However, in the XP ODBC panel,
>> I
>> see a few entries for
>>
>> VFPODBC.DLL Driver 1.00.02.00 Dated 9/3/2002
>>
>> Perhaps this came with the accounting application also installed. I need
>> to
>> connect to the database in our X-drive but the code below yieds a
>>
>> runtime error -2147467259 (80004005)
>> [ODBC Driver Manager] Driver does not support this function.
>>
>> on the "Open" command. The "Microsoft Visual FoxPro Driver" IS in the
>> ODBC
>> panel on each machine so I have no explaination.
>>
>> Any ideas (and code samples) on how to connect to a FoxPro Database with
>> the
>> MDAC 2.8 in Windows XP. Is there a library that I can add?
>>
>> BTW, this is for read only of FoxPro data in a free table directory with
>> CDX
>> indexes as well. I have no reason to write to this directory EVER. I have
>> no
>> idea what version of FoxPro the accounting app was based on.
>>
>>
>> Dim CONN As New ADODB.Connection
>> Dim RS As New ADODB.Recordset
>> Dim SQL As String
>>
>> cnCompany = "Driver={Microsoft Visual FoxPro Driver};" & _
>> "SourceType=DBF;" & _
>> "SourceDB="X:\SharedDatabase\;" & _
>> "Exclusive=No;"
>>
>> CONN.ConnectionString = ConnStr
>>
>> CONN.Open
>>
>> SQL = "SELECT company.code, company.name, dataloc FROM company
>> ORDER
>> BY dataloc;"
>>
>> Set RS = CONN.Execute(SQL)
>>
>>
>> Thank You
>> Julian
>>
>>
>>
>>
>
>

Relevant Pages

  • Connecting to a FoxPro Database - VB6 on WindowsXP
    ... I have an old application that I wish to modify for use on windows xp. ... constant applications of the MDAC du jour. ... Any ideas (and code samples) on how to connect to a FoxPro Database with the ...
    (microsoft.public.vb.database.ado)
  • MDAC 2.7 SP1 Refresh and FoxPro
    ... I have a question with regards to MDAC and FoxPro. ... we install MDAC 2.7 SP1 Refresh. ... I am aware that MDAC 2.7 is already installed with Windows XP, ...
    (microsoft.public.data.odbc)
  • MDAC
    ... I am currently running with MDAC version 2.53.6306.0 in Windows 2000. ... Can you suggest a reference that would outline any problems I may have ... working with Foxpro V 6.0 if I upgraded MDAC to 2.6 or higher? ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Word mail merge with foxpro
    ... I did come across an article about using FoxPro with earlier Word ... > The dbf is not attached to a dbc as I have always found that more ... The MDAC 2.5 installaion helpded greatly I am just a bit worried ... >> is to switch on ODBC logging in the ODBC administrator. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Problem Linking Foxpro 9 .DBC in Access 2003
    ... VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx ... I am sure the DBC has Foxpro 7+ features as the vendor that produces this ...
    (microsoft.public.access.externaldata)