MyODBC v5 and temporary tables
Daniel Kasak <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Organization | NUS Consulting |
| Message-ID | <[email protected]> |
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: [email protected] website: http://www.nusconsulting.com.au -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/[email protected]