freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] Using SQLExecDirect("begin transaction")

From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] Using SQLExecDirect("begin transaction")
Date: Thu, 13 Dec 2007 16:58:03 +0100

>
> $ cat /etc/odbc.ini
>
> [msvtest1_cobra]
> Driver = /opt3/dbs/tds/0.64/lib/libtdsodbc.so
> Description = msvtest1 database on cobra
> Trace = No
> Server = cobra
> Database = msvtest1
> Port = 1680
> TDS_Version = 8.0 <-------- latest TDS version...
>
> Seb
>

Mmmm... I think you are using a recent version :)
Two problem can raise:
- statement is in an invalid state. Close cursor, at least till we
support fully prepared cursors (as we just discover!)
- result is SQL_NO_DATA and you handle this case like a SQL_ERROR (ODBC
3 specify that a call to SQLExecDirect that do not output/process rows
should return SQL_NO_DATA but many application do not like this
behavior)

freddy77

[freetds] Using SQLExecDirect("begin transaction"), Sebastien FLAESCH, 12/13/2007
- [freetds] Using SQLExecDirect("set transaction isolation level ..."), Sebastien FLAESCH, 12/13/2007
- Re: [freetds] Using SQLExecDirect("begin transaction"), ZIGLIO, Frediano, VF-IT, 12/13/2007
  - Re: [freetds] Using SQLExecDirect("begin transaction"), Sebastien FLAESCH, 12/13/2007
    - Re: [freetds] Using SQLExecDirect("begin transaction"), ZIGLIO, Frediano, VF-IT, 12/13/2007
      - Re: [freetds] Using SQLExecDirect("begin transaction"), Sebastien FLAESCH, 12/17/2007