Re: Access import off Fox Pro Tables

Thanks for your assistance Cindy.

I do have another issue cropping up if you don't mind. I have migrated a web
application to Windows 2003, IIS 6, which is using the visual fox pro driver
to read and write data to a fox pro database. It is an application that is
used to allow employees to submit requests to be registered in courses. We
have confirmed that the employee is able to register for courses and the data
is being written to the database. The manger is then able to approve the
course, however, on data does not show up in the manager view i.e no records
show up on the asp page. I have even tried running the query in SQL server
Query analyzer using a linked server to the fox pro database, but I still am
unable to see the data. This all currently works properly on a windows NT 4.0
server with IIS 4.0. Any ideas of what the problem might be? Any assistance
would be greatly appreciated.

thanks,
Sher.



"Cindy Winegarden" wrote:

> Try http://msdn.microsoft.com/vfoxpro/downloads/updates/ .
>
> --
> Cindy Winegarden Microsoft Visual FoxPro MVP
> cindy_winegarden@xxxxxxx www.cindywinegarden.com
> http://spaces.msn.com/members/cindywinegarden
>
>
> "Sher" <Sher@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:E5FEB345-2205-4E49-8B0F-AD2606B7CE88@xxxxxxxxxxxxxxxx
> > Cindy,
> >
> > I am having an issue installing the visual fox pro driver. When I download
> > and try to install from the link you provided, I am getting the error "The
> > feature you are trying to use is on a netowork resource that is not
> > available" I am trying to install this driver on a windows 2003 server
> > with
> > IIS 6. How can I get this VFP odbc driver?
> >
> > I would greatly appreciate any assistance from you.
> >
> > thanks,
> > Sherazad
> >
> > "Cindy Winegarden" wrote:
> >
> >> Hi SS,
> >>
> >> Here's something I posted earlier. Not all of it may apply to you.
> >>
> >> Start with the latest ODBC driver for FoxPro and Visual FoxPro, available
> >> from
> >> http://msdn.microsoft.com/vfox­pro/downloads/addons/odbc.asp. Download
> >> and
> >> install it. (If you have trouble doing this, post back.)
> >>
> >> You will need to determine whether you have FoxPro "free" tables or a
> >> "database container" (contains metadata about the tables themselves). To
> >> do
> >> this, navigate to your data directory and look for the presence of a DBC
> >> file. If it's there you have a "database" otherwise you have free tables.
> >>
> >>
> >> Now open up the ODBC dialog. In WinXP it's Start | Administrative Tools |
> >> Data Sources (ODBC). Choose either the User DSN or the System DSN. (The
> >> difference lies in whether you want other people to be able to see it if
> >> they use your machine.)
> >>
> >>
> >> Click Add... Scroll down to the Microsoft Visual FoxPro Driver. Scroll
> >> over
> >> to verify that it's version 6.01.8629.01. Click Finish.
> >>
> >>
> >> Now you're at the ODBC Visual FoxPro Setup dialog. In the first box (Data
> >> Source Name) enter a friendly name that you will use to recognize this
> >> data
> >> source - My FoxPro Data Source. You can add more text in the description
> >> box.
> >>
> >>
> >> Below are two options. Choose Visual FoxPro database (.DBC) or Free Table
> >> Directory - whichever you have determined is correct.
> >>
> >>
> >> Browse to locate your directory, or your specific DBC file.
> >>
> >>
> >> You can click the Options>> button for more choices. The defaults should
> >> be
> >> ok. "Exclusive" refers to whether you want to have exclusive access to
> >> the
> >> data while you're using it. "Null" allows you to enter Null values or
> >> not.
> >> Older FoxPro tables do not allow Nulls. "Deleted" means to hide deleted
> >> records. This one's important if you are working with primary keys - more
> >> in
> >> a minute. "Fetch data in background" will allow you to see the first few
> >> lines of a large table while the rest is being retrieved. You can also
> >> indicate a collating sequence if you're using a non-English alphabet.
> >>
> >>
> >> Click OK and you're done.
> >>
> >>
> >> Now, about deleted records. When a record is deleted in a FoxPro or
> >> Visual
> >> FoxPro table it's merely marked as deleted and filtered out, but is still
> >> physically present in the table. If you have a unique index and you
> >> delete
> >> the record with a key value of 123 you can not enter another record with
> >> this value, even though you can't see the record. To get rid of records
> >> entirely, you must issue a PACK command. However, the best rule to follow
> >> is
> >> to not reuse primary keys.
> >>
> >>
> >> Over the years, new features have been added to Fox data tables. The ODBC
> >> driver is only compatible with features used in VFP6 and under, although
> >> tables created with VFP7, 8, or 9 that don't use any of the new features
> >> will still be compatible with ODBC. Since you've connected on other
> >> machines
> >> then your tables must not have any of the new data features.
> >>
> >>
> >>
> >>
> >> In Microsoft Access in the Link Tables dialog you'll have to scroll to
> >> the
> >> bottom of the Files of type combo box and choose ODBC Databases. From
> >> there
> >> you can choose the data source you set up earlier and then a dialog will
> >> come up allowing you to choose tables.
> >>
> >>
> >> --
> >> Cindy Winegarden MCSD, Microsoft Most Valuable Professional
> >> cindy_winegarden@xxxxxxx www.cindywinegarden.com
> >> Blog: http://spaces.msn.com/members/cindywinegarden
> >>
> >>
> >> "ss" <ss@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> news:E2236A16-AC34-4AA5-9FDA-F14F313026BA@xxxxxxxxxxxxxxxx
> >> > How do I import or link an foxpro table to an Access database. I use
> >> > access
> >> > 2000 and fox pro 8.
> >> > In access 97 it is easy but I cant find out i access 2000.
> >>
> >>
> >>
>
>
>
.