RE: Huge temp file when using myODBC 3.51 and mySQL 4.0.21 - Charles Metcalfe - com.mysql.lists.win32

2 messages in com.mysql.lists.win32RE: Huge temp file when using myODBC ...

From	Sent On	Attachments
stef...@fastwebnet.it	27 Sep 2004 06:34
Charles Metcalfe	28 Sep 2004 05:04

Subject:	RE: Huge temp file when using myODBC 3.51 and mySQL 4.0.21
From:	Charles Metcalfe (char...@kempston.co.za)
Date:	09/28/2004 05:04:27 AM
List:	com.mysql.lists.win32

Hi Stefano,

You probably have the trace option enabled in your ODBC Data Source Administrator.

Hello all,

I'm running an mySQL 4.0.21, with myODBC 3.51.

I need to connect to the DB using Crystal Reports 7, but when I run a quite

simple query on a medium size DB through Crystal reports, mySQL >creates a huge temp file (> 1 GB), and, in the end, receives the "Error 28", meaning "no left space on device".

When running the same query on the mysql query browser it works properly

and very fast, and it seems it doesn't create temp files at all.

Any suggestion will be appreciated

Thanks and regards

Stefano Bonacina

Regards

Charles