Parse Excel repeats columns

2006-04-11 Thread Mary Anderson
Hi All, I have picked up ParseExcel and started to work with it. I am having a problem with code that essentially looks like this: for ($iR = 0; ($oWkS-{MaxRows} $iR =$oWkS-{MaxRows}, $iR++){ for ($iC=0; ($oWkS-{MaxCols} $iC =$oWkS-{MaxRows}, $iC++){ $oWkC =

Re: Parse Excel repeats columns

2006-04-11 Thread Steffen Goeldner
Mary Anderson wrote: Hi All, I have picked up ParseExcel and started to work with it. I am having a problem with code that essentially looks like this: for ($iR = 0; ($oWkS-{MaxRows} $iR =$oWkS-{MaxRows}, $iR++){ for ($iC=0; ($oWkS-{MaxCols} $iC =$oWkS-{MaxRows},

DBD:Oracle

2006-04-11 Thread Maniace Libi - lmania
I have a developer who wants DBD::ORACLE installed on a Solaris server. There is not an instance of Oracle installed on this server. He is certain that it can be installed, but I can't find information supporting this. It always errors out with wanting Oracle_home. Is there a way to install DBD

insertion through dbi

2006-04-11 Thread Baserdem, Mehmet
Hi all, I am trying to insert 16K records into some table through DBI. But my script only inserts the last record. I check the array size and the sql return values. Everything seems normal. Any ideas? Regards, Mehmet Baserdem Here is the my script: #!/usr/bin/perl use DBI; use

RE: Oracle

2006-04-11 Thread Garrett, Philip \(MAN-Corporate\)
No, DBD::Oracle requires the Oracle client libraries to be installed. There are other options, though, depending on your requirements: * DBD::Proxy - requires another system that DOES have DBD::Oracle (or, you could proxy through a Windows server that has an ADO driver for Oracle) *

Re: insertion through dbi

2006-04-11 Thread Tom Schindl
Baserdem, Mehmet wrote: Hi all, I am trying to insert 16K records into some table through DBI. But my script only inserts the last record. I check the array size and the sql return values. Everything seems normal. Any ideas? Regards, Mehmet Baserdem Here is the my script:

Re: DBD:Oracle

2006-04-11 Thread John Scoles
You do not need an Oracle Database installed. However, you at least need an Oracle client installed on the same box. This is the Oracle_home that DBD:Oracle wants. Cheers John Scoles *** The information contained in this

RE: insertion through dbi

2006-04-11 Thread Baserdem, Mehmet
Hi all, I guess I found the source of the problem. The new line chars at the end was preventing the insertion at middle rows. Below code works fine. Regards, Mehmet Baserdem #!/usr/bin/perl use DBI; use DBD::DB2::Constants; use DBD::DB2; @IDS =(); # open file open(FILE, data.txt)

Re: DBD:Oracle

2006-04-11 Thread Scott T. Hildreth
On Tue, 2006-04-11 at 11:09 -0500, Maniace Libi - lmania wrote: I have a developer who wants DBD::ORACLE installed on a Solaris server. There is not an instance of Oracle installed on this server. He is certain that it can be installed, but I can't find information supporting this. It

RE: Oracle

2006-04-11 Thread Ron Savage
On Tue, 11 Apr 2006 12:58:23 -0400, Garrett, Philip \(MAN-Corporate\) wrote: HI Philip * DBD::Proxy - requires another system that DOES have DBD::Oracle (or, you could proxy through a Windows server that has an ADO driver for Oracle) I've never heard of an ADO driver for Oracle. What's the

Re: Oracle

2006-04-11 Thread Tim Gorman
Called Oracle OLE DB (http://www.oracle.com/technology/tech/windows/ole_db/index.html), I think... on 4/11/06 5:02 PM, Ron Savage at [EMAIL PROTECTED] wrote: On Tue, 11 Apr 2006 12:58:23 -0400, Garrett, Philip \(MAN-Corporate\) wrote: HI Philip * DBD::Proxy - requires another system that

Running DBI, ODBC in the crontab

2006-04-11 Thread Stephen . Chung
Title: Running DBI, ODBC in the crontab Hi, I am running a perl script, using DBI and ODBC (from DataDirect), on a linux box to connect to SQL server. It works fine if I run it from a shell command line. However, if I put it into a crontab (the same user), I got the following error:

Re: problem DBD-Oracle-1.17 linux enterprise AS

2006-04-11 Thread Kevin Moore
Oscar, Are there errors in your alert log? The ora-600 is a generic message. It's quite possible oracle generated a trace file that may also help. Kevin Oscar Gomez wrote: i have this error when i made interface program perl with oracle 10g trough DBD module. DBD::Oracle::st execute

Re: Running DBI, ODBC in the crontab

2006-04-11 Thread Jeffrey Seger
Run the following lines in both the command line and crontab: perl -MData::Dumper -e' print Dumper @INC' ~/inc.log env|sort ~/env.log The first will have output that looks something like this: perl -MData::Dumper -e' print Dumper @INC' $VAR1 = '/usr/lib/perl5/5.8.7/i586-linux-thread-multi';