RE: I need a hand ( My ENV)

Hmmn. This appears to be normal. The tests are only faling on data_sources and ping methods so the driver should be able to be used otherwise. Perhaps this needs someone to look at iODBC, or a different approach to the implementation in DBD::ODBC. Not really for this discussion. Simply note that

RE: I need a hand

Seams like no matter what I try I get : t/02simple..dubious Test returned status 0 (wstat 11, 0xb) DIED. FAILED tests 13-14 Failed 2/14 tests, 85.71% okay ##Þ print "\n Welcome to NEPP";$Þ=1;while ($Þ){

RE: I need a hand

Just to be certain that it wasn't a screwup in the OPenLink Install I reinstalled it into my /home/openlink Made the ODBCHOME=/home/openlink still get the same error ##Þ print "\n Welcome to NEPP";$Þ=1;while ($Þ){ print "\n$Þ";$Þ++;if ($Þ == 1000) { print "\n$Þ"."\nWell almost

RE: I need a hand

> -Original Message- > From: Mike McPherson [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 27, 2001 2:21 PM > To: [EMAIL PROTECTED] > Subject: RE: I need a hand > > > /usr/src/odbcsdk Are you sure the headers and libraries (compiled) are in include and lib under *this* directory. I ha

RE: I need a hand

cp ODBC.pm blib/lib/DBD/ODBC.pm /usr/local/bin/perl -p -e "s/~DRIVER~/ODBC/g" < /usr/local/lib/perl5/site_perl/5 .6.1/i686-linux/auto/DBI/Driver.xst > ODBC.xsi /usr/local/bin/perl -I/usr/local/lib/perl5/5.6.1/i686-linux -I/usr/local/lib/per l5/5.6.1 /usr/local/lib/perl5/5.6.1/ExtUtils/xsubpp -typ

RE: I need a hand

Unrecognized escape \i passed through at Makefile.PL line 217. Using ODBC in /home/pyro/openlink Umm, this looks like a iodbc type of driver manager.

RE: I need a hand ( My ENV)

UDBCINI=/home/pyro/openlink/bin/udbc.ini DBI_PASS= DBI_DSN=dbi:ODBC:demo LD_LIBRARY_PATH=/home/pyro/openlink/lib: LIBPATH=/home/pyro/openlink/lib: DBI_USER=root CLASSPATH=/home/pyro/openlink/jdk1.1/opljdbc.jar: SHLIB_PATH=/home/pyro/openlink/lib: PATH=/home/pyro/openlink/bin:/home/pyro/openlin

RE: I need a hand

Mike, Could you attach the output of perl Makefile.PL and make: perl Makefile.PL 2>&1 | tee log-conf make 2>&1 | tee log-make Neil > -Original Message- > From: Mike McPherson [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 27, 2001 2:38 PM > To: [EMAIL PROTECTED] > Subject: RE: I nee

RE: I need a hand (my debug info)

PERL_DL_NONLAZY=1 /usr/local/bin/perl -Iblib/arch -Iblib/lib -I/usr/local/lib/pe rl5/5.6.1/i686-linux -I/usr/local/lib/perl5/5.6.1 -e 'use Test::Harness qw(&runt ests $verbose); $verbose=1; runtests @ARGV;' t/*.t t/01base1..5 ok 1 ok 2 ok 3 ok 4 ok 5 ok t/02simple..1..14 ok 1

perl based script to execute cgi...

Hi, It might be a bit out topic, but I hope experts in perl will give me some solution.. As it includes the perl and the list will support it I hope solution from this list.. I have the following script that execute at command prompt and working fine .. #!/usr/bin/perl perl -pi -e 's/^(user)

RE: I need a hand

/usr/src/odbcsdk ##Þ print "\n Welcome to NEPP";$Þ=1;while ($Þ){ print "\n$Þ";$Þ++;if ($Þ == 1000) { print "\n$Þ"."\nWell almost never ending :þ";exit;}} ##Þ

RE: I need a hand

Where have you set ODBCHOME to: > -Original Message- > From: Mike McPherson [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 27, 2001 1:03 PM > To: [EMAIL PROTECTED] > Subject: I need a hand > > > I need a hand cause I can't seam to figure this out. > > As much info I can give here: >

Re: make test fails at plsql #55

For your case, I recommend dropping back to DBI-1.14. -- Mac :}) ** I normally forward private database questions to the DBI mail lists. ** Give a hobbit a fish and he'll eat fish for a day. Give a hobbit a ring and he'll eat fish for an age. - Original Message - From: "Marc Beasley" <[EM

Additional Info

Failed Test Status Wstat Total Fail Failed List of Failed t/02simple.t 011142 14.29% 13-14 Failed 1/5 test scripts, 80.00% okay. 2/40 subtests failed, 95.00% okay. make: *** [test_dynamic] Error

I need a hand

I need a hand cause I can't seam to figure this out. As much info I can give here: Red Hat Linux release 6.2 (Zoot) Kernel 2.2.14-5.0smp on a 2-processor i686 perl-5.6.1 from the rpm installed latest Bundle::DBI OpenLink SDK OpenLink Request Broker I installed the OpenLink on both my Linux and o

Test

##Þ print "\n Welcome to NEPP";$Þ=1;while ($Þ){ print "\n$Þ";$Þ++;if ($Þ == 1000) { print "\n$Þ"."\nWell almost never ending :þ";exit;}} ##Þ

Re: Problem installing DBI 1.15 on AIX 4.3 (Perl 5.0005_03)

On Thu, 26 Apr 2001, Paul Scott wrote: > Hi all, > > I am having great difficulty in getting DBI installed on an AIX 4.3 box. > Basically the Makefile.PL works great, Makefile works fine, but make test > returns a load of "No such file or directory errors." from DynaLoader.PM. What does the outp

RE: problems in inserting clob data using DBI Perl

Try it like this... $insertCursor->bind_param(2,$tempval); Ilya Sterin -Original Message- From: Baranitharan Santhanagopalan [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 2:33 AM To: [EMAIL PROTECTED] Subject: problems in inserting clob data using DBI Perl hello, im usi

problems in inserting clob data using DBI Perl

hello, im using DBI::VERSION 1.6 and DBD::ORACLE::VERSION 0.59 on perl 5.0005_05 under AIX. i tried to insert a data of large size into a oracle table which has field of clob data_type. i encounter error like "Error : Insert Error ORA-01461: can bind a LONG value only for insert into a LONG

Re: problems in inserting clob data using DBI Perl

- Original Message - From: Baranitharan Santhanagopalan <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 26, 2001 8:32 AM Subject: problems in inserting clob data using DBI Perl > > hello, > im using DBI::VERSION 1.6 and DBD::ORACLE::VERSION 0.59 on perl 5.0005_05 un

Re: ODBC works from command line but not from perl?

Big Brother tells me that Sterin, Ilya wrote: > Are you sure that you $dsn is getting the correct value, you might want to > print it out to see if any other value is being used. > I have printed it out as well as hardcoding it a dozen different ways. I am absolutely passing the correct DSN

Re: RH Linux 7 + Apache 1.3.19 + mod_perl 1.25

Hi Bobby, the 'perl Makefile.PL' for DBD::DB2 says 'Using DB2 in "/usr"' and 'Libraries: -L/usr/lib -ldb2'. This is the first indication that something is wrong since that's not a valid location for DB2. Makefile.PL tries to find DB2 by traversing PATH and looking for /../include/sqlcli.h. This

RE: ODBC works from command line but not from perl?

Are you sure that you $dsn is getting the correct value, you might want to print it out to see if any other value is being used. Ilya Sterin -Original Message- From: Jack McKinney [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 1:11 PM To: [EMAIL PROTECTED] Subject: ODBC works

RE: Total Environment allocation failure!

Sorry I didn't remember if you were using apache, I thought you were, but anyways it still might disrupt the server configs, etc... Usually you don't need to set up any vars since they are set in server configurations. Ilya Sterin -Original Message- From: roberto l [mailto:[EMAIL PROTEC

RE: Total Environment allocation failure!

How about not setting all the environmental vars, since that might disrupt apache configs. Ilya Sterin -Original Message- From: roberto l [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 11:41 AM Cc: [EMAIL PROTECTED] Subject: Re: Total Environment allocation failure! The scri

RE: unable to find cl.exe

This means you don't have Visual C++ installed, or the cl (compiler) is not in your path. Use PPM to install the binary version. Ilya Sterin -Original Message- From: Abel, Carl L [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 10:08 AM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTE

RH Linux 7 + Apache 1.3.19 + mod_perl 1.25

Please help my, I am really a wits end. I have read all the README, CEVEATS, and MAN files I could find, search the entire DBI and mod_perl mail-list archives, and done dozens of google searches all to no avail. I have been attempting to install DBI::DB2 on my RedHat Linux 7.0 system with no

Re: Problem with new Oracle 8.1.6 install

Hi, if you don't need the "Oracle Advanced Security" (OAS) package you may just use the "Oracle Universal Installer" to deinstall OAS. - start $ORACLE_HOME/oui/install/runInstaller.sh - click on "Deinstall Products..." - open the Folders "oracle", "Oracle8i Enterprice Edition", "Oracle8i Se

URGENT:DBD::Oracle install failure

Did anyone get this below DBD::Oracle build problem fixed on Solaris? Or any thoughts as to what may be happening is appreciated. Installed Oracle 8.1.6 & DBI -1.15. Using DBI 1.15 installed in /usr/local/perl5.6/lib/site_perl/5.6.1/sun4-solaris/auto/DBI Configuring DBD::Oracle ... >>> R

RE: Total Environment allocation failure!

This is simply a problem of permissions and environment variables. If you shell is a csh you have source'd the {DB2HOME}/sqllib/db2cshrc file that set's up all of environment variables and path's. You can cheat and just copy those things into the web server's shell or have the shell that invokes t

ODBC works from command line but not from perl?

I am trying to use ODBC on a linux box to connect to a MSSQL database running on an NT server. I have installed unixODBC, and created a DSN entry in /usr/local/etc/odbc.ini. I then run isql (which comes with unixODBC) with that DSN name, and I am able to issue SQL queries against the databa

Connect to Oracle using SID

I know this has been covered many times before but... If I try to connect to a local DB using $dbh = DBI->connect( "dbi:Oracle:sidname", $user, $pass ) ; I get the following error DBI->connect(sidname) failed: ORA-12541: TNS:no listener (DBD ER

Re: Total Environment allocation failure!

The scripts run perfect at the shell prompt. I can execute with no problem, and query the database perfectly. Current cgi directory is /cgi-bin, the user running the webserver is nobody > > Have you tried to set the variables in the shell > and run this script from there (and not as CGI)? > > As

RE: Oracle sqlload alternatives?

Hi' SQLLOAD is an Oracle utility program! It has some nice features (at least from Oracle 7.3.4) like DIRECT load where records are loaded directly into the datafiles instead of using insertion of records in tables (which requires transaction commit). This is actually a very fast method (i am

unable to find cl.exe

I'm having a problem building DBI - I am getting the error stating it is unable to find cl.exe I am using Windows NT - ActiveState (version 5.00502) Any help is appreciated. Carl Abel The following is the output requested in the Readme file for the DBI bundle. I performed a realclean prior to do

Re: Oracle sqlload alternatives?

At 8:29 -0500 26/4/01, Randy Norwood wrote: > >From what I've been able to find on this list's archives, >DBD:Oracle doesn't support this capability, or maybe it's that >Oracle sqlload is an external utility. > >Can someone shed some light on this, and suggest options for speedy >loading of da

RE: Oracle sqlload alternatives?

At 10:07 -0400 26/4/01, Simon Fan wrote: >Does the DIRECT load option activate triggers during insert? No. And it only checks integrity constraints after the load. Regards Paul Miller -- - Carib Data Limited

RE: unable to find cl.exe

with the ActiveState bundle is a tool called PPM - Perl Package Manager - I suggest that you use that to get and install the DBI, it worked for me. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: 26 April 2001 15:08 > To: [EMAIL PROTECTED]; [EMAIL PROTE

RE: Oracle sqlload alternatives?

Hi, Does the DIRECT load option activate triggers during insert? Simon -Original Message- From: Lars Eskildsen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 9:56 AM To: 'Randy Norwood'; 'DBI Users' Subject: RE: Oracle sqlload alternatives? Hi' SQLLOAD is an Oracle utility

RE: Oracle sqlload alternatives?

Perl is so good at dealing with text that there's no need for a separate loader utility. You parse the text via standard Perl or a package for specific formats (e.g., Text::CSV_XS is a good one for CSV files). Once parsed, you use DBI to insert or update database rows. Steve Sapovits Gl

Oracle sqlload alternatives?

We're trying to move some databases from MySQL to Oracle (using a DBI interface), and would like to do batch loading from ascii text files, similar to MySQL's LOAD DATA INFILE. >From what I've been able to find on this list's archives, DBD:Oracle doesn't support >this capability, or maybe it's

Re: basic stuff

Nick Chirca wrote: > @arr = $dbh->query('select * from pet'); > print "@arr\n"; > $sth = $dbh->listfields('pet'); > print "$sth\n"; > > _ > > pet > Mysql::Statement=HASH(0x80fed3c) > Mysql::Statement=HASH(0x80fee5c) Read "perldoc perlref"

Problem installing DBI 1.15 on AIX 4.3 (Perl 5.0005_03)

Hi all, I am having great difficulty in getting DBI installed on an AIX 4.3 box. Basically the Makefile.PL works great, Makefile works fine, but make test returns a load of "No such file or directory errors." from DynaLoader.PM. Details below - errors in the make test section Can anyone help

RE: Install question

The example in cheetah seems to imply that the program will execute gracefully. At this point I think this issue is probably addressed as a more general perl issue of how to uninstall/reinstall a module. Further posts along those lines will be directed to another group as it is no longer expressl

basic stuff

I've just installed the DBI and Msql-Mysql modules that I got from the www.mysql.com official perl API page, but I am having problems in working with the basic queries. See the script below: __ #! /usr/bin/perl -w use Mysql; $dbh = Mysql->connect('ads', 'test', '',

Re: Total Environment allocation failure!

roberto l wrote: > $ENV{THREADS_FLAG}=qq|native|; > $ENV{JAVA_HOME}=qq|/usr/java|; > $ENV{LANG}=qq|en_US|; > As you can see I've setup every single variable to connect, but still no > success, I'm still getting the message "Total Environment allocation > failure! Did you set up > your DB2 clien