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'; $

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 faile

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: i

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 syst

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: 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.

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

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

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) * DBD::JDBC

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 DBD::DB2

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

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-

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++){ $o