| Author |
 Topic  |
|
|
Peter C
Starting Member
United Kingdom
6 Posts |
 Posted - 21 May 2002 : 17:32:17
|
Hi,
I'm new to asp and so need someone to confirm something for me.
My ISP has been contacting website admins warning them to make sure that all databases and objects opened/created are closed/deleted after each and every use.
Since installing on Sunday (after creation of the DSN by my ISP) The forum has been unavailable for several hours with the 'Could not be opened' error message.
When I contacted them again tonight (no access) they told me that this is because of the open/close, create/delete problem. They have also told me that they would be very surprised if it was Snitz causing the problem (they use it themselves).
Could someone confirm for me that the software does close and delete as required and then I can stop worrying about my ISP withdrawing this functionality. The servers apparently run out of resource.
Thanks
Peter Clouston
United Kingdom |
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 21 May 2002 : 17:59:40
|
did you get an error stating the DB could not be opened?
Crash's Site | Crash is from 
|
 |
|
|
Peter C
Starting Member
United Kingdom
6 Posts |
Posted - 21 May 2002 : 18:18:34
|
Yes, the error message indicates that it's corrupt or not there. In actual fact it's got nothing to do with either the asp code or the database, it's the hosts server running out of resource.
Peter Clouston
United Kingdom |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Peter C
Starting Member
United Kingdom
6 Posts |
Posted - 21 May 2002 : 18:26:05
|
I should have included this before - Sorry - this is the message my Host Provider sent out as a general notice to all webmasters on their service;-
"2) ASP Database and object connections.
---------------------------------------
If you access a database or call an object in your code then this notice applies to you:
We've had more and more problems recently with objects and database connections being opened and then not closed. This can cause problems for yourself and other customers on the same server as you.
We can't stress enough how important this is. If you create an object then destroy it after use, If you create a database connection, close it after each and every use.
Please help us to provide you with a good level of service. By failing to heed the above you could cause system instability which nobody wants."
Peter Clouston
United Kingdom |
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 21 May 2002 : 18:42:29
|
quote:
Please post your connection string here.
why not try doing what ruirib asked?
Crash's Site | Crash is from
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 21 May 2002 : 18:44:28
|
Crash, how close can this get? Same second, hey? And who was way too slow this time  ?
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 21 May 2002 : 18:52:02
|
LOL! that's because i had to wait for the Flood Control timeout...
 next time Gadget, next time... *growl*
Crash's Site | Crash is from
|
|
|
|
Peter C
Starting Member
United Kingdom
6 Posts |
Posted - 21 May 2002 : 18:53:44
|
strConnString = "DSN_Name" '## DSN
There you go
Peter Clouston
United Kingdom |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 21 May 2002 : 19:04:16
|
I would strongly advise you to use an OLEDB connection string. A DSN connection uses ODBC drivers and if you do a little search in these forums will rapidly conclude that ODBC drivers seem to be behind a big number of problems like slow response and rather puzzling error situations. ODBC drivers also seem some how to be more server resource hogs than OLEDB ones.
So use of these connection strings:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("database/snitz_forums_2000.mdb")
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\database\snitz_forums_2000.mdb"
You'll need to change whatever the one you choose to use to your database file path.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
Peter C
Starting Member
United Kingdom
6 Posts |
Posted - 21 May 2002 : 19:13:41
|
I've already asked the host if I can do that as the problem is tied to the server resource available.
Both options that you suggest are not possible because of the way the supplier structures the sites. The secure database directory cannot be reached other than by a DSN.
It would appear that other topics are similar to this one. If this is true and Snitz does open/close create/destroy then I'm not part of the problem, I'm just suffering as a result of other sites doggy code.
Part of his reply went;-
"Don't get us wrong - the problem doesn't have to be down to just you, and I'd be amazed if it was Snitz" when referring to the note above.
Peter Clouston
United Kingdom |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 21 May 2002 : 19:24:35
|
In MVHO if they are worried about server resources availability doesn't make much sense to force ODBC drivers use. And the security policy doesn't get compromised if you allow read/write access to a folder that cannot be accessed from the web. If I was hosting with those guys myself, I would simply move and get another host.
Just MVHO.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
Peter C
Starting Member
United Kingdom
6 Posts |
Posted - 21 May 2002 : 19:32:33
|
If we could find the perfect supplier (maybe I'll host it on my own servers out of the office) we'd both make a fortune. Bring back cobol and rs-232 (before your time no doubt - 32bit Proc with 32 MB memory I could run 132 users).
Thanks, what you are basically confirming for me is that it's not Snitz it's the others sites who can't write decent code clogging up the server resource, and I lose part of my site. |
|
|
| |
Topic |
|
Topic Locked
