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-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 queries

RE: unable to write from a select into outfile

2009-05-15 Thread Stricker, Scott E (IS)
Apologies for the email. I've got about a dozen web sites in my dev environment. Changed IIS params for one and apparently hosed up all. Fixed the params and all is well again. Found it by tracing and not connecting to the database I thought I was connecting to. Enough overlap in the DBs that

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

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 your remote host as

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 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) [...] I figured it out and

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 bferr...@baywinds.org 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