Skip to Content.
Sympa Menu

freetds - Re: [freetds] FreeTDS & PreparedStatements

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Bhagya Prasad" <bhprasad AT gmail.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] FreeTDS & PreparedStatements
  • Date: Fri, 27 Jul 2007 09:54:56 -0700

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
>




Archive powered by MHonArc 2.6.24.

Top of Page