Details of a failed DBI install.

2002-04-17 Thread Justin B.
Hello, Please let me know what I am doing wrong. Here is the requested info for your review of my install. [root DBI-1.19]# perl Makefile.PL *** Note: The optional PlRPC-modules (RPC::PlServer etc) are not installed. If you want to use the DBD::Proxy driver and DBI::ProxyServer

FW: Details of a failed DBI::DBD install using CPAN

2002-04-17 Thread Justin B.
Hello Below is the output I get from an attempt to install DBI::DBD. What can I do to get it installed? Thanks in advance. Justin Running install for module DBI::DBD Running make for T/TI/TIMB/DBI-1.21.tar.gz Is already unwrapped into directory /root/.cpan/build/DBI-1.21 Has already been

Re: Connecting MS SQL 2000 w/ DBD::ODBC

2002-04-17 Thread Stefan Mueller
Orlando Andico wrote: hmm. limitation of TDS? back in the day when i was playing with Sybase, it turned out that Sybase couldn't handle multiple executing queries on a single connection. I don't use TDS. I use DirectTechnologies ODBC driver. the workaround implemented by DBD::Sybase was to

problem in install DBI in solaris 2.8

2002-04-17 Thread aulloa
Hi: I have the next Problem when i do make: ( i have GCC in the system) /usr/ccs/bin/make mkdir blib mkdir blib/lib mkdir blib/arch mkdir blib/arch/auto mkdir blib/arch/auto/DBI mkdir blib/lib/auto mkdir blib/lib/auto/DBI mkdir blib/man1 mkdir blib/man3 cp

RE: problem in install DBI in solaris 2.8

2002-04-17 Thread Sterin, Ilya
xmlproj.dyndns.org/cgi-bin/fom Ilya -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 4/17/02 11:18 AM Subject: problem in install DBI in solaris 2.8 Hi: I have the next Problem when i do make: ( i have GCC in the system) /usr/ccs/bin/make mkdir blib

RE: problem in install DBI in solaris 2.8

2002-04-17 Thread Condle, Joseph P
It is looking for the cc compiler which you do not have. If you are using the Perl installed by Solaris 8 it is compiled with cc. You can not compile DBI with gcc. You either have to recompile perl with gcc and then DBI. Or compile DBI with cc. I suggest if you do not have cc to redue the

What's the best book for learning DBI and DBD::Oracle?

2002-04-17 Thread Adriano
Hi, Please, I need to get a list of good books about Perl, that covers topics about the use of Oracle with scripts Perl. Topics like DBI, DBD::Oracle, of course. I need to make the following: install Perl and a web-server in one PC and make the scripts communicate with a Database in another,

Re: What's the best book for learning DBI and DBD::Oracle?

2002-04-17 Thread Steven Lembark
What about this one: Programming the Perl DBI (O'Reilly - by Alligator Descartes, Tim Bunce)? Did someone read it? Is it a good book? This is certianly the best place to start. The 'eagle' (mod_perl) book is another good thing to deal with. -- Steven Lembark

Re: problem in install DBI in solaris 2.8

2002-04-17 Thread Michael A Chase
From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 17, 2002 10:18 Subject: problem in install DBI in solaris 2.8 I have the next Problem when i do make: ( i have GCC in the system) /usr/ccs/bin/make . . . cc -c -xO3 -xdepend -DVERSION=\1.20\

Re: What's the best book for learning DBI and DBD::Oracle?

2002-04-17 Thread Michael A Chase
From: Adriano [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 17, 2002 11:11 Subject: What's the best book for learning DBI and DBD::Oracle? What about this one: Programming the Perl DBI (O'Reilly - by Alligator Descartes, Tim Bunce)? Did someone read it? Is it a good book? Yes.

Re: What's the best book for learning DBI and DBD::Oracle?

2002-04-17 Thread Steven Lembark
What about this one: Programming the Perl DBI (O'Reilly - by Alligator Descartes, Tim Bunce)? Did someone read it? Is it a good book? Yes. Yes. Yes. DBI FAQ. dbi-users mail archive also answers quite a few questions. The DBI and DBD::Oracle POD are also useful (hey: documentation that

Peristent Connection with Perl::DBI

2002-04-17 Thread Vaibhav Kumar
Hi I am trying to figure out whether we can create persistence database connection without using Apache::DBI and mod_perl. If Yes then how and how are we going to maintain handles to all those database connections. regards vaibhav

RE: What's the best book for learning DBI and DBD::Oracle?

2002-04-17 Thread Matthew Ramadanovic
I'll bet at least one person on this group has a copy of this book :-) When I was REALLY unfamiliar with DBI I found the FAQ, usenet, and this group to be the most useful (in that order). Tim's book initially seemed to me was like an explanation about how the rocketship was built rather than

RE: What's the best book for learning DBI and DBD::Oracle?

2002-04-17 Thread Simon Fan
How can I access the FAQ and usenet that you mentioned? Simon -Original Message- From: Matthew Ramadanovic [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 3:26 PM To: '[EMAIL PROTECTED]' Cc: [EMAIL PROTECTED] Subject: RE: What's the best book for learning DBI and DBD::Oracle?

report formatting

2002-04-17 Thread Ian Harisay
Can anyone point me in the right direction for writing somewhat complex reports. Something akin to the report writing capabilities of sqlplus. Thanks, Ian

RE: report formatting

2002-04-17 Thread Shao, Chunning
You can not do it in DBI. Use $sql = SELECT * from dual;; open ORA, | /opt/oracle/product/8.1.7/bin/sqlplus -s $name/$passwd or die Can't pipe to sqlplus: $!; print ORA set pagesize 0 linesize 120 termout off\n; print ORA set feedback off\n;

Re: report formatting

2002-04-17 Thread Michael A Chase
From: Ian Harisay [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 17, 2002 13:22 Subject: report formatting Can anyone point me in the right direction for writing somewhat complex reports. Something akin to the report writing capabilities of sqlplus. I'd suggest talking to

Re: report formatting

2002-04-17 Thread Michael A Chase
DBI is just part of the Perl environment. Once the data has been selected, it can be formatted any way you want. -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html Give a hobbit a fish and he eats

Troubles on HP-UX with DBD:Oracle

2002-04-17 Thread Howard, Chris
Hi, Thanks for your time in looking this over. I currently have DBI, DBD:Oracle running fine talking to my 7.3.4 databases. This is on an HP-UX 11.0 platform. But, as everyone knows, 7.3.4 is ancient history and the move is on toward 8.1.7 (we tend to lag behind the times). I installed an

RE: What's the best book for learning DBI and DBD::Oracle?

2002-04-17 Thread Sterin, Ilya
Programming the Perl DBI by Tim:-) Also look for an upcomming O'Reilly title on your topic:-) (hint, hint) Ilya -Original Message- From: Matthew Ramadanovic To: '[EMAIL PROTECTED]' Cc: [EMAIL PROTECTED] Sent: 4/17/02 1:26 PM Subject: RE: What's the best book for learning DBI and

RE: problem in install DBI in solaris 2.8

2002-04-17 Thread David N Murray
Also, you may want to remove/rename the /usr/ucb/cc file and make sure gcc is in your path. I ran into this when trying my first compile of any GNU tools. Sun `thoughtfully' installs a `cc' command that says that C isn't installed. Get rid of it if you are only using GCC. Dave On Apr 17,

Re: What's the best book for learning DBI and DBD::Oracle?

2002-04-17 Thread Ilya Martynov
On Wed, 17 Apr 2002 15:44:06 -0400, Simon Fan [EMAIL PROTECTED] said: SF How can I access the FAQ http://search.cpan.org/search?dist=DBI-FAQ SF and usenet that you mentioned? http://groups.google.com -- Ilya Martynov (http://martynov.org/)

Re: Trouble binding fields with spaces in Oracle OCI

2002-04-17 Thread Tim Bunce
On Wed, Apr 17, 2002 at 02:07:36PM +0100, Gaul, Ken wrote: If you are calling bind_param you don't need to call execute with parameters this will rebind using the defaults. take out @cdr of the execute line and see if that works. It shouldn't matter. Using $dbh-trace(...) would yield more

Re: report formatting

2002-04-17 Thread David N Murray
If I remember my Perl history correctly, report formatting was one of Larry's motivations for writing Perl. I'm not being facetious when I say use Perl to format reports. Any decent Perl book (like the one with the Camel on it, Chapter 2 in my copy) will show you how to write reports. Use DBI

Help: Translation to DBD:Proxy

2002-04-17 Thread Chuck Tomasi
I'm currently using Perl 5.6.0 on a Sun with DBD::Oracle using the following: sub DBConnect { my ($o_dbh);

Re: report formatting

2002-04-17 Thread Ian Harisay
tab delimited is common. I do that all the time too. I'm loking for a pretty (for execs, not analysts) printed format that can be emailed or sent to a printer. ian Michael A Chase wrote: From: Ian Harisay [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 17, 2002 13:22

Re: report formatting

2002-04-17 Thread Ian Harisay
I can see how this could work. Thanks for the direction. I'll explore it. Chunning wrote: You can not do it in DBI. Use $sql = SELECT * from dual;; open ORA, | /opt/oracle/product/8.1.7/bin/sqlplus -s $name/$passwd or die Can't pipe to sqlplus: $!;

problem in install DBI in solaris 2.8

2002-04-17 Thread aulloa
Hi: Now, i have problems for install DBD-Oracle-1.12, can help me? Here is the LOG: # perl Makefile.PL Using DBI 1.20 installed in /usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI Configuring DBD::Oracle ... Remember to actually *READ* the README file! Especially if

Re: report formatting

2002-04-17 Thread Thomas A. Lowery
Well, it's not officially released, but there is a module with DBI::Shell called DBI::Shell::SQLMinus and DBI::Format::SQLMinus. It contains the basic sqlplus style syntax for reporting. The biggest advantage is the formatting syntax is the same across any database DBI connects with (using