I have had the same error when using TEXT- type of fields.
I got a fix from Monty - create a ..
[mysqld]
tmpdir=c:/temp/
and now it is working.
I have included my whole email and reply below ....
*** START
>>>>> "Peter" == Peter WR <pwr@stripped> writes:
Peter> Hi,
Peter> I get below errormeassage when SELECTING a LONGTEXT field in ASP.
When
Peter> changing the field back to VARCHAR everything goes fine.
Peter> Error message ...
Peter> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Peter> [TCX][MyODBC]Can't create/write to file '\\sql7_0.ism' (Errcode: 2)
Peter> /dgh002m.asp, line 296
The above means that MySQL can't create a file at your root disk
How did you start MySQL?
Try restarting MySQL, but set the --tmpdir option to point at some
writable directory. Another option is to add to your c:\\my.cnf
file:
[mysqld]
tmpdir=c:/temp/
(assuming you have a c:\temp directory)
Regards,
Monty
*** END
----- Original Message -----
From: Leon Atkinson <leon@stripped>
To: <win32@stripped>
Sent: 19. august 1999 20:20
Subject: Error caused by ORDER BY clause
>This is with version 3.22.24-debug on Windows NT 4.0. It does it in
version
>3.22.22, too.
>
>
>mysql> select *
> -> from invoice_status x, invoice i
> -> where x.invoice = i.ID;
>{snip}
>8 rows in set (0.01 sec)
>
>
>mysql> select *
> -> from invoice_status x, invoice i
> -> where x.invoice = i.ID
> -> order by i.ID;
>ERROR 1: Can't create/write to file '\\sql127_0.ism' (Errcode: 2)
>
>C:\mysql>perror 1
>
>
>C:\mysql>
>
>
>I don't get this behavior with an identical (using mysqldump) database on
>Solaris and MySQL 3.22.21.
>
>Anyone have any ideas?
>
>TIA,
>Leon
>
>
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail win32-thread371@stripped
>
>To unsubscribe, send a message to the address shown in the
>List-Unsubscribe header of this message. If you cannot see it,
>e-mail win32-unsubscribe@stripped instead.
>
