Sparklebug — Mon, 18 Feb 2002 22:45:05 +0000

Okay ... the error is either at line 66 or line 144 - both lines of code query the database as follows:

rsTimeFormat.Open strSQL, strCon

The table being queried, as you might guess, is where the formatting preferences for the date and time are kept.

I'm at work today (boo!) and have put 'on error resume next' before both of those lines. Now all of that thread shows up but from the point where the error message was appearing the date and times have returned to default formatting (dates in US order and not in full text - ie. 02/13/2002 rather than 13 February 2002 as I have my preferences set).

I'm more than happy to have the thread showing regardless of how the date appears. But if anyone is able to shed some light as to why the error might be occurring and how I can fix it I'd be mucho grateful.

Thanks again.

Bug

PS. Not hosting on CFM Resources - we use Webcentral in Sydney, Australia who everyone keeps telling me are very good ...

openmind — Mon, 18 Feb 2002 19:13:21 +0000

R U hosting on cfm-resources.com by any chance? If so, there's your problem!

Peter J. Boettcher — Mon, 18 Feb 2002 13:47:59 +0000

Yeah, it would help to see your code. If it's always happening in the same spot then I don't think its a client connection limitation, unless you're doing something funny with connections or something.

Abhishek Reddy — Mon, 18 Feb 2002 07:02:02 +0000

Quote:
Someone has told me this could be because of a slow DNS connection and said perhaps we should get a DNS-less connection ... Does this sound right and, if so, what does it mean and how do I sort it out??

Just checking, do you mean DSN or DNS?

Your error might be generated by an infinite loop (usually that comes up as some sort of "out of bounds" error but still...), or since its a long thread your process mught just be crashing. I'm not too sure...

BTW, whats your code on line 144 like? It might help to know that.

Sparklebug — Mon, 18 Feb 2002 04:14:39 +0000

Yep - always in the same spot. And only started appearing a day or so ago - was fine before that.

I've not been able to do an 'on error resume next' where the error is appearing in the code because I'm not at work today and don't have access to the files. Will try that tomorrow.

I know Access isn't ideal, but we need to use it at the moment. Also the forum really doesn't get much traffic at all - about 50 members and a very small group of regular posters within that.

Bug

Mark Hensler — Mon, 18 Feb 2002 04:10:49 +0000

I'm not an ASP guy, so this probably won't be of any help. But..

I've heard that Access isn't very desirable, especially for high traffic sites.

Is the error always at the same spot?