Skip to Content.
Sympa Menu

freetds - Re: [freetds] FreeTDS & PreparedStatements

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] FreeTDS & PreparedStatements
  • Date: Fri, 27 Jul 2007 11:35:28 +0200

>
> Hi
> I have a sample application which queries MSSQL Server 2005 on CentOS
> using FreeTDS driver. The application has 2 SQL statements;
>
> sql1= select * from table_one
> sql2 = select * from table_two.
>
> When I use PreparedStatement and call executeQuery(), the first SQL
> succeeds and the second SQL fails in the stage of PreparingStatement.
>
> However, when I use createStatement and call executeQuery(stmt,sql) it
> works fine!
>
> I tested the same with PostgreSQL database with Postgres driver and it
> works great with no issues. I am seeing this only from FreeTDS.
> Anything I am missing?
>
> BP

This is a know problem. mssql support only an active connection at a
time. This means that to have 2 concurrent sql statement executing you
have to use 2 connections or cursors. I don't know which library you are
using but if you use ODBC you need CVS version to have cursors working
correctly.

freddy77





Archive powered by MHonArc 2.6.24.

Top of Page