HighDots Forums  

Using DW for ASP

Macromedia Dreamweaver Macromedia Dreamweaver Discussions (macromedia.dreamweaver)


Discuss Using DW for ASP in the Macromedia Dreamweaver forum.



Reply
 
Thread Tools Display Modes
  #11  
Old   
Les Matthews
 
Posts: n/a

Default Re: Using DW for ASP - 07-21-2004 , 05:54 PM






It could be that you have an un-ending script, like an infinite loop. This
error will also show up from time to time in a shared web hosting
environment for any website that is using a Microsoft Access database.
Potential causes for this error are:
1) connecting to the Access database using odbc instead of using the more
reliable OLEDB JET driver.
2) running an extreamly large query, which Access can not deal with.


"Durwood Edwards" <durwoode (AT) NOSPAMbellsouth (DOT) net> wrote

Quote:
Well I have been using it for a few years and love it, but our server has
started to throw the old " . . . System resources exceeded . . ." error
about every 1.25 days. I am not absolutely certain it is the fault of the
ASP, but cannot say for sure.
It is getting to be a real super inconvenience to have to reboot and relog
the web server every day.
Durwood
"Murray *TMM*" <forums (AT) HAHAgreat-web-sights (DOT) com> wrote in message
news:cdmfca$77b$1 (AT) forums (DOT) macromedia.com...
Yes. Works like a charm!

--
Murray --- ICQ 71997575
Team Macromedia Volunteer for Dreamweaver
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================

"Durwood Edwards" <durwoode (AT) NOSPAMbellsouth (DOT) net> wrote in message
news:cdmeuv$6mm$1 (AT) forums (DOT) macromedia.com...
Either of you use it to do database connections?

Durwood
"Chris In Madison" <cowens (AT) cnwGOAWAYDIRTYRATSPAMMERS (DOT) com> wrote in
message
news:cdlroi$9ms$1 (AT) forums (DOT) macromedia.com...
I've been using Dreamweaver and/or UltraDev for ASP for several
years
now.
It works fabulously :-)

Best regards,
Chris











Reply With Quote
  #12  
Old   
Durwood Edwards
 
Posts: n/a

Default Re: Using DW for ASP - 07-22-2004 , 08:48 AM






Just using the stock Dreamweaver generated stuff and mostly DSN connections.
I have been trying to change over to MS Jet connection strings.

No large querys involved. The queries always succeed (Never timeout or any
error once initiated) if the page will load at all.
Durwood
"Les Matthews" <lesamatthews (AT) yahoo (DOT) com> wrote

Quote:
It could be that you have an un-ending script, like an infinite loop. This
error will also show up from time to time in a shared web hosting
environment for any website that is using a Microsoft Access database.
Potential causes for this error are:
1) connecting to the Access database using odbc instead of using the more
reliable OLEDB JET driver.
2) running an extreamly large query, which Access can not deal with.


"Durwood Edwards" <durwoode (AT) NOSPAMbellsouth (DOT) net> wrote in message
news:cdmj0i$bn2$1 (AT) forums (DOT) macromedia.com...
Well I have been using it for a few years and love it, but our server
has
started to throw the old " . . . System resources exceeded . . ." error
about every 1.25 days. I am not absolutely certain it is the fault of
the
ASP, but cannot say for sure.
It is getting to be a real super inconvenience to have to reboot and
relog
the web server every day.
Durwood
"Murray *TMM*" <forums (AT) HAHAgreat-web-sights (DOT) com> wrote in message
news:cdmfca$77b$1 (AT) forums (DOT) macromedia.com...
Yes. Works like a charm!

--
Murray --- ICQ 71997575
Team Macromedia Volunteer for Dreamweaver
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================

"Durwood Edwards" <durwoode (AT) NOSPAMbellsouth (DOT) net> wrote in message
news:cdmeuv$6mm$1 (AT) forums (DOT) macromedia.com...
Either of you use it to do database connections?

Durwood
"Chris In Madison" <cowens (AT) cnwGOAWAYDIRTYRATSPAMMERS (DOT) com> wrote in
message
news:cdlroi$9ms$1 (AT) forums (DOT) macromedia.com...
I've been using Dreamweaver and/or UltraDev for ASP for several
years
now.
It works fabulously :-)

Best regards,
Chris













Reply With Quote
  #13  
Old   
Leesa
 
Posts: n/a

Default Re: Using DW for ASP - 07-22-2004 , 09:38 AM



From what I understand Access does pretty well as long as the only person
accessing it is the owner doing updates with an html back end. Once you start
getting multiple people accessing the db at the same time (like many people
submitting ads at the same time to the db) is when access can't handle it. It
is designed as a desktop db for single user access. That's what I use MS
Access for.

It's easy to learn using DW & Access so you might want to just use it as a
stepping stone and learn php & MySql.

Good luck.




Reply With Quote
  #14  
Old   
Murray *TMM*
 
Posts: n/a

Default Re: Using DW for ASP - 07-22-2004 , 09:55 AM



Access can handle more than that, but it doesn't scale gracefully. I
believe that the magic number is in the range of 5-10 hits on the same
record at the same time. If you are expecting that much activity, then you
will need to use SQL technology.

--
Murray --- ICQ 71997575
Team Macromedia Volunteer for Dreamweaver
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================

"Leesa" <webforumsuser (AT) macromedia (DOT) com> wrote

Quote:
From what I understand Access does pretty well as long as the only person
accessing it is the owner doing updates with an html back end. Once you
start
getting multiple people accessing the db at the same time (like many
people
submitting ads at the same time to the db) is when access can't handle it.
It
is designed as a desktop db for single user access. That's what I use MS
Access for.

It's easy to learn using DW & Access so you might want to just use it as
a
stepping stone and learn php & MySql.

Good luck.






Reply With Quote
  #15  
Old   
Durwood Edwards
 
Posts: n/a

Default Re: Using DW for ASP - 07-22-2004 , 11:19 AM



We're surprised if any database available on line gets more than a dozen
hits per day. Nothing of what we are doing requires us to reach for the
Oracle.
I haven't seen activity cited as a possible culprit for the error we are
getting. It is a memory leak thing and remains a mystery and irritant.

D

"Murray *TMM*" <forums (AT) HAHAgreat-web-sights (DOT) com> wrote

Quote:
Access can handle more than that, but it doesn't scale gracefully. I
believe that the magic number is in the range of 5-10 hits on the same
record at the same time. If you are expecting that much activity, then
you
will need to use SQL technology.

--
Murray --- ICQ 71997575
Team Macromedia Volunteer for Dreamweaver
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================

"Leesa" <webforumsuser (AT) macromedia (DOT) com> wrote in message
news:cdog13$pm1$1 (AT) forums (DOT) macromedia.com...
From what I understand Access does pretty well as long as the only
person
accessing it is the owner doing updates with an html back end. Once you
start
getting multiple people accessing the db at the same time (like many
people
submitting ads at the same time to the db) is when access can't handle
it.
It
is designed as a desktop db for single user access. That's what I use
MS
Access for.

It's easy to learn using DW & Access so you might want to just use it
as
a
stepping stone and learn php & MySql.

Good luck.








Reply With Quote
  #16  
Old   
Les Matthews
 
Posts: n/a

Default Re: Using DW for ASP - 07-22-2004 , 12:01 PM



I would only recommend that you use oledb jet connections.

"Durwood Edwards" <durwoode (AT) NOSPAMbellsouth (DOT) net> wrote

Quote:
We're surprised if any database available on line gets more than a dozen
hits per day. Nothing of what we are doing requires us to reach for the
Oracle.
I haven't seen activity cited as a possible culprit for the error we are
getting. It is a memory leak thing and remains a mystery and irritant.

D

"Murray *TMM*" <forums (AT) HAHAgreat-web-sights (DOT) com> wrote in message
news:cdoh05$r6s$1 (AT) forums (DOT) macromedia.com...
Access can handle more than that, but it doesn't scale gracefully. I
believe that the magic number is in the range of 5-10 hits on the same
record at the same time. If you are expecting that much activity, then
you
will need to use SQL technology.

--
Murray --- ICQ 71997575
Team Macromedia Volunteer for Dreamweaver
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================

"Leesa" <webforumsuser (AT) macromedia (DOT) com> wrote in message
news:cdog13$pm1$1 (AT) forums (DOT) macromedia.com...
From what I understand Access does pretty well as long as the only
person
accessing it is the owner doing updates with an html back end. Once
you
start
getting multiple people accessing the db at the same time (like many
people
submitting ads at the same time to the db) is when access can't handle
it.
It
is designed as a desktop db for single user access. That's what I use
MS
Access for.

It's easy to learn using DW & Access so you might want to just use it
as
a
stepping stone and learn php & MySql.

Good luck.










Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.