ASP and VFP

[M. Ingham]

I am working with a 6.0 V. FoxPro database that has a front-end and also serves
as the back end data for an ASP aplication using ADO 2.0. However, the ASP
application is unable to use the actual database, and must use a copy, because
trying to access the live one always fails for sharing reasons. How can I
set up the database so it can be used normally and also by the ASP application?
-Matt

[William Fields]

"trying to access the live one always fails for sharing reasons"

That sounds kind of odd. Is the DBC being opened exclusively by the VFP
front end app?

--
William Fields
MCP - Microsoft Visual FoxPro
US Bankruptcy Court
Phoenix, AZ

"While the Complexity of this Project is
several orders of magnitude less than
modeling heat flux in a fossil-fuel fired
electric utility plant using the Hottel Zone
technique, the context of each project
evolves in a remarkably similar fashion."
- Author Unknown


"M. Ingham" <mai@pgcalc.com> wrote in message
news:3947de80$1@news.devx.com...
>
> I am working with a 6.0 V. FoxPro database that has a front-end and also
serves
> as the back end data for an ASP aplication using ADO 2.0. However, the ASP
> application is unable to use the actual database, and must use a copy,
because
> trying to access the live one always fails for sharing reasons. How can I
> set up the database so it can be used normally and also by the ASP
application?
> -Matt

[David Frankenbach]

Matt,

VFP COM objects run in the standard default VFP environment. It does not use
the environment that your Tools/Options settings have established for design
time. You need to make sure you do things like SET EXCLUSIVE OFF.
--
df - (Microsoft FoxPro MVP) http://www.geocities.com/df_FoxPro/

"M. Ingham" <mai@pgcalc.com> wrote in message
news:3947de80$1@news.devx.com...
>
> I am working with a 6.0 V. FoxPro database that has a front-end and also
serves
> as the back end data for an ASP aplication using ADO 2.0. However, the ASP
> application is unable to use the actual database, and must use a copy,
because
> trying to access the live one always fails for sharing reasons. How can I
> set up the database so it can be used normally and also by the ASP
application?
> -Matt