RE: Performance problem with DBI, DBD-Oracle8

2002-10-03 Thread John-Thomas Beadles
Thanks. v1.03 on the Unix side, v1.8 on the PC. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 11:02 AM To: Beadles, John-Thomas [RICH1:2795:EXCH] Cc: [EMAIL PROTECTED] Subject: RE: Performance problem with DBI, DBD-Oracle8 perl

RE: Performance problem with DBI, DBD-Oracle8

2002-10-03 Thread John-Thomas Beadles
PROTECTED]] Sent: Thursday, October 03, 2002 11:13 AM To: Beadles, John-Thomas [RICH1:2795:EXCH] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Performance problem with DBI, DBD-Oracle8 I'm sure you are aware of this, but the DBI/DBD::Oracle are very old on that server. On 03-Oct-2002

RE: Performance problem with DBI, DBD-Oracle8

2002-10-03 Thread John-Thomas Beadles
Bingo, we have a winner! I've alternated including this statement, and it definitely appears to be the key, at least for this test code. Now I have to go modify my production code. I'll let you know if it works the same way. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: Performance problem with DBI, DBD-Oracle8

2002-10-03 Thread John-Thomas Beadles
: Thursday, October 03, 2002 12:23 PM To: 'Tim Bunce '; Beadles, John-Thomas [RICH1:2795:EXCH] Cc: '[EMAIL PROTECTED] ' Subject: RE: Performance problem with DBI, DBD-Oracle8 Why can't you access the DBI FAQ? www.xmlproj.com/cgi/fom.cgi Ilya -Original Message- From: Tim Bunce

RE: Performance problem with DBI, DBD-Oracle8

2002-10-03 Thread John-Thomas Beadles
It's definite. I implemented it all through my code and dropped the execution time from 40+ minutes to approximately 4.5 minutes. I've notified the sys admin to the problem, see if we can implement a global solution. Thanks a bunch, guys! -Original Message- From: Beadles, John-Thomas

RE: Performance problem with DBI, DBD-Oracle8

2002-10-03 Thread John-Thomas Beadles
PM To: Beadles, John-Thomas [RICH1:2795:EXCH] Cc: [EMAIL PROTECTED] Subject: RE: Performance problem with DBI, DBD-Oracle8 Have him update your DBI DBD::Oracle to the latest versions. (1.30) (1.12) On 03-Oct-2002 John-Thomas Beadles wrote: It's definite. I implemented

Performance problem with DBI, DBD-Oracle8

2002-10-02 Thread John-Thomas Beadles
destruction. John T. Beadles Wireless Network Engineering - Engineering Tools Processes - Nortel Networks 972-685-8713 phone, ESN 445-8713 972-684-3626 fax [EMAIL PROTECTED]

Anyone using OS Authentication with Oracle 9i?

2002-09-17 Thread Schaefer, John
Morning. Our dba has decided to implement OS Authentication/external authentication for selected user names in our Oracle db. The Oracle security manual discusses the meaning of the 'ops$' prepended to the user name as an indicator of OS Authentication on the user 'schaefer'. This means that once

Lost

2002-09-10 Thread John Gedeon
is on a different machine, perl and apache are installed on a solaris 2.8 os Can anyone offer some help??? John Proverbs 3:5 Trust in the Lord with all your heart and lean not on your own understanding;

Re: DBD:ODBC - Retrieving Unicode values on W2K + MSSQL 2000

2002-09-10 Thread john mapoles
translated my data set to Latin-1 and have had no problems since. My selects never return ''. But, the extended characters will be represented differently depending on your shell and editor. John Mapoles --- Olivier Poulet [EMAIL PROTECTED] wrote: Using ActiveState Perl 5.6.1 build 633

problem with build .

2002-09-06 Thread Gallagher, John (5462) (OM)
Hi I have included a build log from an attempted install of DBI module 1.30 on a Solaris System. It seems to be complaining about 'language optional software package not installed ( I have included output of perl -V) Any help given is greatly appreciated. John __ build.log

DBI build on Solaris

2002-09-06 Thread Gallagher, John (5462) (OM)
Hi I have included a build log from an attempted install of DBI module 1.30 on a Solaris System. It seems to be complaining about 'language optional software package not installed ( I have included output of perl -V) Any help given is greatly appreciated. John __Script

Sending DBI data to PDF?

2002-09-06 Thread Herbold, John W.
Has anybody done anything with sending data from DBI calls to PDF files? Thanks ! John W. Herbold Jr. IS Specialist/DBA

DBD-Oracle and bulk binds

2002-09-06 Thread John Lien
-Oracle. If they have been, I'd like to know what version. If not, is this on the horizon? Thanks, John Here are the versions I'm running: DBI 1.20 DBD-Oracle 1.12 Perl 5.6.1 Oracle 8.1.7 Solaris 2.8

RE: Sending DBI data to PDF?

2002-09-06 Thread Herbold, John W.
that has been done. Thanks, John W. Herbold Jr. IS Specialist/DBA -Original Message- From: David Dooling [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 11:01 AM To: [EMAIL PROTECTED] Subject: Re: Sending DBI data to PDF? On Fri, Sep 06, 2002 at 10:52:00AM -0500, Herbold

Installation Issues

2002-09-05 Thread John Gedeon
I recently installed perl 5.8.0 on my computer. I then downloaded and installed the DBI module and DBD Oracle Module. however I am unable to connect. I think my installation was wrong but I am not sure where, nor do I have any idea where to fix it if I reinstall. when ever a script attempts

Re: Failure of ODBC connection with Access

2002-08-30 Thread John
the *.ppd and *.tar.gz files are located type: ppm remove DBD-ODBC.ppd to remove any existing DBD-ODBC module, then type: ppm install DBD-ODBC.ppd HTH -- Regards John McMahon (mailto:[EMAIL PROTECTED])

Limiting number of concurrent DB connections

2002-08-19 Thread John Stannard
of child connections to the database, despite the fact that they all aren't required concurrently. Anyone dealt with this issue? Thanks very much. John

RE: case-insensitivity in Access

2002-08-09 Thread Guidarelli, John
Hi Nick, Try something like this: SELECT * FROM people WHERE UPPER(lname) LIKE '%OFF%'; Good luck. -John -Original Message- From: Nick Hoffman [UWO] [mailto:[EMAIL PROTECTED]] Sent: Friday, August 09, 2002 3:06 PM To: DBI-Users Subject: case-insensitivity in Access Hey

Followup on DBD::CSV question

2002-07-30 Thread John Brooking
referen ce at C:/Perl/site/lib/SQL/Statement.pm line 499, GEN1 line 1. Any thoughts would be appreciated. - John = Now it's over, I'm dead, and I haven't done anything that I want; or, I'm still alive, and there's nothing I want to do. - They Might Be Giants, http://www.tmbg.com

DBD::Oracle - specifying rollback segments

2002-07-30 Thread Guidarelli, John
Hello, Is there anyway to specify the rollback segment to use in Oracle via the DBD::Oracle module? I did not see anything in the DBD::Oracle or DBI perldocs other than the begin_work DBH Object (which doesn't take any parameters). Thanks in advance. -John

RE: DBD::Oracle - specifying rollback segments

2002-07-30 Thread Guidarelli, John
FYI... Thanks for the info and the warning. I ended up using: $dbh-do('set transaction use rollback segment rbs_large01') || warn $dbh-errstr; I've been stung by not re-setting the rollback segment after a commit in the past, so I accounted for that too. -John -Original Message

Thoughts on DBD::CSV?

2002-07-29 Thread John Brooking
, if desired. Has anyone else ever had similar problems? - John Brooking = Now it's over, I'm dead, and I haven't done anything that I want; or, I'm still alive, and there's nothing I want to do. - They Might Be Giants, http://www.tmbg.com __ Do You

table descriptions via DBD::Oracle

2002-07-23 Thread Guidarelli, John
Does anyone out there know if there is way to get the column names/types for a given table using the DBD::Oracle driver? I looking for something like the DESCRIBE SQL*Plus command. Thanks in advance. -John

Re: Newbie question concerning DBI

2002-07-09 Thread John Saylor
Hi Use placeholders Verify operations ( 02.07.09 06:40 -0700 ) Dana Lucent: $datafile = CERT.TXT; open(DATAFILE, $datafile); Should check for errors here. chomp(cert = DATAFILE); Check cert. I'm not sure you're using chomp correctly here [maybe]. Use and execute with variables later, for

Re: DBI Author?

2002-06-24 Thread John Day
, but thank you from a truly appreciative user! John Day Words Images Toronto, Canada At 02:52 PM 6/24/2002 +0100, Tim Bunce wrote: On Sun, Jun 23, 2002 at 09:41:28PM -0700, Clarence Snivellwitz wrote: Can someone tell me who authored the DBI module? I'm trying to locate the documentation on CPAN

Re: need execute perms?

2002-06-24 Thread John Day
1.. Have you made the scripts executable? by using CHMOD 755 or something similar. You can often do this in your ftp client. 2.. Who is your provider, so we may all studiously avoid them in the future? John Day Words Images Toronto, Canada At 11:07 AM 6/24/2002 -0400, Nick Hoffman [UWO

Re: need execute perms?

2002-06-24 Thread John Day
correctly it will execute. The error message that was originally provided seemed to indicate that the script did not have the appropriate permissions, rather than the interpreter being unlocatable. John At 01:01 PM 6/24/2002 -0400, Jeff Seger wrote: Are you certain that you have the correct

Re: MS Access

2002-06-24 Thread John D Groenveld
DBD::ODBC. John [EMAIL PROTECTED]

compiling dbd:oracle for 8.1.7

2002-06-13 Thread John Hall
Is there a howto? I can't figure out what files I need from the oracle install to make this happen. I assume I have to copy a portion of the oracle install on the server to a local directory and point $oracle_home at it, per the instructions, but what do I need? I can't find any hints via google.

Re: use strict

2002-06-13 Thread John Saylor
Hi ( 02.06.13 16:54 -0400 ) James Pittman: Variable $sth is not imported at filename.pl line XXX Global symbol sth requires explicit package name at filename.pl line 261 Is there a good way to get around this? my $sth; I would like to use strict but I'd like to get rid of those errors.

Building DBD::Oracle on HP-UX 11i with Oracle 9i and 64 bit perl 5.6.1

2002-06-06 Thread Cotter, John D
I wanted to submit this to the list (and potentially to whoever maintains the README.hpux for the DBD::Oracle) but first I wanted to see if anyone finds this useful. Please mail me any comments, updates or corrections. thanks, - John

Quick Question... I hope ;-)

2002-05-22 Thread Herbold, John W.
Help! I have a chance for Perl to take yet another deep foot hold in my company! However I need it to be able to hit IMS on the mainframe? We have it hitting DB2 on the mainframe already, but for a new project, we need it to be able to read IMS tables. Any Ideas? Thanks in advance! John

RE: Soalris, DBD-1.12 and Oracle9i

2002-04-26 Thread Schaefer, John
Our solution: bit-time-kludge afer Makefile.PL creates the makefile, edit it in vi. Replace '911/lib' with '911/lib' everywhere Replace 'rdbms/lib' with 'rdbms/lib' everywhere. Then do your make. To really fix this will take someone who knows Makefile.PL to apply a patch detect the 64bit version

Re: dbi make failed on solaris 8

2002-04-25 Thread John D Groenveld
Extending Sun's shipped perl is rife with problems so just don't do it. rm /usr/bin/perl # Sun's scripts reference /usr/perl5/bin/perl, thanks Sun! install your own perl from source with your preferred compiler. extend as desired. Have fun! John [EMAIL PROTECTED]

Re: Postgres 7.2, DBI DBD::Pg

2002-04-23 Thread John Cuson
you might also check to see if the new installation overwrote the old pg_hba.conf file. john cuson ([EMAIL PROTECTED], [EMAIL PROTECTED]) The world is full of obvious things which nobody by any chance ever observes. Sir Arthur

RE: Transferring from Access to MySQL

2002-04-22 Thread Herbold, John W.
into a mysql database, it took like 8 - 12 hours to run for around 15 million very wide records (can't remember exact time, do to many loads ;-). John Herbold IS Specialist/DBA -Original Message- From: Mark Riehl [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 11:23 AM To: [EMAIL

RE: Storing text in SQLServer image column

2002-04-16 Thread John
This is perfect, and so easy. Now on to find out if CFM has an equivalent, and if SQLServer stored procs have MicroSoft's phantom string length limit. Thanks again, -John At Monday, 15 April 2002, Jeff Urlwin [EMAIL PROTECTED] wrote: Read the DBI docs regarding LongReadLen. You only

Storing text in SQLServer image column

2002-04-15 Thread John
to avoid this. I have been having trouble subscribing to this list - please respond directly. Thanks in advance, -John So far the closest code I think I have written is this (no errors reported at insert - error trapping removed): my $long = A23456789B x 1000; $long = $dbh-quote( $long

RE: Storing text in SQLServer image column

2002-04-15 Thread John
it is below. Someone mentioned I might use a text type instead of varchar, and if that doesn't work we'll probably store the location of an include file containing the content in the database rather than the data itself. Thanks, -John cfloop query=GetImageData cftry cfset

RE: Storing text in SQLServer image column

2002-04-15 Thread John
an example)? And since it's text, I shouldn't even have to specify a type - why is it getting truncated? Thanks again, -John my $sql = select TextType from TestImage where TestImageID = 41; my $sth = $dbh-prepare( $sql ); my $ret = $sth-execute(); while( my data = $sth-fetchrow_array

RE: mysql query

2002-04-10 Thread John Boucher
From the fine MySQL documentation: -- 1.4.4 Functionality Missing from MySQL The following functionality is missing in the current version of MySQL. For a prioritized list indicating when new extensions may be added to MySQL, you should consult the online MySQL TODO list. That is the

Install issue on OSX Server

2002-04-09 Thread John CW Endahl
I've been banging my head on this one pretty good the past couple of days... I tried the same package out on OSX and it seems to work just fine but not on OSX Server. Any help would be greatly appreciated. TIA. Here's what I get: [corinth:~/Desktop/DBI-1.21] jendahl% perl Makefile.PL ***

Re: Could you tell me where Solaris-ready DBI and DBD::Oracle modules available?

2002-04-06 Thread John D Groenveld
all build under Solaris with gcc which ships with Solaris 8 media kits and available online from sunfreeware.com among other places. John [EMAIL PROTECTED]

Re: memory leaks

2002-03-28 Thread John Cuson
into a loop and playing with the number of records i retrieved at a time. i think i ultimately let it go with either 100 or 1000 record result sets. it runs at night, and performance is not really an issue, so i didn't get deeply into tuning it. john cuson ([EMAIL PROTECTED], [EMAIL PROTECTED

Any patch to Makefile.PL for DBI-Oracle-1.12 for Oracle9i 64bit?

2002-03-27 Thread Schaefer, John
Apparently Oracle stored the 64 bit libraries in .../lib .../rdbms/lib. 32 bit libraries are available in .../lib32 and .../rdbms/lib32. I'm forced to stay with Perl 32bit the workaround is to manually edit the resulting Makefile. Anyone have a patch to detect correct this situation? John

RE: Float vs. double in MySQL

2002-03-22 Thread John Boucher
Here, at least for reference, is an exerpt from the RDB documentation. - SQL provides three floating-point numeric data types: o FLOAT Specifies that the column is a 32-bit (REAL) or 64-bit (DOUBLE PRECISION) floating-point number, depending on the

RE: Returning auto incremented value on insert

2002-03-21 Thread John Boucher
Just a comment: It seems to me that the reason you can't have the ID of the last inserted row automatically returned in a variable is that some (most?) databases allow INSERT to insert more than one row at a time. This would affect auto-increment as well. Sure, you may only be inserting one row

RE: Shorter way to define placeholders...

2002-03-15 Thread John Boucher
My first thought is to string multiply by the number of elements: JB1: perl -e print('?',',?'x (@ARGV-1)); a b c d e f ?,?,?,?,?,? or JB1: perl -e print('?',',?'x (split(',',$ARGV[0])-1)); a,b,c,d,e,f ?,?,?,?,?,? P.S. I get this on the latter... Use of implicit split to @_ is

Re: Need help with map and sort

2002-03-13 Thread John Saylor
Hi ( 02.03.13 11:39 -0500 ) Etienne: my $rs_ref = $dbh-selectall_arrayref (SELECT evtDate, evtID, evtName FROM events); map { $sum += $_-[0] } {$rs_ref}; While TMTOWTDI, since you're not doing anything with the return value from map, you're better off using foreach. Unless you get paid more

Re: Need help with map and sort

2002-03-13 Thread John Saylor
Hi ( 02.03.13 11:03 -0600 ) [EMAIL PROTECTED]: see Schwartzian Transform in the cookbook or camel. Even better- Uri Guttman's paper on sorting [munge data BEFORE sorting since default sort is much faster]. -- \js aggregate proactive e-services

DBI and PDF...

2002-03-11 Thread Herbold, John W.
Does anybody have an example or two of spitting out a result from a DBI call into a PDF file ? I am loosing what little hair I have left trying to get PDF::CREATE to put thing like I want them! Thanks ! John W. Herbold Jr. IS Specialist/DBA

Re: DBI Installation

2002-03-08 Thread John Cuson
of the perl library for postgresql database operation. john cuson ([EMAIL PROTECTED], [EMAIL PROTECTED]) The world is full of obvious things which nobody by any chance ever observes. Sir Arthur Conan Doyle Suresh the Programmer

Re: DBI error on Solaris x86

2002-03-05 Thread John D Groenveld
/5.005/i86pc-solaris/auto/DBI/DBI.so libc.so.1 = /usr/lib/libc.so.1 libdl.so.1 =/usr/lib/libdl.so.1 Can your gcc build hello world? Did you build your perl from source? John [EMAIL PROTECTED]

RE: SELECT \$moid FROM xyz.abc

2002-02-28 Thread John Boucher
CHAR and VARCHAR data got converted to a numerical representation of their ASCII values much like John Boucher was thinking. It was a bug in the IBM implementation of DBI that was corrected with the DBI for V7.1 databases. If you are reading from and older DB2 database or using and older version

RE: SELECT \$moid FROM xyz.abc

2002-02-27 Thread John Boucher
I don't know DB2, but I'm wondering if you're getting a weird binary rendition of characters. Each character is one byte and each byte contains two nybbles, each nybble being represented by one character. For instance, the hexadecimal ASCII code for the letter H is 48, so Hello. would yield

Re: Concise manual

2002-02-25 Thread John Cuson
while this may seem like overkill, if the $30 doesn't bother you the o'reilly perl nutshell book had a nice section providing essentially what you're asking for. it also has the advantage of providing that same capability for perl in general. john cuson ([EMAIL PROTECTED], [EMAIL

RE: ODBC fails on test

2002-02-19 Thread john
ok 3 ok 4 ok 5 ok t/02simple..1..17 ok 1 Test 2: connecting to the database ok 2 Test 3: create test table And here it just stops. Ill have to abort it with a Ctrl+C. John, Would you do me a favor and go into ODBC.pm and comment out the whole do routine. Let me know if that gets

RE: ODBC fails on test

2002-02-19 Thread john
5: insert test data not ok 5 Test 6: select test data It stops here instead. John, Would you do me a favor and go into ODBC.pm and comment out the whole do routine. Let me know if that gets the tests to pass for you. It's some relatively new code using SQLExecDirect instead of the whole

RE: ODBC fails on test

2002-02-19 Thread john
When I got back from lunch I noticed that it had appended a couple of lines since last: Test 4: check existance of test table not ok 4 Test 5: insert test data not ok 5 Test 6: select test data dubious Test returned status 0 (wstat 15, 0xf) DIED. FAILED tests 3-17 Failed

Re: ODBC fails on test

2002-02-17 Thread John Ericson
4/6 tests, 33.33% okay t/05meth1..6 ok 1 ok 2 On Feb 16 20:39, Jeff Urlwin wrote: John, I believe iODBC has a test program to ensure your ODBC.ini is correct. That should be the major issue. iODBC includes the odbctest program in the samples directory. I'm not sure what

DBI:ODBC fails on test

2002-02-15 Thread John Ericson
98 88.89% 2-9 t/08bind2.t 015?? ?? % ?? t/09multi.t 015?? ?? % ?? Failed 6/7 test scripts, 14.29% okay. 34/43 subtests failed, 20.93% okay. make: *** [test_dynamic] Error 2 Please CC me since Im not a member of this maillinglist. -- * John

Nearly built the *new* DBI module. So close! Request help...

2002-02-12 Thread John Doe
Not sure what sort of mailing list [EMAIL PROTECTED] is (mail-to-news?); I got read the help and subscribed (there is no FAQ yet). The GREAT new version released last week does not require Tk! Per Tim's instructions at http://dbi.symbolstone.org, I read the README, followed instructions,

Re: SQL Implementation Specifics

2002-01-25 Thread John D Groenveld
Many moons ago you could approach Len Gallagher @ NIST.GOV who is/was on the ANSI SQL committee. I'm sure someone from NIST still is active and he could point you to the right people. John [EMAIL PROTECTED]

Trouble building DBI for VMS

2002-01-21 Thread John Boucher
did not actually change.) JB1: mcr perl -e use File::Find; File::Find::find(sub {print $File::Find::name\n;} , /lib/bundle ) ; Can't stat /lib/bundle: file specification syntax error -- John Boucher, NTS

Re: Got a queston about OTHERLDFLAGS

2002-01-18 Thread John D Groenveld
Seems like you should be able to do... env LDFLAGS=-L/path/to/lib -R/path/to/lib -lfoo perl Makefile.PL and have it set OTHERLDFLAGS in Makefile to yours. But of course I always get sea sick when I look at Makefile.PL. John [EMAIL PROTECTED]

runtime link path

2002-01-13 Thread John D Groenveld
, John [EMAIL PROTECTED]

DBI module

2002-01-09 Thread John Tankersley
Hello, My name is John Tankersley. I am seeking some help with the perl modules. I hope I understand the dbi modules. Please correct me if I am wrong.I am building databases using mysql. I have SuSE 7.3 installed on my system. I am using mysql to create database tables. I was using db2 for linux

cgi and postgresql weirdness

2002-01-02 Thread John Cuson
=~s/^\s+//; $dbh_list=DBI-connect($dsn,$username,$password) or die print ACCESS DENIED; can anyone point out to me why the postgresql dbi driver is choking on this? john cuson ([EMAIL PROTECTED], [EMAIL PROTECTED]) The world is full of obvious things which nobody by any chance ever observes

ReL DBD-ERROR: OCIServerAttach - ORA-12514

2001-12-31 Thread John Menke
on the local computer it gives the RE: DBD-ERROR: OCIServerAttach - ORA-12514. Not sure what the difference is. Here is the code: %attr = ( PrintError = 1, RaiseError = 1 ); eval { $dbh = DBI-connect (dbi:Oracle:$datasourcename, user, password, \%attr); }; Hi John Can you

RE: ReL DBD-ERROR: OCIServerAttach - ORA-12514

2001-12-31 Thread John Menke
Environment Variables? which ones? -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED]] Sent: Monday, December 31, 2001 9:13 AM To: John Menke Cc: Dbi-Users (E-mail) Subject: Re: ReL DBD-ERROR: OCIServerAttach - ORA-12514 Perhaps environment variables. Tim

DBD-ERROR: OCIServerAttach - ORA-12514

2001-12-28 Thread John Menke
is that I can use TNSPing on the same box and the name resolves fine Any ideas? john

Using an OUTPUT parameter from a stored procedure via DBD::Sybase to MS SQL Server7

2001-12-05 Thread John Ulmer
, -- John Ulmer

DBD::Oracle 1.12 under RedHat 7.2

2001-11-09 Thread John Vaccaro
of the 'perl Makefile.PL -v' and make' steps if anyone would like to see them. Thanxs in advance John Vaccaro Emazing.com, [EMAIL PROTECTED] (502) 583-7890 x249 --- Better to understand a little than to misunderstand a lot.

Re: Hello? Anybody there?

2001-10-31 Thread John D Groenveld
anyone know a good webdoctor? Does [EMAIL PROTECTED] bounce? John [EMAIL PROTECTED]

DBD::Informix compilation issue

2001-10-18 Thread John Peterson
Hi, Can someone help me. If I can buy support for this issue we will. We're desperate. I have the following installed. Perl 5.6.1. I built from source. GCC 2.95.3 20010315 (release). Informix CLIENT SDK 2.70.FC1. DBI-1.20 I've got the following DBD module not built or installed yet.

Re: Unix GUI tool for Oracle (and others like mysql in future)

2001-10-15 Thread John D Groenveld
Though perhaps I am straying off-topic too, so I'll stop there. I'll bring it full circle: Where in the world did Orac run off too? Kevin Kitt's website is down. John [EMAIL PROTECTED]

Re: DBI-1.20 installation problem

2001-10-10 Thread John D Groenveld
To whom it may concern or John Groenveld: I am installing DBI-1.20 and received the error from running make. Apparently, the file it is looking for is not in the CORE directory. = Perl 5 was installed first, then DBI on a AIX platform running 4.3.3. I am a newbie unix system admin

Re: Drivers to connect Oracle database(on Solaris) from Perl script on Unix(Solaris)

2001-10-10 Thread John D Groenveld
Under Win32, ActiveState bundles a script called PPM to automate the installation of Perl modules. My guess is they have a corresponding tool for Solaris. John [EMAIL PROTECTED]

Re: DBI/Solaris User

2001-10-10 Thread John D Groenveld
Yes, DBI and likely all of the database specific DBD's work fine under Solaris. You'll need your own build of Perl or at least one built with a compiler that you have installed (gcc). John [EMAIL PROTECTED]

Re: Informix DBD Error

2001-10-08 Thread John Saylor
Hi - Original Message - From: Rajeev Nalluri [EMAIL PROTECTED] Sent: Monday, October 08, 2001 12:18 I think I may need to either re-install DBD or re-compile DBD with the new Informix PATH. Or you need someone to put those files in the same place[s] the first ones were. Can you

Error calling my Oracle procedure

2001-09-18 Thread Moon, John
: ' || SQLERRM; END; -- Function LOGON Any help or suggestions will be greatly appreciated... John W Moon State Technology Office 1255 S Main St. Georgetown, Tx 78626 email: [EMAIL PROTECTED] phone: (512) 868-8874

insert Clob problems

2001-09-12 Thread Brittingham, John
I get the following error when I try to insert a CLOB using DBI: Not a CODE reference at extract_ccml__to_oracle_db_testing.pl line 381, FILE_NAMES line 1. What am I doing wrong? 380 $sth = $dbh-prepare(qq{INSERT INTO t_opr_instr ( TITLE,DSCR,ORDER_SEQ,PRD_MODEL_SPEC_ITEM_ID ) VALUES (?, ?, ?,

Re: Installing DBI-1.20 on Solaris 8

2001-09-04 Thread John D Groenveld
I don't want to install Perl itself, I just want to install DBI. Sun's build is for its pwn uses ( to support applications that they ship) if you want modules not shipped with Sun's Perl build, then install your own Perl per the FAQ and README. John [EMAIL PROTECTED]

Re: Installing DBI-1.20 on Solaris 8

2001-09-03 Thread John D Groenveld
of perl, install it under a different prefix from /usr/perl5. Common prefixes to use are /usr/local and /opt/perl. The preferred solution is to install your own build of perl. John [EMAIL PROTECTED]

RE: Oracle DBD Make failing on HPUX 11

2001-09-02 Thread Penaluna, John
*** Error exit code 1 Stop. Regards John -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 7:26 PM To: Penaluna, John Cc: 'Tim Bunce'; '[EMAIL PROTECTED]' Subject: Re: Oracle DBD Make failing on HPUX 11 On Fri, Aug 31, 2001 at 12:07:05PM +1000

Re: DBD::Oracle-1.10 build problem with Oracle-8.1.7

2001-09-01 Thread john mcilwain
You need the DBD::Oracle 1.12 build, it fixed my problems ;) It should be on the mirrors by now... -john From: Mark Borges [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: DBD::Oracle-1.10 build problem with Oracle-8.1.7 Date: 31 Aug 2001 11:21

Re: ANNOUNCE: DBD::Oracle 1.10

2001-08-30 Thread John D Groenveld
LD_RUN_PATH still doesn't seem to get set... John [EMAIL PROTECTED] *** Makefile.PL 2001/08/30 20:58:16 1.1 --- Makefile.PL 2001/08/30 21:15:57 *** *** 1139,1145 # if it's empty then set it manually $ldrp ||= $OH/lib:$OH/rdbms/lib; # stitch it back

RE: Oracle DBD Make failing on HPUX 11

2001-08-30 Thread Penaluna, John
Upgraded to DBD:Oracle 1.09 but still getting the same problem. John -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 11:44 PM To: Penaluna, John Cc: '[EMAIL PROTECTED]' Subject: Re: Oracle DBI Make failing on HPUX 11 Try DBD::Oracle 1.09

Oracle DBI Make failing on HPUX 11

2001-08-29 Thread Penaluna, John
I'm attempting to install the Oracle DBI module on a 64 bit HPUX 11.00 machine however it all falls over when I do the 'make'. It fails due to not finding library nbeq. I've installed Oracle 8.1.7 server and client on the machine with all the components I believe are required. The output is as

quoting and placeholders

2001-08-27 Thread John Saylor
Hi I am selecting from a db, using placeholders, and I'm wondering if I need to quote strings. For instance, if I am looking for this string '[EMAIL PROTECTED]' in a query like this: [note: error checking code deleted for simplicity] $sql = SELECT * FROM users WHERE email = ?; $sth =

Re: installing personal copies of DBI and DBD::Oracle

2001-08-20 Thread John D Groenveld
=/tmp/perl John [EMAIL PROTECTED]

perl-5.6.1 on IRIX 6.5

2001-07-31 Thread John C. Hardt
i have tried and failed to get perl-5.6.1 compiled on IRIX 6.5, trying both gcc-2.95.3 and the IRIX C compiler. can anyone point me at documentation or tell me how you were able to get it to compile? i have gotten perl-5.6.1 to compile on both Solaris 2.6 and HPUX 10.20. thanks! -john

Re: Mysql DBI Select Syntax ?

2001-07-03 Thread John
display the value. Furthermore, you are free to use regular text, without underscores or other restrictions, in the diploma names. I hope that this approach may offer or suggest something of value. -- John Lind [EMAIL PROTECTED]

Slow startup of DBI and DBD::Mysql

2001-06-29 Thread John
/local/lib/perl5/i386-freebsd/5.003 /usr/local/lib/perl5 /usr/local/lib/perl5/site_perl/i386-freebsd /usr/local/lib/perl5/site_perl /usr/local/lib/perl5/i386-freebsd . -- John Lind [EMAIL PROTECTED]

DBI and Perl 5.6.1.62x Application Error

2001-06-13 Thread John
Suddenly Perl doesn't work with DBI or DBD-ODBC! It *did* work, brilliantly, until last week when I installed a whole load of new modules via PPM (and upgraded from Perl 5.6.1.623 - 5.6.1.626 ) and now I cannot connect to any database without Perl dying.I have tried everything I can think of to

DBI-Pg-1.00 installation issues

2001-06-10 Thread John Gehman
Would appreciate any help that would straighten me out. I *HAVE* read the README files, but still cannot find my problem -- I'm on Redhat 6.2, Perl 5.00503, Postgres 6.5.3-6, DBI 1.18, and trying to build DBD-Pg-1.00. I've got all the postgres RPMs installed off of the disk except for jdbc,

RE: I want to unsuscribe

2001-06-06 Thread John Reid
be reintroduced? John Reid --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.256 / Virus Database: 129 - Release Date: 31/05/2001

DBI-1.15

2001-05-29 Thread John C. Hardt
these two issues fixed in the next version of the module. below is the log of the builds. one successful build for SunOS5, one failed build for HPUX10, then after changing DBI.xs the successful build for HPUX10. -john

Installation problems (DBD::Oracle 1.06 under Linux with Perl 5.6.1, DBI 1.15)

2001-05-03 Thread John Botham
gleaned by applying gdb to the core file. Has anyone seen this before or is anyone able to offer advice? Thanks - John Botham -- [EMAIL PROTECTED] Quality Director Tarragon Embedded Technology Ltd. -- http://www.tarragon-et.co.uk Tel: +44 (0)1223 323336 Fax: +44 (0)1223 323337

<    4   5   6   7   8   9   10   >