FreeTDS Development Group

[Francis Smit <francis AT kbd.com.au>]

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
>
> Hello...
>
> 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
                                                      `oO
Francis Smit


Knowledge By Design
Suite 201, 683 George st
Sydney 2000 NSW
http://www.kbd.com.au

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?