FreeTDS Development Group

["ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>]

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