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/[email protected]