francis at kbd.com.au
Tue Sep 12 20:39:16 EDT 2000
Michael Kimsal wrote:
> Francis Smit wrote:
> > Michael Kimsal wrote:
> > > Hello all. :)
> > >
> > > I'm having a devil of a time tracking this one down - I hope someone has
> > > some knowledge here that can fix this.
> > >
> > > Situation:
> > > We've been developing a web app for a couple months. We're using PHP4
> > > with the latest freetds and MSSQL7 (sp1). Things were pretty fine up until about a
> > > week ago. *something's* changed, but I don't know what. We are
> > > now *often* having a page come back 'document contained no data' or the
> > > IE equivalent. By often I mean perhaps every 50 requests or so. This NEVER used to
> > > happen - we wouldn't have pressed forward with this if it did.
> > >
> > You haven't started to replicate the DB have you (or at least Publish
> > some tables), if so then make sure your not trying to grab the rowguid column
> Not sure what you meant by that - the DB is 'replicated' to the extent that we've
> moved all the data from the test area to the 'final' destination. But all
> this was done weeks ago, well before we had any problem. Any insights?
No not really, I meant replicated as in the MS thing between servers etc, clearly thats
not it, the only thing I can think of is that there's some field type that freeTDS cannot
cope with, that really why it didn't handle rowguid's when I had probs, try looking at
the error logs, do a tail on /var/log/httpd/error_log i.e:
tail -f /var/log/httpd/error_log
(at least thats where it is on my system), there are more logging and debugging
feature which can be switched on ask the group, I haven't used them all.
Grizzly . oo
Knowledge By Design
Suite 201, 683 George st
Sydney 2000 NSW
mailto:francis at kbd.com.au
Mob +61416 008 977
Tel: +61 2 9212 1399
Fax: +61 2 9212 5727
m$: How can we stuff you up today?
How about an annoying paper clip?
More information about the FreeTDS