RE: unable to write from a select into outfile

2009-05-15 Thread Stricker, Scott E (IS)
t.com] Sent: Friday, May 15, 2009 1:02 PM To: Stricker, Scott E (IS) Cc: dbi-users@perl.org Subject: Re: unable to write from a select into outfile -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stricker, Scott E (IS) wrote: > All: > > I'm running on a windows XP box wit

Re: unable to write from a select into outfile

2009-05-15 Thread Martin Evans
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stricker, Scott E (IS) wrote: > All: > > I'm running on a windows XP box with latest MS updates, > ActiveState perl (v5.10.0 built for MSWin32-x86-multi-thread) > DBI (1.607) > DBD-ODBC (1.21) > SQL Server 2005 (SP3) > > Seems like all of a sudden q

RE: unable to write from a select into outfile

2009-05-15 Thread Stricker, Scott E (IS)
All: I'm running on a windows XP box with latest MS updates, ActiveState perl (v5.10.0 built for MSWin32-x86-multi-thread) DBI (1.607) DBD-ODBC (1.21) SQL Server 2005 (SP3) Seems like all of a sudden queries against my database are not returning the correct data. First noticed when executing a

Re: unable to write from a select into outfile

2009-05-13 Thread Peter J. Holzer
On 2009-05-13 08:14:09 -0700, Bruce Ferrell wrote: > Alexander Foken wrote: > > On 13.05.2009 02:59, Brian Manning wrote: > >> > >>> Can you tell me why I'm getting this error: > >>> > >>> DBD::mysql::st execute failed: Can't create/write to file > >>> '/tmp/result.csv' (Errcode: 2) > >>> [...

Re: unable to write from a select into outfile

2009-05-13 Thread listmail
Bruce Ferrell wrote: Alexander Foken wrote: On 13.05.2009 02:59, Brian Manning wrote: Can you tell me why I'm getting this error: DBD::mysql::st execute failed: Can't create/write to file '/tmp/result.csv' (Errcode: 2) You don't have create/write permissions to the /tmp

Re: unable to write from a select into outfile

2009-05-13 Thread Bruce Ferrell
Alexander Foken wrote: > On 13.05.2009 02:59, Brian Manning wrote: >> >>> Can you tell me why I'm getting this error: >>> >>> DBD::mysql::st execute failed: Can't create/write to file >>> '/tmp/result.csv' (Errcode: 2) >>> >> >> You don't have create/write permissions to the /tmp directory on

Re: unable to write from a select into outfile

2009-05-13 Thread Alexander Foken
On 13.05.2009 02:59, Brian Manning wrote: Can you tell me why I'm getting this error: DBD::mysql::st execute failed: Can't create/write to file '/tmp/result.csv' (Errcode: 2) You don't have create/write permissions to the /tmp directory on your remote host as whatever user your remote h

Re: unable to write from a select into outfile

2009-05-12 Thread Brian Manning
On Tue, May 12, 2009 at 5:40 PM, Bruce Ferrell wrote: > Given the following code: > > $sql="SELECT convert_tz( a.stamp,'GMT','$tz' ) as ts, a.status, >             a.reason, a.tl >      INTO OUTFILE  '/tmp/result.csv' > Can you tell me why I'm getting this error: > > DBD::mysql::st execute failed