I'm trying to build on OSF, Perl 5.6.1, and Oracle 8.1.7.
1.14 builds(make test), but 1.15 prints this error on first test,
t/base...Failed to load Oracle extension and/or shared libraries:
install_driver(Oracle) failed: Can't load
'blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle:
t; method. If you are looping
through data, then using the "do" method is no worse.
I am going to create a copy using the "prepare...execute" method
exclusively, and time that against the existing version. This will give me
very real world comparison.
Thanks for
Thanks to everyone for the feedback. I have modified the script to
fix the NOW function. Thanks again.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: Hardy Merrill [mailto:[EMAIL PROTECTED]
Sent: Thursday
uot;Error updating database: ", $dbh->errstr, "\n";
Thanks again for the help.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: Hardy Merrill [mailto:[EMAIL PROTECTED]
Sent: Thursday, Januar
If the BINARY column modifier doesn't fix this, hopefully I can come
back with some more useful information. Thanks again.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original Message-
From: Hardy Merrill [mailto:[EMAIL PROTECTED]
Se
ot;Error updating database: ", $dbh->errstr, "\n";
} else {
#print "$key1 is up to date in database. No update
necessary.\n";
}
} else {
print "Error. \n";
}
}
}
The basic functionality of this script is working great. Data is
definitely making it into the database, and testing changes works as
intended. The problems mentioned above are what I am trying to rectify at
this point. Any other suggestions on improvements or better methods for
doing some of this stuff are most welcome too. Thanks in advance.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
when
this change was archived off. I know that this is actually redundant,
however, I think it will make some of the other tools easier to write later.
Thanks again for the help.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
-Original
;> '$gcos' OR home <> '$home' OR
shell <> '$shell')");
$test->execute ();
*** OUTPUT ***
syntax error at ./passwd2db.pl line 34, near ""Adding $key1 to password
database
. \n";"
Execution of ./passwd2db.pl aborted due to compilati
$home','$shell',NOW())")
or print "Error updating database: ", $dbh->errstr, "\n";(
print "Adding $key1 to password database. \n";
} elsif ($rows == 1) {
print "$key1 already in database. Updating entry now.\n";
} else {
print "Error. \n";
}
}
}
}
}
Thanks in advance for any help.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
: Can't find library or mismatched ABI for -lclntsh
I am building this again HP-UX 11i, running Perl 5.6.1 in 64 bit
mode with DBI 1.37. Any help would be most appreciated.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
Tim Bunce wrote:
> On Thu, Nov 06, 2003 at 02:07:46PM -0500, [EMAIL PROTECTED] wrote:
>> How do I determine what version of the DBD module is installed?
>
> With DBI 1.38 you can now do
>
> perl -MDBI -e 'DBI->installed_versions'
>
> and it'll tell you.
>
> Tim.
Sweet! Thanks a lot, Tim, this
Michael A Chase wrote:
> On Thu, 6 Nov 2003 14:07:46 -0500 [EMAIL PROTECTED] wrote:
>
>> How do I determine what version of the DBD module is installed?
>
> There are several DBD::xyz modules. DBI has a method for finding them:
>
>perl -MDBI -e "print join qq(\n), DBI->available_drivers"
>
cpan> install DBI::Shell
Running install for module DBI::Shell
Running make for T/TL/TLOWERY/DBI-Shell-11.93.tar.gz
Is already unwrapped into directory /root/.cpan/build/DBI-Shell-11.93
CPAN.pm: Going to build T/TL/TLOWERY/DBI-Shell-11.93.tar.gz
Checking if your kit is complete...
Looks good
Tim Bunce wrote:
>> $ perl col_info.pl
>> Undefined subroutine &DBD::mysql::db::SQL_VARCHAR called at
>> /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/DBD/mysql.pm line
>> 337.
>>
>> which I don't quite understand. I tried adding :sql_types to the DBI
>> declaration, but no go.
>
> It's
Tim Bunce wrote:
> I think the latest DBD::mysql contains my column info code and
> thus does return set & enum values.
>
> Tim.
>
> On Tue, Oct 14, 2003 at 09:01:14AM +1000, Ron Savage wrote:
>> On Mon, 13 Oct 2003 13:54:46 -0400, Scott R. Godin wrote:
>>
&g
mp; 4 field pairs are removed. Maybe I don't even need to worry
about moving this data around. Once again, any suggestions would be most
appreciated. Thanks in advance.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
Thanks for the feedback. Your guess about 'key' being a MySQL
reserved word was correct. Now to take a stab at the next error, and do a
little reading on placeholders. Thanks again.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbc
database: ",
$dbh->errstr, "\n";
}
}
close(FILE);
}
}
closedir(DATA);
Thanks in advance for the help. I am sure the answers will most
likely generate more questions, but hopefully this is a start.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
[EMAIL PROTECTED] wrote:
> is MYSQL where clause case sensitive?
> it looks like it is not
>
> redhat 9
> mysql 3.23.56
>
> name='Bob' same as name='bob'
>
For case-sensitivity, use the BINARY cast operator:
select * from $table WHERE name = BINARY 'Bob';
will only match if it's an exact ca
A while back in February, Tim and Ron were discussing DBD::mysql and
column_info..
This is the only thing I could find that *may* relate to my question, so I'm
asking here for further clarification.
It's not clear in the docs (at least not to me) whether I can have
column_info return the possible
ta
in .03 seconds. The delays were intermittent but looked like it was
hung.
Just a thought for you to try.
-Scott
On Tue, 7 Oct 2003 [EMAIL PROTECTED]
wrote:
> Hi,
>
> wie got a very strange problem here on insertion/update of rows into an
> MS-ACCESS 97 DB which gives us
just be incorporated into the DBD::Oracle driver?
Many thanks,
Scott
Unknown Sender wrote:
> W li?cie z wto, 26-08-2003, godz. 18:33, Jeff Zucker pisze:
>> Well, I thought so, and that's why AnyData works that way. But CSV
>> worked with the "\015\012" default when I inherited it and there are too
>> many scripts out there based on that behaviour for me to contemp
: 1
Entry found in database. Updating information for 117.
DBD::mysql::st execute failed: You have an error in your SQL syntax near
'group=
'root ' , lvol='/dev/vg00/home_tmp ' , stripe_num='0 ' , id='377140311' , '
at l
ine 1 at ./sys_db_update-dev.pl line 112, line 1153.
DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at
./sys_db_up
date-dev.pl line 99, line 1153.
pyro found in database. Updating information for pyro.
Hopefully this is enough information for someone to help figure out
what I am doing wrong here. Thanks in advance for the help.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
d ='$id'");
$query->execute();
$query->finish();
while (my $ref2 = $query->fetchrow_hashref ('NAME_lc')) {
undef $set2;
This now includes the other execute. Thanks again.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL P
t2;
I am getting an error on the fetchrow_hashref line. Thanks in
advance.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
messages that I do not understand what is
causing them. Any help would be greatly appreciated. Here is a portion of
the output errors.
Server name: stanley Filesystem: /var
Number of matching rows: 1
Use of uninitialized value in string eq at ./space_data.pl line 53.
Use of uninitialized value in concatenation (.) at ./space_data.pl line 55.
Entry found in database. Updating information for 23.
DBD::mysql::st execute failed: Duplicate entry '0' for key 1 at
./space_data.pl
line 62.
Note: The first line of the included code is line 39. Thanks.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
ort. Thanks.
-Original Message-
From: William Goedicke [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 29, 2003 3:10 PM
To: NIPP, SCOTT V (SBCSI)
Cc: [EMAIL PROTECTED]
Subject: Re: Perl/MySQL script...
Dear Scott et al -
>>>>> "SCOTT" == SCOTT V NIPP writes:
ve to screw around with installing or copying MySQL
libraries on 80+ servers.
Does anyone have any suggestions on how to address this issue?
Thanks in advance for the feedback.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
retrieve the ID number as some kind of
output from the reference table insert, I can avoid a second query to
retrieve this number. Make sense?
Thanks in advance for the help, and sorry again if this is off topic
for this group.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EM
get
the DBD driver to install on systems without MySQL installed? Thanks in
advance for the help. If I missed this in the docs, I apologize in advance.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
Jungian Synchronicity? It's not just a funny thing, it's downright _weird_
sometimes.
I don't get it.
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: Monday, July 14, 2003 2:47 PM
To: Hardy Merrill; [EMAIL PROTECTED]
Subject: Re: Programming the Perl DBI - 2nd edition c
I would recommend Object Oriented Perl by Damian Conway. That's probably the
best book you can read; it's full of real-world examples and witty
commentary.
-Original Message-
From: Jan Theofel [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 18, 2003 12:44 PM
To: [EMAIL PROTECTED]
Subject:
s
down the line.
Well, that's about all I can think of at the moment. I am sure that
I will have plenty more questions as this progresses. Thanks again for the
feedback.
-Original Message-
From: andy law (RI) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 18, 2003 3:33 AM
To:
03 15:35:20 -0500, NIPP, SCOTT V (SBCSI) wrote:
Hi Scott
>Thanks again for all the good feedback. If anyone can recommend
a
>good book that could help me out on this I would be most
>appreciative. I
>have some MySQL reference books, but nothing that really goes into
>dat
mean time.
-Original Message-
From: David N Murray [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 3:21 PM
To: NIPP, SCOTT V (SBCSI)
Cc: '[EMAIL PROTECTED]'
Subject: Re: Database layout and query questions...
Some questions, that might help you answer yours:
What's t
d new table altogether.
Any help would be most appreciated.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
Mkb wrote:
> #include
> int main() { exit(0); };
>
> gcc -o t.o -c t.c
> gives
> t.c:1:18: socket: No such file or directory. Not
> being a C programmer, I'm not sure how I'd get the
> compiler to include this header. Any ideas?
>
> The socket.h files are located here:
> /usr/conf/sys/socket.
[EMAIL PROTECTED] wrote:
> This looks like your GCC can not parse /usr/include/socket.h
>
> Can you test that?
>
> cat > t.c < #include
> int main() { exit(0); }
> EOF
> gcc -o t.o -c t.c
>
posting this just for comparison purposes...
my copy of redhat 8 here doesn't have socket.h in /usr/i
I've seen similar problems with the newer versions of the dbi and odbc
software on my WIN2K box running MS SQL Server. Have not seen any reported
workarounds or fixes yet.
E. Scott Stricker - NGIT @ Smartlink
- Original Message -
From: "Adam Peterson" <[EMAIL PROTE
Ron Stephan wrote:
> The way I understand it, it will select all 100,000 and then try and
> display them all. Between the server and the browser something is bound
> to break or get stupefying slow. Am I wrong? Most of the time people
> are going to have filter criteria in the display - maybe
of versions of
the ODBC package. It used to work. If you know where I can get older
versions, please let me know.
Thanks
E. Scott Stricker - NGIT @ Smartlink
- Original Message -
From: "Adam Peterson" <[EMAIL PROTECTED]>
To: "E. Scott Stricker" <[EMAIL P
work with
older software.
E. Scott Stricker - NGIT @ Smartlink
- Original Message -
From: "Adam Peterson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 26, 2003 4:59 PM
Subject: DBD-ODBC Strange Behavior?
> hello,
>
> i'm running my sc
7;t any significant bulk
operations occuring.
Any feedback is appreciated.
thanks,
Scott H. Neibarger
SRA International, Inc.
IRS ESM project
512-460-8717
later?" Or just the usual $SIG{ALRM}/eval
approach?
--
Peter Scott
http://www.perldebugged.com
Ron Savage wrote:
>>>The other thing is, Tom Phoenix's script (not module), inside, from
>>>CPAN, finds quite a few other modules not found by your script.
>>
>>Oh? Such as? This method is similar to ones used as example material
>>(but expanded upon) in CPAN.pm. I'd be surprised that it doesn't
e Created!\n";
$sqlstmt_s = "USE $db_name";
$sqlstmt_s .= "\nexec sp_grantdbaccess \'$db_user_and_domain\', \'$db_user\'";
print "EXEC SQLSTMT:[$sqlstmt_s]\n";
$sth_s = $dbh->prepare($sqlstmt_s) || die "Can't prepare
statement\n$sqlstmt_s\n$DBI::errstr";
$rc = $sth_s->execute || die "Can't execute statement\n$sqlstmt_s\n$DBI::errstr";
# LINE 827
$sth_s->finish;
E. Scott Stricker - NGIT @ Smartlink
Ron Savage wrote:
> On Sun, 23 Mar 2003 16:37:43 -0500, Scott R. Godin wrote:
>>Ron Savage wrote:
>
> Hi Scott
>
>>Yes, unfortunately there's no default $ENV{TEMP} on unix..
>>
>>I've been considering using File::Temp, File::MkTemp, or IO::File
Ron Savage wrote:
> On Sat, 08 Mar 2003 22:28:09 -0500, Scott R. Godin wrote:
>
> Hi Scott
>
>>I've written a very nice module-reporting script that helps me to
>>stay on
>>top of installed modules and easily see when they require updates
&g
Snowber Khan wrote:
> [EMAIL PROTECTED] bugzilla]# perl -MCPAN -e 'force install "DBD::mysql"'
> CPAN: Storable loaded ok
> Going to read /root/.cpan/Metadata
> Database was generated on Wed, 12 Mar 2003 15:42:32 GMT
> Running install for module DBD::mysql
> Running make for J/JW/JWIED/DBD-mysql
.
sorry about that. well, at least the trace got me out
of the fog.
j.
--
Jay Scott 512-835-3553[EMAIL PROTECTED]
Head of Sun Support, Sr. Operating Systems Specialist
Applied Research Labs, Computer Science Div. S224
University of Texas at Austin
--
Jay Scott 512-835-3553[EMAIL PROTECTED]
Head of Sun Support, Sr. Operating Systems Specialist
Applied Research Labs, Computer Science Div. S224
University of Texas at Austin
I tried it without the semicolon already, same thing happens.
(But I did try it again anyway.)
j.
--
Jay Scott 512-835-3553[EMAIL PROTECTED]
Head of Sun Support, Sr. Operating Systems Specialist
Applied Research Labs, Computer Science Div. S224
tle
like an unterminated string, but I thought perl handled that. (I've
never had to supply a null in any other of my perl stuff.) So, to me,
I've done it right. If I get into the database via
psql thingy
and cut and paste the query, it works.
What am I missing? (I've
Mel Awaisi wrote:
> Hi
>
> My error is as the subject says, i have a script that i am trying in it to
> locate where a directory with images are.
>
> the part in the script that the error i think is arising from is
>
> my $dir = '/home/me/images/';
> my @jpegs = `ls *.jpg`;
> foreach (@jpegs) {
Mel Awaisi wrote:
> Hi
>
> i am using Red Hat Linux 8 as a server for a project i am working on.
> i have installed MySQL automatically with the install of the OS. and then
> i installed Apache Server.
>
> i would like to install DBI in order for me to be able to use a script
> that i have in p
Jeff Zucker wrote:
> Tim Bunce wrote:
>
>>On Mon, Mar 03, 2003 at 10:07:29AM -0800, Jeff Zucker wrote:
>>
>>>use SQL::Statement;
>>> print $SQL::Statement::VERSION;
>>>
>>
>>Or run this command
>>
>>perl -MSQL::Statement=
>>
>
> Hmm, what am I missing? That doesn't work for me with SQL::S
ein for his wonderful
book "Network Programming with Perl"; it's been a wonderful resource for me
on this current project. If you've not purchased it, support Dr. Stein and
buy his book!
Scott H. Neibarger
SRA International, Inc.
IRS ESM project
512-460-8717
199'});
$sth->execute();
-Original Message-
From: Jenda Krynicky [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 17, 2003 3:45 PM
To: Scott Purcell; [EMAIL PROTECTED]
Subject: RE: blob error need help
From: "Scott Purcell" <[EMAIL PROTECTED]>
> I do not k
select, so it keeps installing 1.06. Any more ideas?
Thanks,
Scott
-Original Message-
From: Sumitro Chowdhury [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 17, 2003 3:32 PM
To: Scott Purcell
Cc: [EMAIL PROTECTED]
Subject: Re: blob error need help
> > while (my $doc
I am using ActiveState Perl Version v5.6.1 for MSWin32-x86 on my 2000 box.
The dbd was downloaded from active state also.
When I vi the Oracle.pm it says Version = 1.06
I am running the Oracle 8i tools on my PC.
Where should I go from here?
Thanks
Scott
-Original Message-
From: David
BD::Oracle built for Oracle 7) at ./g
etblob line 23.
###
Thanks,
Scott
#
#! perl -w
use DBI;
# binding parameters to statements.
# binding, placeholders, etc. pseudonames
my $ref = {
PrintError => 0,
RaiseError => 1,
AutoC
Curt Russell Crandall wrote:
> In case anyone cares.
>
> It appears the threaded version of Perl 5.8.0 on OSX is incompatible with
> DBI. This really bites since you need the threaded version for Apache
> 2.0.43 and mod_perl 1.99_07. So, on OSX, you are probably better off
> using FastCGI o
_perl/5.6.0
> /usr/lib/perl5/site_perl .) at - line 1.
> BEGIN failed--compilation aborted at - line 1.
>
>
> What am I missing?
>
> Thanks,
>
> Alex
>
>
--
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 08-Feb-2003
Time: 08:47:23
--
r required modules:
>>>> CGI module ... version 2.752 ok!
>>>> DBI module not found! You can find this at:
>>>> http://www.perl.com/CPAN/modules/by-module/DBI/
>>>> DBD-Mysql module not found! You can find the DBD-Mysql mod
abe collection munge up database handles
in any way?
thanks,
Scott H. Neibarger
SRA International, Inc.
IRS ESM project
512-460-8717
This may or may not be obvious... Did you add the -lcl and
-lpthreads as the first in the list of libraries? I have learned from
experience they absolutely have to be the first two in the list in that
order. Also, maybe obvious, you were compiling Perl with the -lcl and
-lpthreads, right
is in an if (0) block, so it won't ever actually run
the code that needs Time::HiRes. Might be worth it to just comment out
the use or that whole section maybe.
5.6.1 in rh7.3 on i686 hardware.
Scott
ise one! I appreciate the help and the speed of it
too!
Scott
in the script I ran and had an environment variable
(DBI_DSN) set to handle it. I used the same script successfully by just
changing the SELECT statement so I am positive that the problem is in the
modules being used somewhere.
Scott
'},
# ", name = ", $row->{'name'}, ", site_type = ",
# $row->{'site_type'}, "\n");
#}
while ( my @row = $sth->fetchrow_array() ) {
print "row: @row\n";
}
### Disconnect from the database
$dbh->disconnect;
exit;
<-- end included file query2 -->
If anyone can help, I would greatly appreciate it.
Scott
to Oracle 9i with respect to speed and any missing
> functionality? It sounds like you've been down this path already.
>
>
> Thanks again,
> Matthew
>
>
--
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 23-Oct-2002
Time: 13:20:01
--
rdbms.mk earlier but make didn't work and
there were some strange things in the makefile.
Please reply personally.
Scott Smith
NYS Task Force on Reapportionment
_
Surf the Web without missing calls! Get MSN Bro
On Wed, October 16 11:51 +0100, Tim Bunce wrote:
> Try:
> my $sth = $dbh->prepare("SELECT 1 FROM dual", { ora_check_sql => 0 });
Thanks, that did the trick. Thanks also for the detailed explanation
and links.
> I believe the parse at execute time is fundamentally an Oracle bug
> (and/or isn't
When I use DBD::Oracle 1.12 with DBI 1.30 (I also saw this on
1.06/1.15) I see two parse_calls for every execute on all selects.
Update/insert/delete just have 1 parse/execute. I have a simple test
script.
#!/usr/local/bin/perl -w
use strict;
use DBI;
my $dbh = DBI->connect("dbi:Oracle:db", "us
down or do I need to use the
> fetch_arrayref() and do it one record at a time (several million times)?
>
> Thanks,
>
> Phil
>
--
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 14-Oct-2002
Time: 20:27:57
--
I am not sure what is wrong with this... I pretty much copied this code
from one of the examples, but I am definitely having a problem. Thanks
again.
-Original Message-
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 11:12 PM
To: NIPP, SCOTT V (SB
OK... I am stuck once again. I am to pull the data from the
database and export it directly to an Excel file. Now, I am trying to
figure out the formatting... The first problem I am running into is
reformatting dates from the output of MySQL to the desired Excel format.
Here is a same
PROTECTED]]
Sent: Tuesday, October 01, 2002 11:14 AM
To: NIPP, SCOTT V (SBCSI)
Cc: '[EMAIL PROTECTED]'
Subject: Re: Database to Excel script...
Here we go:
>
> I have a MySQL database that I have a few Perl scripts working on.
> I am now looking into doing some reportin
if possible. This is also a great learning opportunity and I think that I
will have more requests in the future for generating Excel reports of this
nature.
-Original Message-
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 01, 2002 10:11 AM
To: NIPP, SCOTT V (SBCSI
file. Does anyone out there have something like this that I could
cannibalize? Thanks in advance.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
I am pretty sure this is supposed to reside in /etc. I know that on
our HP-UX boxes the tnsnames.ora is in /etc and we use Perl for some
database access.
-Original Message-
From: Sridhar Saragu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 8:24 AM
To: [EMAIL PROT
I got this working finally. I originally grabbed the wrong patch for
DBD::Oracle. The one that I ended up using was at:
http:[EMAIL PROTECTED]/msg01291.html
Thanks for the pointers on where to find what I needed Tim, and thanks
to Gerald Richter for putting the patch together.
Scott
>
s/lib/perl5/site_perl/5.8.0/i686-linux-thread-multi/DBD
/Oracle.pm
<- install_driver= DBI::dr=HASH(0x8b6cb08)
And then nothing more. When I do a connection before the threading,
There is a huge amount of output. I also don't see the connections
establish with netstat -atn.
Scott
m/installs/lib/perl5/site_perl/5.8.0/i686-linux-thread-multi/DBI
..pm line 425.
Is this just something where I need to wait for the next version of DBI?
Does DBD::Oracle not support this yet?
Thanks, Scott
This is DBI 1.30 with DBD::Oracle 1.12.
Platform is Redhat 7.3
perl -V is:
Summary of my
ere a better solution,
or can someone point me in the correct direction for oci8.c?
I've included a test program that duplicates this problem
in case there's something I'm overlooking.
Thanks.
-- Scott
# Connect, with LongTruncOK set to 0, LongReadLen to 50.
my($sth) = $d
used. By pinning the procedure in memory, it will not be
> released after each use and fall out. This saves the time of reloading the
> procedure in memory.
>
> -Original Message-
> From: Tim Bunce [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 14, 2002 10:01 AM
_
> CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is
> for the sole use of the intended recipient(s) and may contain confidential
> and privileged information. Any unauthorized review, use, disclosure or
> distribution is prohibited. If you are not the intended recipient, please
> contact the sender by reply e-mail and destroy all copies of the original
> message.
--
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 14-Jun-2002
Time: 10:14:21
--
sing
>> > dbi::proxyserver but get the following error message
>> >
>> > DBI::ProxyServer::db=HASH(0x8389228)->func() invalid redirect method
> name
>> > 'commit' at /usr/lib/perl5/site_perl/5.6.1/RPC/PlServer.pm line 332.
>> >
>> > is it a bug in dbi::proxyserver? what goes wrong??
>> >
>> > if i disable transactions ($dbh->{AutoCommit} = 1) and don't use
>> > $dbh->commit() everything works fine.
>> >
>> > Antoine Janssen
>> >
>> >
>
>
--
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 13-Jun-2002
Time: 15:44:22
--
ve to maintain two different scripts.
Any help would be appreciated. Thanks in advance, and sorry for
posting off topic.
Scott Nipp
Phone: (214) 858-1289
E-mail: [EMAIL PROTECTED]
Web: http:\\ldsa.sbcld.sbc.com
grade
> MyODBC drivers too? Can someone please tell me whether the two are related?
> I am kinda new to the whole DBI thing.
>
> - Mark
>
------
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 17-May-2002
Time: 08:38:51
--
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] (Jeff Zucker) wrote:
> "Scott R. Godin" wrote:
> >
> > The weird thing is, the same problem occurs even if I push some other
> > test in front of the XML test. =:o (tried that last night)
>
> Scott,
t FYI
print pack "H*", "4a75737420416e6f74686572204d61635065726c204861636b65722c0d";
--
Scott R. Godin| e-mail : [EMAIL PROTECTED]
Laughing Dragon Services |web : http://www.webdragon.net/
It is not necessary to cc: me via e-mail unless you mean to speak off-group.
I read these via nntp.perl.org, so as to get the stuff OUT of my mailbox. :-)
;4a75737420416e6f74686572204d61635065726c204861636b65722c0d";
--
Scott R. Godin| e-mail : [EMAIL PROTECTED]
Laughing Dragon Services |web : http://www.webdragon.net/
It is not necessary to cc: me via e-mail unless you mean to speak off-group.
I read these via nntp.perl.org, so as to get the stuff OUT of my mailbox. :-)
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] (Jeff Zucker) wrote:
> "Scott R. Godin" wrote:
> >
> > my e-mail below isn't working, and Jeff's mailserver is rejecting mail
> > from my comcast.net domain (my ISP) *sigh*
>
> Strange.
27;t quite know what's holding things up.
Jeff I'd welcome some dialog with you on this, via the list. I LOVE
AnyData (particularly useful on MacPerl :) and am frustrated that I
can't also use it on the Linux box at the moment.
print pack "H*", "4a75737420416e6f746
mysql monitor. I know this should be a simple ALTER TABLE statement, or
something similar but I can't figure out exactly how to do this. Thanks in
advance, and sorry again for posting off topic.
> Scott Nipp
> Systems Analyst
> SBC
t; +
> ++$t;
> ($ok) ? print "ok $t\n" : print "not ok $t\n";
> $expected = "undef" if !defined $expected;
>
>
> --
>
> Michael G. Schwern <[EMAIL PROTECTED]>http://www.pobox.com/~schwern/
> Perl Quality Assurance<[EMAIL PROTECTED]> Kwalitee Is Job One
> Don't treat people this way! Milk & Cheese are indestructible! You are not!
--
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 02-May-2002
Time: 13:32:12
--
lloc=n, prototype=define
> Linker and Libraries:
> ld='cc', ldflags ='-Wl,-E -lperl -lm '
> libpth=/usr/lib
> libs=-lm -lc -lcrypt
> libc=, so=so, useshrplib=true, libperl=libperl.so.3
> Dynamic Linking:
> dlsrc=dl_dlopen.xs, dlext=so, d_d
I was able to install DBI, and DBD for MySQL under 11.0, and I will
be doing this under 11i. I am quite suprised that you are having trouble.
Please let us know of your results.
-Original Message-
From: Waldemar Zurowski [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 5
201 - 300 of 429 matches
Mail list logo