MartyConnelly
martyconnelly at shaw.ca
Mon Jan 3 20:09:09 CST 2005
Check if you have a .dbc file (metatable file) that incorporates the
free table directory.
Try linking to that. It's existance is dependant on version of Foxpro.
the OLE DB Provider may not work without it.
I haven't tried it not sure of syntax but just point to dbf table directory
oConn.Open "Provider=vfpoledb;" & _
"Data Source=C:\vfp8\Samples\DatadbfDir;" & _
"SourceType=DBF;" & _
"Mode=ReadWrite|Share Deny None;" & _
"Collating Sequence=MACHINE;" & _
"Password=''"
Rocky Smolin - Beach Access Software wrote:
> Marty:
>
> I was hoping to link to these table inthe database container and avoid
> the coding.
>
> But if I hafta, I hafta.
>
> Rocky
>
> ----- Original Message ----- From: "MartyConnelly"
> <martyconnelly at shaw.ca>
> To: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> Sent: Monday, January 03, 2005 4:42 PM
> Subject: Re: [AccessD] Reading FoxPro Tables
>
>
>> 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
>>
>>
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>
--
Marty Connelly
Victoria, B.C.
Canada