[freetds] FreeTDS & PreparedStatements

Bhagya Prasad bhprasad at gmail.com
Fri Jul 27 12:54:56 EDT 2007


Hi ,
Thanks for the response.  I am using libodbc++.  But, these are not
concurrent queries and they are one after another.  The second query
is done after finishing the first query.
BP

On 7/27/07, ZIGLIO, Frediano, VF-IT <Frediano.Ziglio at vodafone.com> wrote:
> >
> > 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
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>


More information about the FreeTDS mailing list