[freetds] long way to WCHAR...

Royce Smallbone royce.smallbone at laneend.net
Thu Oct 30 11:19:43 EDT 2008


On Thursday 30 October 2008 14:43:00 Frediano Ziglio wrote:
> > Thanks Freddy, I can now use more of the program I am
> > developing with Qt on Linux using your driver.
> >
> > I know it is early days for WCHAR support, but my prepared
> > queries now run.
> >
> > However I do get a problem when multiple queries are running
> > at the same time.
> > The data gets mixed up between the queries when populating my
> > tables. If I run the queries sequentially one after the other
> > completes I do not get this problem.
> >
> > If you need me to do any debugging for you just ask.
> >
> > Thanks for your hard work,
> > Royce
>
> Mmm... do multiple queries means multiple connections with different
> threads, multiple connections with the same thread or many queries on a
> single connection ?
> Currently only SQLPutData and Sybase has problems... how do you populate
> these tables?
> Enabling ODBC tracing would help us.
>
> Thanks for testing,
>   Frediano Ziglio

Hi Freddy,

I have sent you a gzip of the odbc trace privately so as not to annoy any list 
users with attachments.


To start with I re-read my post and noticed I used confusing terminology.

"The data gets mixed up between the queries when populating my tables."

Should of read.

"The data gets mixed up between the queries when displaying my data in my 
program."


I use threads to run the queries that display and format the data in my 
program. This is so long running queries do not block the interface.

So as far as I can tell, I have one connection being used by multiple threads 
at the same time running queries.

Royce




More information about the FreeTDS mailing list