FreeTDS Development Group

["Robin Smith" <Robin AT ndigital.com>]

Thanks for the analysis. I have upped another set of logs (see below).
 
> There are a few differences, and IMO a minor error in odbc.c.  It looks
> like the problem stems either from differences in the query or in the 
> TDS version.  There's a mysterious error toward the end of the PHP log.  
>
> That lets us look at the real differences.  The first one is here:
> 
> --- php 2008-02-28 11:39:20.000000000 -0500
> +++ isql        2008-02-28 11:39:20.000000000 -0500
I just realized I had my freetds.conf set to version 7.0 (from when I was 
troubleshooting). Here's the isql log with it set to 8.0. Note: the TDS 
version for the PHP page is set in the odbc.ini, which I assume is overriding 
the TDS version set in freetds.conf, even though the DSN uses the Server 
definition from FreeTDS.
 
http://www.ndigital.com/tmp/freetds.isqltds8.log 
http://www.ndigital.com/tmp/sql.isqltds8.log 

> With PHP you're running TDS 8.0.  Does the problem go away if you set it
> to 7.0?  
If I set it to TDS version 7.0 for the PHP version, the page doesn't complete 
loading. It just hangs (the firefox "loading" symbol keeps rotating).
 

> I don't know what that means. I did find this, but you said you're 
> running 2000, not 7:  
> http://support.microsoft.com/kb/252865 
I looked at that error. We are running SQL 2000 SP3a (a pretty current SP, 
although SP4 is out now)

> Conclusions:
> 
> 1.  It might be something in the way TDS 8.0 is handled.  
The isql query works at TDS 8.0, so its not that. The PHP doesn't work at 7.0 
which I can't explain.
 
> 2. Your application should report errors such as 16902.  Not sure why 
> that didn't turn up before. 
 
Isn't this specific to SQL7 though?

> 3.  odbc.c shouldn't log all errors as timeout messages.  
Can't comment...
 
> I think you discovered a bug.  Sorry I couldn't spot the actual real
> problem.  Hope I got you and Frediano a little closer to its 
> resolution. 
> Thanks for the detailed problem report and for posting the logs.  
Thank you very much for the analysis. I truly appreciate it. Hopefully, I am 
nudging towards a solution.

Thanks
 
Robin
 
 
-----------------------
Robin Smith
Senior Manager, Information Technology
NDI
103 Randall Drive
Waterloo, ON, Canada N2V 1C5
Telephone: +1 (519) 884-5142 ext. 224
Toll Free: +1 (877) 634-6340
Global: ++ (800) 634-634-00
Facsimile: +1 (519) 884-5184
Website: www.ndigital.com ( http://www.ndigital.com/ )
----------------------