freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

RE: [freetds] SQLPrepare, SQL Execute fails on SQL 7 but works on SQL 2K

From: "ZIGLIO Frediano" <Frediano.Ziglio AT vodafone.com>
To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>, "Rogers, Tom" <tom.rogers AT ccur.com>
Cc:
Subject: RE: [freetds] SQLPrepare, SQL Execute fails on SQL 7 but works on SQL 2K
Date: Mon, 22 Sep 2003 17:24:54 +0200

>
> The calls used UnixODBC and our own "wrapper" on top of that.
> Our wrapper would throw C++ errors IF an error was
> encountered. We seem to be getting an error from the
> SQLPrepare, as you can see, but it isn't getting returned as
> an error from FreeTDS/UnixODBC. What is strange is that this
> works fine on SQL2K, but seems to throw a server-side syntax
> error under SQL 7 when calling sp_prepare. All prepared
> statements on SQL 7 fail with a syntax error, but only when
> called from FreeTDS/UnixODBC.
>
> I haven't been able to reproduce the problem with msodbc.
>

Try replacing src/tds/query.c with file attached (zipped)

freddy77

Re: [freetds] SQLPrepare, SQL Execute fails on SQL 7 but works on SQL 2K, freddyz77, 09/19/2003
- <Possible follow-up(s)>
- RE: [freetds] SQLPrepare, SQL Execute fails on SQL 7 but works on SQL 2K, ZIGLIO Frediano, 09/22/2003
- RE: [freetds] SQLPrepare, SQL Execute fails on SQL 7 but works on SQL 2K, ZIGLIO Frediano, 09/22/2003