Re: ASP, Oracle & Fox Pro knitting it all together?

"Doug Clark" <Doug_at_NoStinkingSpam.com> wrote

> Is there any way I can examine the Fox Pro data from within
> Oracle?

Do not know FoxPro, but if it supports attaching tables ala MS Access style, then yes. In MS Access you can create tables in an Access database that are in fact tables on a remote database. All you need is an ODBC driver for Access to use to get to that remote database.

However, the downside of Access used to be network performance. Not sure if this has changed, but my brief experiences with Access users accessing Oracle that way, were not very pleasant. Access (or the Jet Engine to be precise) had an attrocious impact on the network. I would think that any file-based databasem such as FoxPro, that relies on file sharing will have less than ideal network performance.

> I like the ASP concept as I can connect to Oracle correctly and find the Fox
> Pro data automatically based on the project number. So Ideally I don't want
> to mess too much with the standard project Oracle structure as this will
> have to been maintained as new projects come along. Am I asking too much of
> the ASP?

Maybe.. The question is why use FoxPro at all? Is it not better to rather stick to Oracle only and not mix and match a very low-end filesharing based database with a high-end client server database?

--
Billy