Yeah! That did it! Thanks!
Maybe that line should make it's way into my-example.cnf. AFAIK, c:\temp is
the default temp directory for NT.
Thanks again, everybody.
Leon
> -----Original Message-----
> From: Peter WR [mailto:pwr@stripped]
> Sent: Thursday, August 19, 1999 2:37 PM
> To: leon@stripped; win32@stripped
> Subject: Re: Error caused by ORDER BY clause
>
>
> 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.
> >
>
