Eddie Shipman
|
| Posted: 08/27/2001, 1:00 PM |
|
I keep getting this message when trying to view the examples
after they are generated:
The requested resource is in use.
What could be causing this? All using ASP 2.0 & Templates.
|
|
|
 |
Frédéric Malenfant
|
| Posted: 08/27/2001, 1:12 PM |
|
it happens to me some times (and some times don't I don't really know why!)
because codeCharge is using the access MDB file AND your web page ASP try to
open the same MDB file. What I do to prevent it is to copy the MDB file to
the inetpub/wwwroot/project directory, and in the database section, you can
set a connectionstring for codecharge, and for the site you choose custom,
you copy the one of codecharge but you change the place of the MDB file in
the connectionstring to use the one you copied under your IIS directory.
"Eddie Shipman" <eshipman@austin.rr.com> wrote in message
news:9me8s4$vf6$1@news.codecharge.com...
> I keep getting this message when trying to view the examples
> after they are generated:
>
> The requested resource is in use.
>
> What could be causing this? All using ASP 2.0 & Templates.
>
>
>
>
|
|
|
|
Eddie Shipman
|
| Posted: 08/27/2001, 1:36 PM |
|
Nope, that didn't do it. Sometimes I even
get a 500 trying to open the Defalut.asp page.
If I can not get the examples going out-of-the-box,
Why should I even purchase this product?
Sure you have examples on your site, but when I install
them and they do not work and there is no mention of any
prior setups needed, what am I to do?
Your "Get Started" tutorial is too generic with missing
steps.
You want this product to fly? Give the uses some idea
as to HOW TO USE YOUR PRODUCT!
> it happens to me some times (and some times don't I don't really know
why!)
> because codeCharge is using the access MDB file AND your web page ASP try
to
> open the same MDB file. What I do to prevent it is to copy the MDB file
to
> the inetpub/wwwroot/project directory, and in the database section, you
can
> set a connectionstring for codecharge, and for the site you choose custom,
> you copy the one of codecharge but you change the place of the MDB file in
> the connectionstring to use the one you copied under your IIS directory.
>
>
> "Eddie Shipman" wrote in message
> > I keep getting this message when trying to view the examples
> > after they are generated:
> >
> > The requested resource is in use.
> >
> > What could be causing this? All using ASP 2.0 & Templates.
|
|
|
|
Frédéric Malenfant
|
| Posted: 08/27/2001, 1:51 PM |
|
you should buy it because it's not expensive and will make you economize
$1000 + easily by making all the stupid job of displaying grids and doing
the data entry that's a good reason !
"Eddie Shipman" <eshipman@austin.rr.com> wrote in message
news:9meb0i$1b5$1@news.codecharge.com...
> Nope, that didn't do it. Sometimes I even
> get a 500 trying to open the Defalut.asp page.
>
> If I can not get the examples going out-of-the-box,
> Why should I even purchase this product?
> Sure you have examples on your site, but when I install
> them and they do not work and there is no mention of any
> prior setups needed, what am I to do?
>
> Your "Get Started" tutorial is too generic with missing
> steps.
>
> You want this product to fly? Give the uses some idea
> as to HOW TO USE YOUR PRODUCT!
>
>
>
|
|
|
|
Eddie Shipman
|
| Posted: 08/27/2001, 1:57 PM |
|
If I can not get it to work with teir examples, WHY should I waste $100?
It seems that ,even their support people aren't monitoring these groups to
help
people with questions like this.
> you should buy it because it's not expensive and will make you economize
> $1000 + easily by making all the stupid job of displaying grids and doing
> the data entry that's a good reason !
>
> "Eddie Shipman" wrote in message
> > Nope, that didn't do it. Sometimes I even
> > get a 500 trying to open the Defalut.asp page.
> >
> > If I can not get the examples going out-of-the-box,
> > Why should I even purchase this product?
> > Sure you have examples on your site, but when I install
> > them and they do not work and there is no mention of any
> > prior setups needed, what am I to do?
> >
> > Your "Get Started" tutorial is too generic with missing
> > steps.
> >
> > You want this product to fly? Give the uses some idea
> > as to HOW TO USE YOUR PRODUCT!
|
|
|
|
Steven Dowd
|
| Posted: 08/27/2001, 3:42 PM |
|
your system isnt letting you share the mdb file.. i have this problem , i
have to turn off codecharge befor i can view an asp produced page thats
linked to an mdb file used , when i close codecharge the produces asp works
great , with it open it just doesnt work , i have had this problem since
version 1.6 and its the same in t he latest v2 beta 5
steven
"Eddie Shipman" <eshipman@austin.rr.com> wrote in message
news:9mec7s$2e5$1@news.codecharge.com...
> If I can not get it to work with teir examples, WHY should I waste $100?
> It seems that ,even their support people aren't monitoring these groups to
> help
> people with questions like this.
>
> > you should buy it because it's not expensive and will make you economize
> > $1000 + easily by making all the stupid job of displaying grids and
doing
> > the data entry that's a good reason !
> >
> > "Eddie Shipman" wrote in message
> > > Nope, that didn't do it. Sometimes I even
> > > get a 500 trying to open the Defalut.asp page.
> > >
> > > If I can not get the examples going out-of-the-box,
> > > Why should I even purchase this product?
> > > Sure you have examples on your site, but when I install
> > > them and they do not work and there is no mention of any
> > > prior setups needed, what am I to do?
> > >
> > > Your "Get Started" tutorial is too generic with missing
> > > steps.
> > >
> > > You want this product to fly? Give the uses some idea
> > > as to HOW TO USE YOUR PRODUCT!
>
>
>
|
|
|
|
David A. Lee
|
| Posted: 08/27/2001, 3:49 PM |
|
Fortunately 'real' databases dont have this problem. Download Mysql for
free
from www.mysql.com and be done with it. Or purchase any of the
supported databases (SQLServer, Oracle etc ... )
By 'real database' I mean a database that was intended to be used
concurrently by multiple users. Access is not such. Access is a simplistic
single user database only intended for use by single users on local
machines.
Using it in CodeCharge, in my oppinion, is only useful for demo purposes ...
And even then, the frustrations of using Access outweigh its demo benifits
in my oppionion. This is not CodeCharge's defect, it is Access's ...
> your system isnt letting you share the mdb file.. i have this problem , i
> have to turn off codecharge befor i can view an asp produced page thats
> linked to an mdb file used , when i close codecharge the produces asp
works
> great , with it open it just doesnt work , i have had this problem since
> version 1.6 and its the same in t he latest v2 beta 5
>
> steven
>
>
> "Eddie Shipman" <eshipman@austin.rr.com> wrote in message
>news:9mec7s$2e5$1@news.codecharge.com...
> > If I can not get it to work with teir examples, WHY should I waste $100?
> > It seems that ,even their support people aren't monitoring these groups
to
> > help
> > people with questions like this.
> >
> > > you should buy it because it's not expensive and will make you
economize
> > > $1000 + easily by making all the stupid job of displaying grids and
> doing
> > > the data entry that's a good reason !
> > >
> > > "Eddie Shipman" wrote in message
> > > > Nope, that didn't do it. Sometimes I even
> > > > get a 500 trying to open the Defalut.asp page.
> > > >
> > > > If I can not get the examples going out-of-the-box,
> > > > Why should I even purchase this product?
> > > > Sure you have examples on your site, but when I install
> > > > them and they do not work and there is no mention of any
> > > > prior setups needed, what am I to do?
> > > >
> > > > Your "Get Started" tutorial is too generic with missing
> > > > steps.
> > > >
> > > > You want this product to fly? Give the uses some idea
> > > > as to HOW TO USE YOUR PRODUCT!
> >
> >
> >
>
>
|
|
|
|
Steven Dowd
|
| Posted: 08/27/2001, 6:52 PM |
|
david , I do only use Mysql , i was just trying to help eddie with my own
account of a similar problem,
i didnt try or want it to sound like a fault with codecharge or a problem
with access, but while we are on the subject, to be honest i do think its a
problem with the connection codecharge is making to the db , i think its
opening the access dbconnection in an exclusive mode and not a shared mode.
I know of many websites that successfully use access either through asp or
cfm connectons , and do not have locking problems , also when
I actually turn codecharge off , I can open multiple broswer connections to
a db no probs , so its got to be codecharge opening the access db exclusivly
that causes the problem. msaccess when it opens an mdb file has the option
to open files in shared or exclusive modes,
I can see why access is opened in this way , because codecharge needs to
know that the tables it opened at the start of a session are still going to
be there at the end of a session , but if it generates this error as a
result , maybe there should be a warning popup on publishing locally with
access in the source and published db selections that there is or could be
an error till you close codecharge
"David A. Lee" <dave@calldei.com> wrote in message
news:9meiq5$7aj$1@news.codecharge.com...
> Fortunately 'real' databases dont have this problem. Download Mysql for
> free
> from www.mysql.com and be done with it. Or purchase any of the
> supported databases (SQLServer, Oracle etc ... )
>
> By 'real database' I mean a database that was intended to be used
> concurrently by multiple users. Access is not such. Access is a
simplistic
> single user database only intended for use by single users on local
> machines.
> Using it in CodeCharge, in my oppinion, is only useful for demo purposes
....
> And even then, the frustrations of using Access outweigh its demo benifits
> in my oppionion. This is not CodeCharge's defect, it is Access's ...
>
>
>
> > your system isnt letting you share the mdb file.. i have this problem ,
i
> > have to turn off codecharge befor i can view an asp produced page thats
> > linked to an mdb file used , when i close codecharge the produces asp
> works
> > great , with it open it just doesnt work , i have had this problem since
> > version 1.6 and its the same in t he latest v2 beta 5
> >
> > steven
> >
> >
> > "Eddie Shipman" <eshipman@austin.rr.com> wrote in message
> >news:9mec7s$2e5$1@news.codecharge.com...
> > > If I can not get it to work with teir examples, WHY should I waste
$100?
> > > It seems that ,even their support people aren't monitoring these
groups
> to
> > > help
> > > people with questions like this.
> > >
> > > > you should buy it because it's not expensive and will make you
> economize
> > > > $1000 + easily by making all the stupid job of displaying grids and
> > doing
> > > > the data entry that's a good reason !
> > > >
> > > > "Eddie Shipman" wrote in message
> > > > > Nope, that didn't do it. Sometimes I even
> > > > > get a 500 trying to open the Defalut.asp page.
> > > > >
> > > > > If I can not get the examples going out-of-the-box,
> > > > > Why should I even purchase this product?
> > > > > Sure you have examples on your site, but when I install
> > > > > them and they do not work and there is no mention of any
> > > > > prior setups needed, what am I to do?
> > > > >
> > > > > Your "Get Started" tutorial is too generic with missing
> > > > > steps.
> > > > >
> > > > > You want this product to fly? Give the uses some idea
> > > > > as to HOW TO USE YOUR PRODUCT!
> > >
> > >
> > >
> >
> >
>
>
|
|
|
|
David A. Lee
|
| Posted: 08/27/2001, 7:36 PM |
|
Very good points, however I still wouldnt use Access for anything multi-user
as any WWW app is intrinsically. But thats my personal professional
oppinion.
However ... isnt CodeCharge just using ODBC ? and not Access directly ?
Is there modes in ODBC to control this sharing behaviour of Access ?
I would *guess* there might be if this is a regression in CodeCharge.
I've been blissfull enough to be able to avoid coding in ODBC myself ...
(thats why we have CodeCharge to the rescue !!!)
-David
> david , I do only use Mysql , i was just trying to help eddie with my own
> account of a similar problem,
>
> i didnt try or want it to sound like a fault with codecharge or a problem
> with access, but while we are on the subject, to be honest i do think its
a
> problem with the connection codecharge is making to the db , i think its
> opening the access dbconnection in an exclusive mode and not a shared
mode.
>
> I know of many websites that successfully use access either through asp or
> cfm connectons , and do not have locking problems , also when
> I actually turn codecharge off , I can open multiple broswer connections
to
> a db no probs , so its got to be codecharge opening the access db
exclusivly
> that causes the problem. msaccess when it opens an mdb file has the option
> to open files in shared or exclusive modes,
>
> I can see why access is opened in this way , because codecharge needs to
> know that the tables it opened at the start of a session are still going
to
> be there at the end of a session , but if it generates this error as a
> result , maybe there should be a warning popup on publishing locally with
> access in the source and published db selections that there is or could
be
> an error till you close codecharge
|
|
|
|
|
