| Author |
 Topic  |
|
|
ROB
Junior Member
USA
347 Posts |
 Posted - 04 July 2002 : 00:49:45
|
I haven't changed any of the asp code recently, but this morning and all day long I've been getting a multitude of errors on my web site, particularly with the forums.
The errors are sporadic and vary. Sometimes it actually works!
For example, http://www.bigblueball.com/forums/default.asp is at this moment showing all my forum categories, but with the message "No Forums Found".
Other times I'm getting an OLE DB error "Cannot generate SSPI context." This I've researched, and it appears to be a problem with the connection to the SQL Server (hosted on another PC), but if it were as simple as that, it seems like it should consistently fail (it does not).
Another symptom, sometimes forum topics only display the original topic, with no replies (even though they are still there in the database).
HELP! I'm pulling my hair out, and there's not much left! 
Jeff Hester :: BigBlueBall.com - Everything about instant messaging
 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 04 July 2002 : 00:54:27
|
have you tried changing from the OLEDB connection string to the ODBC one?
got this error when trying the login link:
quote:
Microsoft VBScript compilation error '800a03e9'
Out of memory
/forums/login.asp, line 0
Maybe the server needs to be rebooted, something might be hung or eating up resources. |
 |
|
|
ROB
Junior Member
USA
347 Posts |
Posted - 04 July 2002 : 01:19:21
|
quote:
have you tried changing from the OLEDB connection string to the ODBC one?
Is the ODBC connection "better" than using OLEDB? I always thought OLEDB was preferable.
Jeff Hester :: BigBlueBall.com - Everything about instant messaging
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 04 July 2002 : 02:53:57
|
OLEDB is preferrable, I was just wondering if it could be that the driver is messed up on the server. Switching to the ODBC driver and seeing if you get the same problems would help rule that out.
I see that your forum is working again. What did you do to get it working? |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 04 July 2002 : 02:54:01
|
OLEDB should always be the favoured one to use, I think what Richard was trying to get at is to perhaps try it as more of a "debug" measure than a reccomendation.
www.daoc-halo.com |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 04 July 2002 : 02:54:27
|
beaten by 4 seconds ;)
www.daoc-halo.com |
|
|
|
ROB
Junior Member
USA
347 Posts |
Posted - 04 July 2002 : 09:24:10
|
Here's the frustrating thing... I did nothing!!! Grrrr... Maybe my repeated messages to my web host finally spurred them to action.
Hmmm... I just checked my support ticket and no notes from them. ****. Another inexplicable anomally. Just one of the many joys of shared hosting.
Thanks to Richard and everyone who took a moment to lend a hand.
Jeff Hester :: BigBlueBall.com - Everything about instant messaging
|
|
|
|
grazman
Junior Member
USA
193 Posts |
Posted - 04 July 2002 : 11:51:02
|
www.orcsweb.com.
I'm on shared hosting and it is a joy. Give them a try.
SQLTeam.com - For SQL Server Developers and Administrators
Snitz Info - SQL Server info on Snitz Forums |
|
|
| |
Topic |
|
Topic Locked
