[freetds] FreeTDS & PreparedStatements

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Fri Jul 27 05:35:28 EDT 2007


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



More information about the FreeTDS mailing list