| Author |
 Topic  |
|
Michadia
Starting Member
4 Posts |
 Posted - 07 January 2001 : 17:54:20
|
Warning I am new to asp and databases but, familiar with some basic cgi stuff, so I am slow but not totally lost.
I installed the database and had it running for several days. I was able to use it and setup forums. This morning I tried to log on and I received a Http 500 Internal Server Error when I attempted to visit http://www.homeeducationcentral.com/forum/default.asp When I tried to go setup again I got a "The database could not be opened !!
Check your config.asp file and set the
strConnString so it points to the database.
Also check if strDBType is set to the right databasetype. Code : -2147467259" http://www.homeeducationcentral.com/forum/setup.asp
When I tried the setup_login I got a "too many client tasks error"
http://www.homeeducationcentral.com/forum/setup_login.asp
The database is on the root level with the html and the path to the data base is
D:\html\users\homeeducationcentralcom\database\homeedcen2001.mdb
In the config file I made the following changes...I uncommented "strDBType = "access"" and "strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=D:\html\users\homeeducationcentralcom\database\homeedcen2001.mdb" '## MS Access 97"
From the time it was working til the time it stopped I hadn't made any changes. This happened one other time last week. It mysterious resovled itself the following day. I am assuming that it has something to do with my hosting company ReadyHosting, but I need help in knowing what could be causing the problem. I like to be prepared when I deal with tech support.
I have tried searching the forums, but I was unable to find any posts that were similar.
Thanks,
Michadia
Edited by - Michadia on 07 January 2001 17:56:22 |
|
|
heptite
Average Member
USA
547 Posts |
Posted - 07 January 2001 : 19:00:15
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Warning I am new to asp and databases but, familiar with some basic cgi stuff, so I am slow but not totally lost.
I installed the database and had it running for several days. I was able to use it and setup forums. This morning I tried to log on and I received a Http 500 Internal Server Error when I attempted to visit http://www.homeeducationcentral.com/forum/default.asp When I tried to go setup again I got a "The database could not be opened !!
Check your config.asp file and set the
strConnString so it points to the database.
Also check if strDBType is set to the right databasetype. Code : -2147467259" http://www.homeeducationcentral.com/forum/setup.asp
When I tried the setup_login I got a "too many client tasks error"
http://www.homeeducationcentral.com/forum/setup_login.asp
The database is on the root level with the html and the path to the data base is
D:\html\users\homeeducationcentralcom\database\homeedcen2001.mdb
In the config file I made the following changes...I uncommented "strDBType = "access"" and "strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=D:\html\users\homeeducationcentralcom\database\homeedcen2001.mdb" '## MS Access 97"
From the time it was working til the time it stopped I hadn't made any changes. This happened one other time last week. It mysterious resovled itself the following day. I am assuming that it has something to do with my hosting company ReadyHosting, but I need help in knowing what could be causing the problem. I like to be prepared when I deal with tech support.
I have tried searching the forums, but I was unable to find any posts that were similar.
Thanks,
Michadia
Edited by - Michadia on 07 January 2001 17:56:22
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
I have the exact same thing happening on one of my sites, but one of them is working just fine. I also use ReadyHosting.
Maybe something happened over the weekend.
Sue
|
 |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 07 January 2001 : 20:56:45
|
It sounds like server-side problems to me, particularly if you weren't changing anything around. The error could be caused by the admin doing some work, changing file or folder permissions, or if a server crashed and left orphan locking files lying around. I don't use ReadyHost so I don't know if there is anything going on there.
======
Doug G
====== |
|
|
|
Michadia
Starting Member
4 Posts |
Posted - 08 January 2001 : 04:02:00
|
I finally received a reply from ReadyHosting.
Suggested Solution:
At 01/08/2001 02:41 AM we wrote - We are struggling with database issues on that server, and have been
in constant communication with Microsoft through last week regarding
this. We hope to have the issue resolved by early this week. We sincerely apologize for the problems this is, or has caused you.
I can't wait until the phones to open for tech support this morning for my "too many clients error" here http://www.homeeducationcentral.com/forum/setup_login.asp has upgraded itself to a "Catastrophic failure". Sounds so very serious. 
I am most happy to know that it wasn't my doing.
Michadia
Edited by - michadia on 08 January 2001 04:09:40 |
|
|
|
heptite
Average Member
USA
547 Posts |
Posted - 08 January 2001 : 20:07:06
|
I called ReadyHosting and had them make my forum directory read/write so I could reference an .mdb file from in there, and volia! It worked. Try the same thing and see if it will help any. Call your database something else so no one can download it.
I prefer to have my .mdb files in a different directory anyhow.
(Or maybe they got things going ok?)
Sue |
|
|
|
Michadia
Starting Member
4 Posts |
Posted - 09 January 2001 : 05:07:58
|
Sue,
I tried as you suggested and it did work. Although, it will drive me crazy not knowing why it will work this way. But, I guess I'll learn to live with it. Thanks for the help.
Can I ask another question, what does your constring look like for this database? Am I doing this properly? "strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\html\users\homeeducationcentralcom\html\forum\homeedcen2001.mdb;" '## MS Access 2000"
Michadia
|
|
|
|
heptite
Average Member
USA
547 Posts |
Posted - 09 January 2001 : 05:44:34
|
quote:
Sue,
I tried as you suggested and it did work. Although, it will drive me crazy not knowing why it will work this way. But, I guess I'll learn to live with it. Thanks for the help.
Can I ask another question, what does your constring look like for this database? Am I doing this properly? "strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\html\users\homeeducationcentralcom\html\forum\homeedcen2001.mdb;" '## MS Access 2000"
Michadia
Your connection string looks just fine! I used:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/forum/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
I didn't rename mine anything differently like you did.
Here's the URL to mine:
http://www.typetwotracker.com/forum
Nothing really there yet!
Sue |
|
|
|
tg2000
Starting Member
USA
8 Posts |
Posted - 09 January 2001 : 19:42:15
|
Are you guys/gals still having the same problems with Readyhosting? I have been having troubles getting things working with them too. What might work one day doesn't the next. I think it is fairly clear it is on their end, which is hard to understand since ASP and related programs come with IIS so you would think a knowledgeable system admin could get things setup right.
Is the option to give your forum directory Read/Write privileges and putting the database in there working out? I had just requested from their support people to do the same thing, then discovered that apparently the others who had done this are experiencing problems again (judging by clicking on their links posted in this topic).
It's been strange, since a few other database related ASP pages I have with Readyhosting aren't having problems. And I hadn't done anything with the Forums (no posts, no backend stuff) for a few days and all of the sudden it was having all these errors.
Anyway, enough rambling. I just hope they get things resolved because I really like their offerings, and would hate to have to move my site. Great price and hard to beat the programming options.
Please post any updates as you get them...
UPDATE: As of 4:40 Pacific it looks like the forums are ok now. Maybe they finally figured things out!
Thanks!
Tom
Edited by - tg2000 on 09 January 2001 19:44:35 |
|
|
|
heptite
Average Member
USA
547 Posts |
Posted - 09 January 2001 : 19:52:05
|
quote:
Is the option to give your forum directory Read/Write privileges and putting the database in there working out? I had just requested from their support people to do the same thing, then discovered that apparently the others who had done this are experiencing problems again (judging by clicking on their links posted in this topic).
Mine is still working just fine. It's limited to one server. Moving the .mdb to the forum directory worked for me, I haven't tried moving it back over to the database directory off the main site.
Sue |
|
|
|
Bear Skarky
Starting Member
USA
29 Posts |
Posted - 11 January 2001 : 14:49:59
|
I'm also having problems with my forum on ReadyHosting at http://www.poasters.com/forum/ after upgrading to SR4. The forum doesn't show up unless users log in, no lurking possible, which defeats the purpose. After the upgrade when I run the Check Installation, I get the Upgrade Database message.
Permissions were already set for the cgi-bin, so I set up the database as
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:/html/users/poasterscom/html/cgi-bin/snitz_forums_2000.mdb;" '## MS Access 2000. Using the database included with the Snitz zip, is that the right setting?
We were having frequent errors, hence the upgrade, but now I'm wondering if I should move the .mdb file out of the cgi-bin. Would that help with the log in problem, or is there another issue here?
Any advice on the forum setup would be greatly appreciated. I'm an ASP newbie, by the way, as if there was any doubt.
|
|
|
|
Michadia
Starting Member
4 Posts |
Posted - 14 January 2001 : 16:30:15
|
Tom,
I moved my database over to the forum directory, as Sue suggested and it worked for me. But, after seeing your post I am wondering whether or not it had anything to do with moving it. You indicated that on January 9 your problem was resolved, this correspondes to when my database started to function properly. Unfortunately, the forum only worked for 5 days and now I am having problems again. Since January 9, I did not make anychanges to the database or the config. Other than checking on it each day to be certain that it was up.
How is your forum working?
Michadia
|
|
|
|
tg2000
Starting Member
USA
8 Posts |
Posted - 19 January 2001 : 01:43:07
|
quote:
Tom,
I moved my database over to the forum directory, as Sue suggested and it worked for me. But, after seeing your post I am wondering whether or not it had anything to do with moving it. You indicated that on January 9 your problem was resolved, this correspondes to when my database started to function properly. Unfortunately, the forum only worked for 5 days and now I am having problems again. Since January 9, I did not make anychanges to the database or the config. Other than checking on it each day to be certain that it was up.
How is your forum working?
Michadia
So far no problems, but I did end up going back to my previous setup of using a DSN connection and putting the database into the directory named "database".
I have not made any changes since it started working, nor have their been any postings (it's not really up for public use as of yet, given the initial problems) so I don't know if it is still ok only because nothing is going on or if maybe Readyhosting really resolved something.
Hope yours is back to normal...
Tom
|
|
|
|
Bear Skarky
Starting Member
USA
29 Posts |
Posted - 19 January 2001 : 12:06:30
|
We moved the database to the Database directory also, but it hasn't helped. Our site on Readyhosting(http://www.poasters.com) has been loading pathetically slow for over a week now. Readyhosting blames it on UUnet, but we're not paying UUnet. They have been good about offering alternatives to actually fixing the problem, including setting us up a mirror site for testing purposes and offering to move us there if we prefer, but that server isn't running much faster.
We're looking for another cheap web host, if anyone has any suggestions.
|
|
|
|
ahbao
Starting Member
9 Posts |
Posted - 13 February 2001 : 20:05:30
|
Help!. i have this problem with readyhosting today. anyone know how to solve the too many client tasks error?
thanks
|
|
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
Posted - 13 February 2001 : 20:26:53
|
I'd suggest reading the posts between your question and the statement of the problem. It gives resolution to the issue.
Reinsnitz (Mike)
><)))'>
"Blessed are those who hear the word of God and obey it." - Luke 11:28
|
|
|
|
ahbao
Starting Member
9 Posts |
Posted - 13 February 2001 : 20:45:58
|
thanks.. but seems like i have to wait the company response. no idea how to solve it..
btw, is sql server 2000 far better than access? Access has a max connection of 255, how about sql server?
|
|
|
|
Topic |
|
Topic Locked
