Database results error

[Culbert]

I've originally posted this in the front page extensions
page, but was told to stop by here.

Here's a copy of what we said.

Any ideas on how this is happening and if I can fix it?
----------------------

The limit isn't 10 people, it's 10 connections.
Unfortunately, there isn't a
1-to-1 correlation between connections and visitors. It
could be that only
two people at once can eat up all the possible
connections. It's happened to
me before when the only two users accessing my dev
machine were myself on
the dev machine, and one other test machine.

It could be that the connections for the Access db aren't
being closed
properly and are causing contention, or that the OS is
locking the file when
it's first being called which will cause subsequent calls
to bomb. Repairing
a database can never hurt, just make sure that you make a
copy of the db
before you repair it in case the repair goes screwey.

You might want to try posting in the
public.inetserver.asp newsgroups (there
are several) as they may have some better ideas on what
may have caused the
problem to start recently.

Hope tihs helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage


"Culbert" <anonymous@discussions.microsoft.com> wrote in
message
news:477601c4735a$5ba66960$a301280a@phx.gbl...

> Another thing. I'm kinda the server admin. This was

just

> a workstation, but I installed IIS on it and since it's
> only Win 2K Pro we only can have 10 people on the site

at

> one time. This isn't a problem at all because we have a
> small group. Traffic, needless to say, isn't a big deal
> here. :o)
>
>
>
>

> >-----Original Message-----
> >Actually I haven't applied any patches lately, but it

is

> >an Access database backend. Should I use the repair
> >feature on the database or wouldn't that help the

> database

> >results?
> >

> >>-----Original Message-----
> >>Have you applied any of the recent windows updates

that

> >prevent a security

> >>issue with ADO? You may want to check and make sure

that

> >you arne't having

> >>any issues with that particular patch. Also, have you

> >checked the server

> >>logs? If the site is getting more hits lately it could

> be

> >that the database

> >>is having trouble. Access databases, for example,

> degrade

> >seriously as the

> >>number of simultaneous users increase.
> >>
> >> Hope this helps,
> >> Mark Fitzpatrick
> >> Microsoft MVP - FrontPage
> >>
> >>"Culbert" <anonymous@discussions.microsoft.com> wrote

in

> >message

> >>news:474101c47356$002a2440$a301280a@phx.gbl...
> >>> I'm getting this error message in internet

explorer...

> >>>
> >>> "Database Results Error The operation failed. If

this

> >>> continues, please contact your server

administrator."

> >>> Problem is, is that I'm the server administrator!"

> It's

> >>> really weird because it just all of a sudden starts

to

> >>> happen, and only on certain pages. Some other pages

> >work

> >>> just fine. Any reason for this?

[Ray at]

For one, make sure that you are immediately closing and destroying your ADO
connections and not opening them any sooner than absolutely necessary. Use
GetRows to get a recordset and then close and destroy. See here:
[url]http://www.aspfaq.com/show.asp?id=2424#db[/url]

The real solution would be to stop using Access. Access if fine for a home
intranet or something along those lines, but it is not meant for anything
that is even remotely beginning to approach an enterprise level application.
I could use a couple of scissors jacks to jack up my car and drop the
transmission, but chances are something's going to break and land on my
person. If you don't use the right tools for the job, you're bound to have
problems.

Ray at work

"Culbert" <anonymous@discussions.microsoft.com> wrote in message
news:481a01c47367$5a51c2f0$a601280a@phx.gbl...

> I've originally posted this in the front page extensions
> page, but was told to stop by here.
>
> Here's a copy of what we said.
>
> Any ideas on how this is happening and if I can fix it?
> ----------------------
>
> The limit isn't 10 people, it's 10 connections.
> Unfortunately, there isn't a
> 1-to-1 correlation between connections and visitors. It
> could be that only
> two people at once can eat up all the possible
> connections. It's happened to
> me before when the only two users accessing my dev
> machine were myself on
> the dev machine, and one other test machine.
>
> It could be that the connections for the Access db aren't
> being closed
> properly and are causing contention, or that the OS is
> locking the file when
> it's first being called which will cause subsequent calls
> to bomb. Repairing
> a database can never hurt, just make sure that you make a
> copy of the db
> before you repair it in case the repair goes screwey.
>
> You might want to try posting in the
> public.inetserver.asp newsgroups (there
> are several) as they may have some better ideas on what
> may have caused the
> problem to start recently.
>
> Hope tihs helps,
> Mark Fitzpatrick
> Microsoft MVP - FrontPage
>
>
> "Culbert" <anonymous@discussions.microsoft.com> wrote in
> message
> news:477601c4735a$5ba66960$a301280a@phx.gbl...

>> Another thing. I'm kinda the server admin. This was

> just

>> a workstation, but I installed IIS on it and since it's
>> only Win 2K Pro we only can have 10 people on the site

> at

>> one time. This isn't a problem at all because we have a
>> small group. Traffic, needless to say, isn't a big deal
>> here. :o)
>>
>>
>>
>>

>> >-----Original Message-----
>> >Actually I haven't applied any patches lately, but it

> is

>> >an Access database backend. Should I use the repair
>> >feature on the database or wouldn't that help the

>> database

>> >results?
>> >
>> >>-----Original Message-----
>> >>Have you applied any of the recent windows updates

> that

>> >prevent a security
>> >>issue with ADO? You may want to check and make sure

> that

>> >you arne't having
>> >>any issues with that particular patch. Also, have you
>> >checked the server
>> >>logs? If the site is getting more hits lately it could

>> be

>> >that the database
>> >>is having trouble. Access databases, for example,

>> degrade

>> >seriously as the
>> >>number of simultaneous users increase.
>> >>
>> >> Hope this helps,
>> >> Mark Fitzpatrick
>> >> Microsoft MVP - FrontPage
>> >>
>> >>"Culbert" <anonymous@discussions.microsoft.com> wrote

> in

>> >message
>> >>news:474101c47356$002a2440$a301280a@phx.gbl...
>> >>> I'm getting this error message in internet

> explorer...

>> >>>
>> >>> "Database Results Error The operation failed. If

> this

>> >>> continues, please contact your server

> administrator."

>> >>> Problem is, is that I'm the server administrator!"

>> It's

>> >>> really weird because it just all of a sudden starts

> to

>> >>> happen, and only on certain pages. Some other pages
>> >work
>> >>> just fine. Any reason for this?

>

[Culbert]

I would LOVE to use something other than access, but I
have a $0 budget and can only use Microsoft 2000 operating
system. Is there any other options I have? Also, here's
a link to my code. All i've ever used was the front page
wizards so I'm not very familiar with the actual code. Do
you see anything that looks like it's not right?

Also - I use a query where I query by date provided by the
text box input from a user. When I insert the database
results I get the data, but when I add the date criteria I
get the error. I read in the knowledge base that I had to
change the ' marks to # marks which I've done, but it
still doesn't work.

here's the link
[url]http://www.neolinkcomputers.com/stuff/cc.htm[/url]

>-----Original Message-----
>For one, make sure that you are immediately closing and

destroying your ADO

>connections and not opening them any sooner than

absolutely necessary. Use

>GetRows to get a recordset and then close and destroy.

See here:

>[url]http://www.aspfaq.com/show.asp?id=2424#db[/url]
>
>The real solution would be to stop using Access. Access

if fine for a home

>intranet or something along those lines, but it is not

meant for anything

>that is even remotely beginning to approach an enterprise

level application.

>I could use a couple of scissors jacks to jack up my car

and drop the

>transmission, but chances are something's going to break

and land on my

>person. If you don't use the right tools for the job,

you're bound to have

>problems.
>
>Ray at work
>
>"Culbert" <anonymous@discussions.microsoft.com> wrote in

message

>news:481a01c47367$5a51c2f0$a601280a@phx.gbl...

>> I've originally posted this in the front page extensions
>> page, but was told to stop by here.
>>
>> Here's a copy of what we said.
>>
>> Any ideas on how this is happening and if I can fix it?
>> ----------------------
>>
>> The limit isn't 10 people, it's 10 connections.
>> Unfortunately, there isn't a
>> 1-to-1 correlation between connections and visitors. It
>> could be that only
>> two people at once can eat up all the possible
>> connections. It's happened to
>> me before when the only two users accessing my dev
>> machine were myself on
>> the dev machine, and one other test machine.
>>
>> It could be that the connections for the Access db

aren't

>> being closed
>> properly and are causing contention, or that the OS is
>> locking the file when
>> it's first being called which will cause subsequent

calls

>> to bomb. Repairing
>> a database can never hurt, just make sure that you make

a

>> copy of the db
>> before you repair it in case the repair goes screwey.
>>
>> You might want to try posting in the
>> public.inetserver.asp newsgroups (there
>> are several) as they may have some better ideas on what
>> may have caused the
>> problem to start recently.
>>
>> Hope tihs helps,
>> Mark Fitzpatrick
>> Microsoft MVP - FrontPage
>>
>>
>> "Culbert" <anonymous@discussions.microsoft.com> wrote in
>> message
>> news:477601c4735a$5ba66960$a301280a@phx.gbl...

>>> Another thing. I'm kinda the server admin. This was

>> just

>>> a workstation, but I installed IIS on it and since it's
>>> only Win 2K Pro we only can have 10 people on the site

>> at

>>> one time. This isn't a problem at all because we have

a

>>> small group. Traffic, needless to say, isn't a big

deal

>>> here. :o)
>>>
>>>
>>>
>>>
>>> >-----Original Message-----
>>> >Actually I haven't applied any patches lately, but it

>> is

>>> >an Access database backend. Should I use the repair
>>> >feature on the database or wouldn't that help the
>>> database
>>> >results?
>>> >
>>> >>-----Original Message-----
>>> >>Have you applied any of the recent windows updates

>> that

>>> >prevent a security
>>> >>issue with ADO? You may want to check and make sure

>> that

>>> >you arne't having
>>> >>any issues with that particular patch. Also, have you
>>> >checked the server
>>> >>logs? If the site is getting more hits lately it

could

>>> be
>>> >that the database
>>> >>is having trouble. Access databases, for example,
>>> degrade
>>> >seriously as the
>>> >>number of simultaneous users increase.
>>> >>
>>> >> Hope this helps,
>>> >> Mark Fitzpatrick
>>> >> Microsoft MVP - FrontPage
>>> >>
>>> >>"Culbert" <anonymous@discussions.microsoft.com> wrote

>> in

>>> >message
>>> >>news:474101c47356$002a2440$a301280a@phx.gbl...
>>> >>> I'm getting this error message in internet

>> explorer...

>>> >>>
>>> >>> "Database Results Error The operation failed. If

>> this

>>> >>> continues, please contact your server

>> administrator."

>>> >>> Problem is, is that I'm the server administrator!"
>>> It's
>>> >>> really weird because it just all of a sudden starts

>> to

>>> >>> happen, and only on certain pages. Some other

pages

>>> >work
>>> >>> just fine. Any reason for this?

>>

>
>
>.
>

[Ray at]

"Culbert" <anonymous@discussions.microsoft.com> wrote in message
news:511201c473f0$37537c60$a501280a@phx.gbl...

>I would LOVE to use something other than access, but I
> have a $0 budget and can only use Microsoft 2000 operating
> system. Is there any other options I have?

I think there are many people who opt to use MySQL when they need to go
beyond Access but don't have the budget for SQL Server. Another option is
MSDE (to later be known as SQL Server Express), which is a throttled-down
version of SQL Server - and it's free.

[url]http://www.microsoft.com/downloads/details.aspx?FamilyID=413744d1-a0bc-479f-bafa-e4b278eb9147[/url]

> Also, here's
> a link to my code. All i've ever used was the front page
> wizards so I'm not very familiar with the actual code. Do
> you see anything that looks like it's not right?
>
> Also - I use a query where I query by date provided by the
> text box input from a user. When I insert the database
> results I get the data, but when I add the date criteria I
> get the error. I read in the knowledge base that I had to
> change the ' marks to # marks which I've done, but it
> still doesn't work.

When using Access, you delimit values for date columns with #. Text/memo
columns get '. I don't know that you'll find much support if you're using
Frontpage. Frontpage really isn't what you should be using to develop ASP
pages... I'm sorry.

Ray at work

[Culbert]

No need to be sorry. I'm still learning so this is great
stuff for me to learn. I may try that MSDE though and
I'll try to create some database results pages.

Thanks!

>-----Original Message-----
>
>"Culbert" <anonymous@discussions.microsoft.com> wrote in

message

>news:511201c473f0$37537c60$a501280a@phx.gbl...

>>I would LOVE to use something other than access, but I
>> have a $0 budget and can only use Microsoft 2000

operating

>> system. Is there any other options I have?

>
>I think there are many people who opt to use MySQL when

they need to go

>beyond Access but don't have the budget for SQL Server.

Another option is

>MSDE (to later be known as SQL Server Express), which is

a throttled-down

>version of SQL Server - and it's free.
>
>[url]http://www.microsoft.com/downloads/details.aspx?[/url]

FamilyID=413744d1-a0bc-479f-bafa-e4b278eb9147

>

>> Also, here's
>> a link to my code. All i've ever used was the front

page

>> wizards so I'm not very familiar with the actual code.

Do

>> you see anything that looks like it's not right?
>>
>> Also - I use a query where I query by date provided by

the

>> text box input from a user. When I insert the database
>> results I get the data, but when I add the date

criteria I

>> get the error. I read in the knowledge base that I had

to

>> change the ' marks to # marks which I've done, but it
>> still doesn't work.

>
>When using Access, you delimit values for date columns

with #. Text/memo

>columns get '. I don't know that you'll find much

support if you're using

>Frontpage. Frontpage really isn't what you should be

using to develop ASP

>pages... I'm sorry.
>
>Ray at work
>
>
>.
>