Skip to Content.
Sympa Menu

freetds - Re: [freetds] osql and isql -- how to test ODBC config?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] osql and isql -- how to test ODBC config?
  • Date: Wed, 26 Sep 2012 09:16:22 +0100

2012/9/20 James K. Lowden <jklowden AT freetds.org>:
> On Wed, 19 Sep 2012 16:39:22 +0000
> Tony Esposito <Tony.Esposito AT region10.org> wrote:
>
... omissis ...
>
> Then we come to the SQL. DB-Library and CT-Library (and tsql) simply
> accept the SQL from the application and squirt it out the wire. ODBC
> can't be so simple: it constructs a stored procedure
>
> 0010 74 72 32 38 36 30 30 30-34 00 63 72 65 61 74 65 |tr286000 4.create|
> 0020 20 70 72 6f 63 20 69 6f-74 72 32 38 36 30 30 30 | proc io tr286000|
> 0030 20 61 73 20 73 65 6c 65-63 74 20 2a 20 66 72 6f | as sele ct * fro|
> 0040 6d 20 73 72 5f 73 74 75-5f 64 65 6d 6f 0a |m sr_stu _demo.|
>
> What comes back looks right
>
> net.c:609:Received packet
> 0000 04 01 00 21 00 00 00 00-e7 0d 00 20 00 0a 69 6f |...!.... ... ..io|
> 0010 74 72 32 38 36 30 30 30-fd 00 00 01 00 00 00 00 |tr286000 ........|
> 0020 00 - |.|
>
> token.c:555:processing result tokens. marker is e7(TDS5_DYNAMIC)
> token.c:555:processing result tokens. marker is fd(DONE)
>
... omissis ...

We discovered and tested the fix with Tony (I went off list cause I
sent some snapshot on mail).

See change at
http://gitorious.org/freetds/freetds/commit/c54b7c8499c6d059d5c14c269259f82a592b52b0
(for 0.91 branch, code for 0.92 is different cause capability changed)

Mainly we didn't support DYNPROC capability that fine not requesting
for this feature but handling like this feature was agreed with the
server. I tested with my Sybase test server and no regressions
occurred. Tony tested with his Sybase SQL Anywhere 10 and now it works
correctly (actually he tested version in 0.92, hope backport works
too)

Frediano




Archive powered by MHonArc 2.6.24.

Top of Page