MyODBC v5 and temporary tables

Hi all.

I've now got the v5 driver installed, and can do simple selects, but
I've hit a fatal problem. Creating temporary tables doesn't seem to
work. I ran some code that creates 2 temporary tables, based on select
queries, and then does a 3rd query based on these 2 temporary tables
( all with the same ADODB connection ). Neither of the 2 temporary
tables are visible however, as if a new connection is being opened for
each query. Is this what's happening? How do I stop it?

I have confirmed this behaviour both inside Crossover Office and in
Windows 2000 ( in VirtualBox ).

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@nusconsulting.com.au
website: http://www.nusconsulting.com.au


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: MyODBC v5 and temporary tables

On Fri, 2007-05-25 at 10:34 +1000, Daniel Kasak wrote:

> Hi all.
>
> I've now got the v5 driver installed, and can do simple selects, but
> I've hit a fatal problem. Creating temporary tables doesn't seem to
> work. I ran some code that creates 2 temporary tables, based on select
> queries, and then does a 3rd query based on these 2 temporary tables
> ( all with the same ADODB connection ). Neither of the 2 temporary
> tables are visible however, as if a new connection is being opened for
> each query. Is this what's happening? How do I stop it?
>
> I have confirmed this behaviour both inside Crossover Office and in
> Windows 2000 ( in VirtualBox ).

No comment, eh?

I've been waiting for around 5 years for these v5 drivers ( that's what
the '5' stands for, right? ), so I suppose I can wait a couple of months
for a response.

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@nusconsulting.com.au
website: http://www.nusconsulting.com.au


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: MyODBC v5 and temporary tables

On Fri, May 25, 2007 at 10:34:12AM +1000, Daniel Kasak wrote:
> I've now got the v5 driver installed, and can do simple selects, but
> I've hit a fatal problem. Creating temporary tables doesn't seem to
> work. I ran some code that creates 2 temporary tables, based on select
> queries, and then does a 3rd query based on these 2 temporary tables
> ( all with the same ADODB connection ). Neither of the 2 temporary
> tables are visible however, as if a new connection is being opened for
> each query. Is this what's happening? How do I stop it?

Hi Daniel. Sorry for the delay.

I've looked into this, and ADO seems to be created an extra connection
for each query. The reason is that the v5 driver doesn't buffer all the
results by default so it doesn't support multiple active recordsets.

I'm working on getting this fixed, and it should be available soon.

Jess

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org