MartyConnelly
martyconnelly at shaw.ca
Mon Jan 3 18:42:44 CST 2005
Instead of using the ODBC how about "Microsoft OLE DB Provider for
Visual FoxPro 8.0" , the ODBC is good only up to Visual FoxPro 6.0
9.0 is out in Beta.
Microsoft OLE DB Provider for Visual FoxPro 8.0
It should be backward compatible. How far back I dunno.
The Visual FoxPro OLE DB Provider is supported by OLE DB System
Components as provided by MDAC 2.6 or later
Mdac 2.6 is installable by Win98 SE +
However MDAC 2.7 is Win2000+
http://www.microsoft.com/downloads/details.aspx?FamilyId=0F43EB58-7A94-4AE1-A59E-965869CB3BC9&displaylang=en
Sample connection string
OLE DB Provider for Visual FoxPro
oConn.Open "Provider=vfpoledb;" & _
"Data Source=C:\vfp8\Samples\Data\myVFPDB.dbc;" & _
"Mode=ReadWrite|Share Deny None;" & _
"Collating Sequence=MACHINE;" & _
"Password=''"
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_foxhelp/html/dggrfoledbproviderforvisualfoxpro.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_foxhelp/html/foorivisualfoxprodataaccessusingoledbprovider.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_foxhelp/html/dgtskaccessingvisualfoxprodatainmicrosoftofficexp.asp
Visual FoxPro 9.0 Beta
Download for Microsoft Visual FoxPro 9.0 public beta. Good until March
31 2005
http://www.microsoft.com/downloads/details.aspx?familyid=23fbc57b-93b0-4cb7-b376-53ca04fca159&displaylang=en
Rocky Smolin - Beach Access Software wrote:
> Making some progress. I downloaded from:
>
> http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx
>
> Now I can link some of the tables by selecting ODBC databases, then in
> Select Data Source select Visual FoxPro Database, in the Configure
> Connection dialog select Free Table Directory, browse to the directory
> containing the free tables, clock OK then I get a list of tables but
> not all of the .dbf tables are in the link list that are in the
> directory.
>
> So I'm getting closer.
>
> Do you know of some reason why all of the tables wouldn't appear in
> the link tables list?
>
> Regards,
>
> Rocky Smolin
> Beach Access Software
> http://www.e-z-mrp.com
> 858-259-4334
>
>
> ----- Original Message ----- From: "Gary Kjos" <garykjos at gmail.com>
> To: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> Sent: Monday, January 03, 2005 3:14 PM
> Subject: Re: [AccessD] Reading FoxPro Tables
>
>
>> Crud....how about this stuff. Might give you some clues anyway.
>>
>> http://support.microsoft.com/kb/q200393/
>> http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx
>> http://www.experts-exchange.com/Databases/FoxPro/Q_20924251.html
>> http://www.experts-exchange.com/Databases/FoxPro/Q_21046680.html
>> http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm
>>
>>
>> On Mon, 3 Jan 2005 14:43:59 -0800, Rocky Smolin - Beach Access
>> Software <bchacc at san.rr.com> wrote:
>>
>>> Gary:
>>>
>>> Failed. It tells me to download the latest version of MDAC. SO I
>>> download
>>> 2.8 and it tells me that it's incompatible with my current OS.
>>>
>>> So I go to the instructions to create the data source in the Control
>>> Panel.
>>> But I get an error when I select the Visual FoxPro driver - tells me
>>> I must
>>> install the current version of the visual FoxPro driver and directs
>>> me to a
>>> page that no longer exists to get the update.
>>>
>>> Microsoft...gotta love 'em.
>>>
>>> Rocky
>>>
>>> ----- Original Message -----
>>> From: "Gary Kjos" <garykjos at gmail.com>
>>> To: "Access Developers discussion and problem solving"
>>> <accessd at databaseadvisors.com>
>>> Sent: Monday, January 03, 2005 10:19 AM
>>> Subject: Re: [AccessD] Reading FoxPro Tables
>>>
>>> > Didja look at this in the KB?
>>> >
>>> > "HOW TO: Use Visual FoxPro DBC Files in Microsoft Access 2000"
>>> >
>>> > http://support.microsoft.com/?kbid=197893
>>> >
>>> >
>>> > On Mon, 3 Jan 2005 09:02:04 -0800, Rocky Smolin - Beach Access
>>> > Software <bchacc at san.rr.com> wrote:
>>> >> Drew:
>>> >>
>>> >> The first problem is that when I try to link tables, in the combo
>>> box
>>> >> 'Files
>>> >> of Type' there's no Fox Pro option, unlike my A97 install. There
>>> is >> ODBC
>>> >> Databases.
>>> >>
>>> >> When I select that I get the Select Data Source dialog box. In
>>> the >> File
>>> >> Data Source I have Microsoft FoxPro VFP Driver.dsn which I added
>>> but >> I'm
>>> >> not
>>> >> sure I did it correctly. Anyway, when I select it I get a fatal
>>> error
>>> >> ODBC--call failed, Driver does not support this function (#0).
>>> >>
>>> >> And that's where I'm currently stuck.
>>> >>
>>> >> Rocky
>>> >>
>>> >>
>>> >> ----- Original Message -----
>>> >> From: <DWUTKA at marlow.com>
>>> >> To: <accessd at databaseadvisors.com>
>>> >> Sent: Monday, January 03, 2005 7:05 AM
>>> >> Subject: RE: [AccessD] Reading FoxPro Tables
>>> >>
>>> >> > What error message are you getting from Access when trying to
>>> import >> > or
>>> >> > link
>>> >> > the data from the .dbf files? Do the .dbf files have
>>> coinciding >> > .inf
>>> >> > files?
>>> >> > That's a file that Jet likes to put in there for Access to
>>> 'know' >> > where
>>> >> > the
>>> >> > .cdx files are for the .dbf files. If there is a mapped drive
>>> >> > letter
>>> >> > in
>>> >> > there, Access get's flaky, and doesn't ask for the location of the
>>> >> > index
>>> >> > files, it just assumes the worse and says it can't find them.
>>> >> >
>>> >> > Drew
>>> >> >
>>> >> > -----Original Message-----
>>> >> > From: Rocky Smolin - Beach Access Software >> >
>>> [mailto:bchacc at san.rr.com]
>>> >> > Sent: Saturday, January 01, 2005 10:03 AM
>>> >> > To: AccessD at databaseadvisors.com
>>> >> > Subject: [AccessD] Reading FoxPro Tables
>>> >> >
>>> >> >
>>> >> > Dear List:
>>> >> >
>>> >> > I have a requirement to get data from an application written in
>>> >> > FoxPro.
>>> >> > I
>>> >> > tried linking the tables to an Access database but apparently I
>>> >> > can't
>>> >> > do
>>> >> > that. I tried to set up the ODBC thingy in the ODBC manager
>>> but got
>>> >> > stuck
>>> >> > on the DSN field. Don't know what to put there.
>>> >> >
>>> >> > Can someone get me pointed in the right direction?
>>> >> >
>>> >> > Many Thanks In Advance and a Happy New Year To All,
>>> >> >
>>> >> > Rocky Smolin
>>> >> > Beach Access Software
>>> >> > http://www.e-z-mrp.com
>>> >> > 858-259-4334
>>> >> > --
>>> >> > AccessD mailing list
>>> >> > AccessD at databaseadvisors.com
>>> >> > http://databaseadvisors.com/mailman/listinfo/accessd
>>> >> > Website: http://www.databaseadvisors.com
>>> >> > --
>>> >> > AccessD mailing list
>>> >> > AccessD at databaseadvisors.com
>>> >> > http://databaseadvisors.com/mailman/listinfo/accessd
>>> >> > Website: http://www.databaseadvisors.com
>>> >> >
>>> >>
>>> >> --
>>> >> AccessD mailing list
>>> >> AccessD at databaseadvisors.com
>>> >> http://databaseadvisors.com/mailman/listinfo/accessd
>>> >> Website: http://www.databaseadvisors.com
>>> >>
>>> >
>>> >
>>> > --
>>> > Gary Kjos
>>> > garykjos at gmail.com
>>> > --
>>> > AccessD mailing list
>>> > AccessD at databaseadvisors.com
>>> > http://databaseadvisors.com/mailman/listinfo/accessd
>>> > Website: http://www.databaseadvisors.com
>>> >
>>>
>>> --
>>> AccessD mailing list
>>> AccessD at databaseadvisors.com
>>> http://databaseadvisors.com/mailman/listinfo/accessd
>>> Website: http://www.databaseadvisors.com
>>>
>>
>>
>> --
>> Gary Kjos
>> garykjos at gmail.com
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>
--
Marty Connelly
Victoria, B.C.
Canada