Re: Newbie problem with Oracle functions

2003-02-06 Thread David Bakkers
At 03:40 06/02/03 +, you wrote: Date: Wed, 05 Feb 2003 09:19:14 +1100 To: [EMAIL PROTECTED] From: David Bakkers <[EMAIL PROTECTED]> Subject: Newbie problem with Oracle functions Many thanks to those that replied and helped me out. Steve Kell's transcript of the Database Error Messages for

RE: question: DBD::Oracle needed for DBI on another host?

2003-02-06 Thread Fong, Anna
Janet, Add an alias entry on your client's (DEC Alpha) tnsnames.ora file for the other Oracle database. Then use the new alias in your connect string. Hope this helps, Anna Anna Q. Fong, Webmaster California Data Exchange Center > --

question: DBD::Oracle needed for DBI on another host?

2003-02-06 Thread Janet Goldstein
I am running Perl 5.6.0 on a DEC Alpha. I wish to access an Oracle database located on a different machine. Do I still need to install DBD::Oracle locallly (on the machine running the script), or is DBI enough by itself? If DBD::Oracle is required, then at installation do I tell it the host's ORAC

need help!

2003-02-06 Thread Surit . Sahoo
Recently we upgraded to Oracle 9i and the DBD::Oracle-1.12 does not seem to work anymore. The CPAN documentation says, it was for Oracle 7 and 8. We've Oracle 9.2.0 Please help ?!!! regards surjit This message contains information from Equifax Inc. which may be confidential and privileged. If y

Installation problems on OS X 10.2.3

2003-02-06 Thread curtcrandall
Hi, I'm trying to install DBI 1.32 on my Jaguar system (10.2.3). I have Perl 5.8.0 installed with threading enabled... this is an upgrade from the stock Perl 5.6.0 that was on there. The installation of Perl 5.8.0 went OK, but there were 3 errors out of about 697 tests... which has me a *littl

RE: Help with DBI 1-32 install please!

2003-02-06 Thread Frans . Postma
Hi, It seems you run the tests with -T (taint, runs perl in more security aware mode) active ?? Any idea why that is ? Also your perl version seems a bit old to use the newest DBI, that is causing the test to complain about a missing HiRes module (which is standard at least in 5.8) Greetings, --

RE: Date formats from SQL using DBD::ODBC

2003-02-06 Thread Timothy Johnson
Thanks. It's really not that hard to parse out the date myself, but I wanted to shave off that extra work just to streamline things. -Original Message- From: Jeff Urlwin To: 'Timothy Johnson'; [EMAIL PROTECTED] Sent: 2/6/03 3:43 AM Subject: RE: Date formats from SQL using DBD::ODBC >

Help with DBI 1-32 install please!

2003-02-06 Thread Jonathan Hall [Dial]
Hi dbi-users, Tried to send the following e-mail to you, but got a bounce from the e-mail server. I'm therefore re-trying. Attachment is compressed using Winzip 7.0 SR-1 (1285). Regards, Jon __ Jonathan Hall +44 (0) 7 919 165 005 [cell] / +44 (

Question

2003-02-06 Thread Kowalski, Dennis M
I have compile the DBI & DBD modules on a SPARC2 SOLARIS8 host and they work fine. I also have a SPACR3 SOLARIS9 host that I need DBI & DBD on. The SPARC3 host does not have make and cc on it. Can I somehow install the compiled object from the SRARC2 host onto the SPARC3 host. If so, what woul

RE: Date formats from SQL using DBD::ODBC

2003-02-06 Thread Jeff Urlwin
> This is probably something really simple that I'm missing, > but I was wondering if there is some way to get SQL to return > a date field in the same format as Perl's time() or > localtime(). Right now I keep getting a string like this: > "1/20/2003 10:37:17 AM", which doesn't help me whe