Skip to Content.
Sympa Menu

freetds - Re: [freetds] TDS Version problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Robin Smith" <Robin AT ndigital.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] TDS Version problem
  • Date: Thu, 28 Feb 2008 14:33:59 -0500

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/ )
----------------------




Archive powered by MHonArc 2.6.24.

Top of Page