RE: DBI 1.18 Installation help

2001-09-14 Thread Wilson, Doug
> From: Wilson, Allen [mailto:[EMAIL PROTECTED]] > I have been attempting to install DBI 1.18 without any success. I was > able to run the Makefile.PL with any problems but when I tried to run > the make I received the following error... > > gcc -c -I/opt/gnu/include -O-DVERSION=\"1.18\" >

DBI 1.18 Installation help

2001-09-14 Thread Wilson, Allen
Good Evening I have been attempting to install DBI 1.18 without any success. I was able to run the Makefile.PL with any problems but when I tried to run the make I received the following error... gcc -c -I/opt/gnu/include -O-DVERSION=\"1.18\" -DXS_VERSION=\"1.18\" -fpic -I/opt/gnu/lib/p

Re: OT Perl Optimizations Was: undef & NULL

2001-09-14 Thread James D. White
I modified Peter J. Holzer's code to test both the case where the $i is set to 1 (Holzer's case) and where $i is 0 (which forces more assignments). I also added a straight assignment statement to each set. The program and results are below. This test was run three times on a Sun Ultra 5, with So

Re: [Solaris] dbi + DBD:ODBC + ?for oracle?

2001-09-14 Thread Jay Strauss
Robert Attached is a little doc I wrote-up to install all you need. You can ignore everything from Mod_Perl Prerequisites and below. But in general: 1) You need to install some oracle software on your machine, ask your DBA for a cd or go to technet.oracle.com (signup is free) and download the

Re: [Solaris] dbi + DBD:ODBC + ?for oracle?

2001-09-14 Thread Ivan Adzhubei
Robert Lopez wrote: > > I though it might be a lower cost option for putting in place some > software I will need very infrequently. Almost always always what I > need is in the Informix database. Sometimes if it is not the clues > as to why it is missing are in the Oracle database. With the OD

Re: [Solaris] dbi + DBD:ODBC + ?for oracle?

2001-09-14 Thread Robert Lopez
> From: Ivan Adzhubei <[EMAIL PROTECTED]> > Why you intend to use ODBC in the first place? It makes more sense to > install DBD::Oracle, the DBI module then can use it as a lower level > interface to DB. This is at least one layer less between your > application code and the database itself th

Re: [Solaris] dbi + DBD:ODBC + ?for oracle?

2001-09-14 Thread Ivan Adzhubei
Robert, Why you intend to use ODBC in the first place? It makes more sense to install DBD::Oracle, the DBI module then can use it as a lower level interface to DB. This is at least one layer less between your application code and the database itself than with the ODBC. To install DBD::Oracle you

dbd::db2 beginner question

2001-09-14 Thread Bill Grigg
The readme file says the following: .. Ensure one of the following DB2 products is installed. DB2 Software Developer's Kit v5.2 Included with the DB2 Application Developer's Kit DB2 Application Development Client v6 or later Included with the DB2 P

RE: [Solaris] dbi + DBD:ODBC + ?for oracle?

2001-09-14 Thread Robert Lopez
Well I went ahead and ran cpan to install ODBC::Oracle and it says... The DBD::ODBC module needs to link with an ODBC 'Driver Manager'. (The Driver Manager, in turn, needs one or more database specific ODBC drivers. The DBD::ODBC module does _not_ include any ODBC drivers!) so it is prett

RE: [Solaris] dbi + DBD:ODBC + ?for oracle?

2001-09-14 Thread Robert Lopez
> ANK > it is will probably a good idea to get familiar to with sqlplus > (database client for running sql commands) > for that you will need to have unix account unless you have oracle client > installed on your local machine. > > > ANK> As I mentioned above you don't have to have it but you'

DBI : Threads

2001-09-14 Thread James Maes
Are the DBD Modules Thread safe, DBD::Informix in particular. Thanks -- || James Maes || Senior Programmer || [EMAIL PROTECTED] || The Sporting News || www.sportingnews.com || fantasy.sportingnews.com || radio.sportingnews.com ---

RE: [Solaris] dbi + DBD:ODBC + ?for oracle?

2001-09-14 Thread Kokarski, Anton
You are correct Robert, sqlplus is just a command line kind of database client. \ in your perl code it is best to use DBD::Oracle. Regards, Anton Kokarski -Original Message- From: Robert Lopez [mailto:[EMAIL PROTECTED]] Sent: Friday, September 14, 2001 11:31 AM To: [EMAIL PROTECTED]; [E

RE: [Solaris] dbi + DBD:ODBC + ?for oracle?

2001-09-14 Thread Kokarski, Anton
-Original Message- From: Robert Lopez [mailto:[EMAIL PROTECTED]] Sent: Friday, September 14, 2001 9:09 AM To: [EMAIL PROTECTED] Subject: [Solaris] dbi + DBD:ODBC + ?for oracle? I followed the trails of "Programming the Perl DBI, Appendix B" to freeodbc to to easysoft.org...

[Solaris] dbi + DBD:ODBC + ?for oracle?

2001-09-14 Thread Robert Lopez
I followed the trails of "Programming the Perl DBI, Appendix B" to freeodbc to to easysoft.org... I read for hours history requests at dejanews I am now more confused than when I started. I have this working on my sparc Solaris ws: perl+DBI+DBD::Informix to connect to an Info

Re: Help Please

2001-09-14 Thread Srinivasa Rao Katta
Adrian, How are you ?. Thanks for the mail. As per your instructions,I have done the make clean for to clean the files. After that,I have run the following cmds on the server. perl Makefile.PL /usr/ccs/bin/make I have got the following error mesg. -- # /usr/ccs/b

RE: is it possible to execute a package.procedure from Oraperl.pm script ?

2001-09-14 Thread timothy . helck
Avi, I had the same question a few months ago, and people in the list were kind enough to give me a lot of information. Based on what I learned, I wrote the following short script which illustrates the basic features of using DBMS_OUTPUT.PUT_LINE. You must use dbh->func() which unfortunately is

Re: Fwd: failure notice

2001-09-14 Thread Ask Bjoern Hansen
On Fri, 14 Sep 2001, Gary Traffanstedt wrote: > > I just tried to join the dbi-users list and received the following > message... could someone manually add me or tell me how to correctly sign > myself up? > > : > Sorry, no mailbox here by that name. (#5.1.1)

Fwd: failure notice

2001-09-14 Thread Gary Traffanstedt
I just tried to join the dbi-users list and received the following message... could someone manually add me or tell me how to correctly sign myself up? Thanks! Gary -- Gary Traffanstedt -- GeniusWeb.com Inc. 406 8th Avenue NE Aberdeen, SD 57401 -- http://www.geniusweb.com [EMAIL PROTEC

RE: Strange error when doing insert into DB

2001-09-14 Thread Scott T. Hildreth
Can we see some code? The error is, what it states, you are mixing placeholders. i.e. $dbh->prepare(select * from foo where bar = ? and foobar = :p1); ..check the code for :"string" and :number mixture in a statement. On 14-Sep-01 Riyaad Miller - MWeb wrote: > Hi ALL > > Has anyone come

Re: Off Topic PHP-MySQL

2001-09-14 Thread Dave Webb
perhaps news.php.net with newsgroup php.db "Todd Moy" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Sorry about the OT, but I thought someone may know a good PHP listserv. > Basically, I am trying to retrieve images from a MySQL database with PHP > scripts. >

Strange error when doing insert into DB

2001-09-14 Thread Riyaad Miller - MWeb
Hi ALL Has anyone come across the following error: "Can't mix placeholder styles (:foo/:1) at /usr/local/lib/perl5/site_perl/DBD/Oracle.pm line 293, chunk 1085." Unix OS - SunOS 5.6 Oracle - 7 The problem does multiple actions ranging from updates, insert and of course selects from my DB. Your

Re: OT Perl Optimizations Was: undef & NULL

2001-09-14 Thread Peter J . Holzer
On 2001-09-13 17:01:20 -0400, Rob Ransbottom wrote: > On Thu, 13 Sep 2001 [EMAIL PROTECTED] wrote: > > > I have a minor optimization suggestion. Instead of this: > > > unless ($sth_routine_name) { > > #setup statement handle > > } > > > Do this: > > > > $sth_routine_name ||= $dbh->prepare