Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Mon Jan 3 19:30:39 CST 2005
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 >