RE: How to setting timeout in DBD::ODBC

Thanks for reply. (B (BI'v tried but my script selecting the record in update (Bis not ending from "fetchrow_arrayref" in more than 20 minutes. (B (BOur SQL Server is set as 600 sedonds, not 0 (infinite). (B (BIt display result just after updater's end. (B (BRegards, (BHirosi Taguti

Re: DBI and Oracle 9.2

Hello Robert, have you tried to specify NLS_LANG ? I thing it is needed too? Are you using sqlplus as the same user or wwwrun? Can wwwrun read and execute the files in OraHome1? Thursday, September 16, 2004, 3:45:37 PM, you wrote: R I have upgraded Oracle from 8.1.7 to 9.2, after changing to

RFC: scope of database routines / stored procedures

I am thinking of making a significant design change to my SQL::SyntaxModel / Rosetta modules within the next week or so, but I am debating whether it would be an improvement or a step backwards. This change would be mostly to data, rather than code, because the modules are heavily data-driven.

RE: Issue with DBD::ADO and fetchall_hashref/column_info

From: Steffen Goeldner [EMAIL PROTECTED] Sent: Friday, 17 September 2004 12:07 AM Hampson, Paul wrote: Trying to call fetchall_hashref against a statement handle from an DBD::ADO connection, I get a whole bunch of: Attempt to free unreferenced scalar: SV 0x1c97bf0 at

RE: :ADO, fetchall_hashref - ok with DBI::PurePerl but not DBI :-(

From: Jeff Zucker [EMAIL PROTECTED] Sent: Friday, 17 September 2004 1:03 AM Subject: DBD::ADO, fetchall_hashref - ok with DBI::PurePerl but not DBI :-( Hampson, Paul wrote: Trying to call fetchall_hashref against a statement handle from an DBD::ADO connection, I get a whole bunch of:

Re: DBI and Oracle 9.2

Rebuild DBD::Oracle. Tim. On Thu, Sep 16, 2004 at 07:45:37AM -0700, Robert wrote: I have upgraded Oracle from 8.1.7 to 9.2, after changing to the new Oracle environment when I run the cgi script which always used to work in Oracle 8.1.7 to Oracle 9.2 is giving the following error.

Re: Sourceforge Project Name?

On Thu, Sep 16, 2004 at 01:36:05PM -0700, Jeff Zucker wrote: As the number of DBI related modules I maintain has grown (currently over a dozen), I have noticed two things: my reach has exceeded my grasp :-) and I want/need a community of people helping develop/maintain the modules. I

Re: [Poop-group] RFC: scope of database routines / stored procedures

Darren, and anyone replying, please don't cross-post to [EMAIL PROTECTED] with topics not directly related to the DBI or drivers. Thnaks. Tim.

Re: MySQL INSERT problem...

I know you said the problem column is an enum column, but can you copy and paste in a describe of the table in question(acct_hist)? I've never used an enum column so I'm not sure I'll be any help, but a describe might help jog someones memory. Hardy Merrill NIPP, SCOTT V (SBCSI) [EMAIL

Re: DBI and Oracle 9.2

Just in case you didn't get the meaning behind Tim's comment, if you upgrade your version of Oracle, you then always need to rebuild DBD::Oracle. DBD::Oracle needs to be built _after_ installing any version of Oracle. Tim Bunce [EMAIL PROTECTED] 09/17/04 06:21AM Rebuild DBD::Oracle. Tim. On

Re: :ADO, fetchall_hashref - ok with DBI::PurePerl but not DBI :-(

Hampson, Paul wrote: From: Jeff Zucker [EMAIL PROTECTED] [DBD::ADO with DBI::Pureperl doesn't exhibit the same bugs as with DBI] Ah, this fixed _both_ problems. ^_^ The output's the same, too. So I'm well satisfied. And I don't obvserve any speed difference, but that'd be because I'm running

RE: How to setting timeout in DBD::ODBC

Thanks for reply. I'v tried but my script selecting the record in update is not ending from fetchrow_arrayref in more than 20 minutes. Our SQL Server is set as 600 sedonds, not 0 (infinite). It display result just after updater's end. The default timeout in ODBC is 0, infinite. I have

RE: :ODBC problem with backups

I've got a script I use for backing up MS-SQL databases via DBD::ODBC on Windows. It was working fine with ActivePerl 5.6.1 (build 633), DBI 1.30 and DBD::ODBC 0.43, but when I upgraded to ActivePerl 5.8.4 (build 810), DBI 1.42 and DBD::ODBC 1.09, it's not working correctly. What

Parsing

Hello I have to replace any comma (,) between quotation marks () only, with a ~ For example ABC, 123, 456, DE,F, 789 ... should be ABC, 123, 456, DE~F, 789 ... This way I can use the comma as a field delimiter for parsing purposes in order to insert the various fields into the database Any

Re: Parsing

Erich Singer wrote: I have to replace any comma (,) between quotation marks () only, with a ~ For example This way I can use the comma as a field delimiter for parsing purposes in order to insert the various fields into the database That is a bad way to parse Comma Separated Values (CSV). A