RE: ODBC fails on test

2002-02-19 Thread john
I did so and now when I do an 'make test TEST_VERBOSE=1' Ill get: PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.6.0/i386-linux -I/usr/lib/perl5/5.6.0 -e 'use Test::Harness qw(runtests $verbose); $verbose=1; runtests @ARGV;' t/*.t t/01base1..5 ok 1 ok 2

RE: ODBC fails on test

2002-02-19 Thread john
I made a mistake when I checked it earlier, ignore that e-mail. Here's the output: cp ODBC.pm blib/lib/DBD/ODBC.pm PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.6.0/i386-linux -I/usr/lib/perl5/5.6.0 -e 'use Test::Harness qw(runtests $verbose); $verbose=1; runtests

script --- very basic

2002-02-19 Thread Bryan Tolka
Hello everyone. I have a script below that opens another file checkdns.pl and executes a while loop. I would like to pass it a variable $dnsName. This however seems to be eluding me and my poor scripting abilities. The checkdns.pl script works when executing the file itself. Is this the

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: script --- very basic

2002-02-19 Thread Hardy Merrill
Bryan, this question has nothing to do with DBI, but since I see that the script being run(checkdns.pl) does use DBI, I guess it's not completely off-topic. You actually want to have update.pl execute checkdns.pl right? There are a few options to consider, but dot slashing it is not one of them.

Re: script --- very basic

2002-02-19 Thread cpryce
From: Hardy Merrill [EMAIL PROTECTED] I'm not sure how to find the backticks discussion in the perldocs, but I'm pretty sure it's there - you just have to find it. Also, any of the perl books should describe it. Some helpful pod pages: perldoc perlop perldoc -q backtick perldoc

RE: script --- very basic

2002-02-19 Thread Sterin, Ilya
This is OT, please refer to a correct group. A good place to start would be groups.google.com in comp.lang.perl.misc Ilya -Original Message- From: Bryan Tolka To: Dbi-Users Sent: 2/19/02 5:12 AM Subject: script --- very basic Hello everyone. I have a script below that opens another

RE: ODBC fails on test

2002-02-19 Thread Jeff Urlwin
John, I'm trying to install MySQL and MyODBC. Here's what I've done so far: Install MySQL 3.23.49 from binary (non max version) Attempt to install MyODBC 3.51.01 from source or binary (fails as I don't have a specific client lib) I'm looking to fix the client

oracle-dbd problem

2002-02-19 Thread Brij P Singh
Sir, I have been going through a tough time while accessing oracle database through web.it works fine from linux command prompt.But when I access the same script it gives me the folloeing errors. I have tried changing /etc/ld.so.conf and ldconfig and I have also tried supplyimg oracle variable

RE: oracle-dbd problem

2002-02-19 Thread Sterin, Ilya
That is because your LD_LIBRARY_PATH is not set for the user that the webserver uses to run requests. It's usually nobody or www, but might vary. Just set up the environment. Ilya -Original Message- From: Brij P Singh To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: 2/19/02 8:35 AM

PPM and DBD-ODBC

2002-02-19 Thread Accardo, Glen
Is there a PPM version(?) of DBD-ODBC 0.38? ActiveState only has version 0.28. Thanks, glen accardo [EMAIL PROTECTED]

Re: Mapping a push engine to DBI

2002-02-19 Thread Jeff Zucker
Matt Sergeant wrote: DBI uses pull - you execute a statement then pull the results one by one - exactly the same as a cursor in SQL terms. But I'm working on a DBD driver [1] for a push engine - you pass a callback function to execute() and it calls that for every row in the result set.

RE: PPM and DBD-ODBC

2002-02-19 Thread Jeff Urlwin
They have updated theirs recently to .37, I noticed last week. I'm using the PPM2 program, included in the latest download. Jeff -Original Message- From: Accardo, Glen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 11:24 AM To: [EMAIL PROTECTED] Subject: PPM and

how to install dbi

2002-02-19 Thread buck lane
is there a good how-to on how to install mysql dbi and radiator ( or any radius software) i am having problems getting my radius software to use dbi, it isnt showing that dbi is installed. i am running red hat 7.2 are there any known problems with red hat 7.2 and DBI, im about to lose my

Re: [PATCH] improved sanity in DBD::Pg

2002-02-19 Thread David Wheeler
On Sun, 2002-02-17 at 13:28, Jeffrey W. Baker wrote: Is the DBD::Pg maintained? It's documentation is rotting slightly. If Edmund wants to hand it off, I'd be pleased to take it on. Yes, please! I submitted a patch back in November, and have yet to hear from Edmund on it. I'd really like to

Re: ANNOUNCE: DBD::SQLite

2002-02-19 Thread Jeff Zucker
Matt Sergeant wrote: I've just uploaded the first public version of DBD::SQLite to CPAN. Again, congratulations. It looks like a fine addition to the DBDs. I have a bit of concern about your comparisons with DBD::CSV though, please see my comments below which widen the field of comparison a

cancelling query initiated from web form, WAS 'Cancelling HUGE sql queries'

2002-02-19 Thread Anna Fong
RE: http:[EMAIL PROTECTED]/msg08566.html http:[EMAIL PROTECTED]/msg08567.html It was suggested to capture the PID in order to kill any abandoned queries. This appears to work if the web server, web app, and database are all on the same machine. However, it doesn't seem so if the web server and

SOT: DBD::mysql and wierd disconnect errors under mod_perl

2002-02-19 Thread Vuillemot, Ward W
This is slightly off topic, per se, but I was hoping that someone might have an answer. I recently moved my CGI into the mod_perl environment under Apache. I had, until this point, never seen the following error with my scripts. [Tue Feb 19 13:32:28 2002] nul: Database handle destroyed without

Inserting CLOB values with DBD::Oracle

2002-02-19 Thread Jeremy Keeler
Greetings dbi-users, Does the newest version of DBD::Oracle fully support the SQL_CLOB type? When I try to use bind_param() to bind character data to a CLOB field using DBI::SQL_CLOB type in an Oracle 8 database, DBI is giving me the message: SQL type 40 for ':p4' is not fully supported,

RE: Inserting CLOB values with DBD::Oracle

2002-02-19 Thread Kotha, Nagaraju
Here is the thing you need to do: BEGIN { $dbh = DBI-connect(connect_sting) or die $DBI::errstr \n; $dbh-{LongReadLen}=65000; $dbh-{LongTruncOk}=1; } $sth-bind_param(1,$clob1,{ora_type=ORA_CLOB, ora_field='FIELDNAMEOFCLOB1'});

RE: Inserting CLOB values with DBD::Oracle

2002-02-19 Thread Sterin, Ilya
LongReadLen and LongTruncOk have nothing to do with inserting *LOB data. Ilya -Original Message- From: Kotha, Nagaraju To: [EMAIL PROTECTED] Sent: 2/19/02 2:51 PM Subject: RE: Inserting CLOB values with DBD::Oracle Here is the thing you need to do: BEGIN { $dbh =

odbc

2002-02-19 Thread buck lane
is anyone aware of a good how-to for setting up DBD-ODBC and iodbc, or would anoyne give me a good layout of how it works, thanks

RE: odbc

2002-02-19 Thread Jeff Urlwin
Buck, That also depends upon the driver. Most recently I setup unixODBC (instead of iODBC) and had it running with very little effort. I used: unixODBC (latest) Easysoft's ODBC-ODBC Bridge and (for grins) FreeTDS with their ODBC driver. unixODBC was simple to setup