Re: Connecting to a FoxPro Database - VB6 on WindowsXP
From: Cindy Winegarden (cindy_winegarden_at_msn.com)
Date: 03/24/05
- Next message: Kate: "error handle on '0 row selected'"
- Previous message: stjulian: "Re: Connecting to a FoxPro Database - VB6 on WindowsXP"
- In reply to: stjulian: "Re: Connecting to a FoxPro Database - VB6 on WindowsXP"
- Next in thread: stjulian: "Re: Connecting to a FoxPro Database - VB6 on WindowsXP"
- Reply: stjulian: "Re: Connecting to a FoxPro Database - VB6 on WindowsXP"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 23 Mar 2005 22:17:03 -0500
Julian,
The ODBC driver is also downloadable from the page I referenced. It's at the
bottom of the page. Since your connection string references the ODBC drivers
then you won't see any change until you've updated them.
The direct link is:
http://download.microsoft.com/download/vfoxodbcdriver/Install/6.1/W9XNT4/EN-US/VFPODBC.msi
-- 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:e5Bik%23$LFHA.3184@TK2MSFTNGP09.phx.gbl... > 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 >>> >>> >>> >>> >> >> > >
- Next message: Kate: "error handle on '0 row selected'"
- Previous message: stjulian: "Re: Connecting to a FoxPro Database - VB6 on WindowsXP"
- In reply to: stjulian: "Re: Connecting to a FoxPro Database - VB6 on WindowsXP"
- Next in thread: stjulian: "Re: Connecting to a FoxPro Database - VB6 on WindowsXP"
- Reply: stjulian: "Re: Connecting to a FoxPro Database - VB6 on WindowsXP"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
