Re: DBD::Oracle Installation problem

2005-04-27 Thread Christian Merz
Hello Sangeeth, the problem is a 32/64 bit mismatch of your perl (32bit) and your oracle (64bit) libs: 'wrong ELF class'. our system group fixed this problem by: * before running perl Makefile.PL * edit your file $ORACLE_HOME/rdbms/lib/env_rdbms.mk * by changing LIBDIR=lib to LIBDIR=lib32 *

Re: load_dbnames() function - DBD::Oracle

2005-04-27 Thread Tim
Patches welcome. Tim. On Tue, Apr 26, 2005 at 10:27:10AM -0500, Mark S. Davis wrote: The load_dbnames() function does not handle tnsnames.ora files properly. It scans _the_ file looking for leading edge database connection names, but it doesn't honor the ifile directive. The ifile

Need Help to install DBD-Oracle on Windows 2000

2005-04-27 Thread Wang, Weili
Hi, I have downloaded DBD-Oracle DBD-Oracle9-1.16-5.8.4.tar.gz from ftp.esoftmatic.com ftp://ftp.esoftmatic.com/ website and unzipped it. Could you tell me how to install DBD-Oracle on Windows 2000 system? Thanks, Weili Wang

Oracle ref cursors - documentation patch.

2005-04-27 Thread Charles Jardine
Here is a patch to the pod documentation of DBD::Oracle-1.16. The patch alters the section headed 'Binding Cursors'. The patch: * corrects an error. When passing a cursor back from Perl to PL/SQL, bind_param_inout _must not_ be used. * attempts to clear up a misunderstanding. It is not

Re: DBD::Oracle Installation problem

2005-04-27 Thread PerlDiscuss - Perl Newsgroups and mailing lists
Christian, Thanks for the support. I was able to resolve my error as per your instructions. I also got other errors due to improper settings of some environment variables. I resolved those after going through a very good DBD::Oracle installation guide at

Re: Need Help to install DBD-Oracle on Windows 2000

2005-04-27 Thread Michael A Chase
On 04/26/2005 03:39 PM, Wang, Weili said: I have downloaded DBD-Oracle DBD-Oracle9-1.16-5.8.4.tar.gz from ftp.esoftmatic.com ftp://ftp.esoftmatic.com/ website and unzipped it. Could you tell me how to install DBD-Oracle on Windows 2000 system? Did you read the instructions in

Re: Oracle ref cursors - documentation patch.

2005-04-27 Thread Michael A Chase
On 04/27/2005 03:01 AM, Charles Jardine said: Here is a patch to the pod documentation of DBD::Oracle-1.16. The patch alters the section headed 'Binding Cursors'. diff -ur DBD-Oracle-1.16.cursor-docs/Oracle.pm DBD-Oracle-1.16/Oracle.pm Your diff has the source files reversed. Thank you for the

cPanel / DBI / mySQL / Exim issue

2005-04-27 Thread webmaster
I have recently come across a problem with cPanel/Fedora and DBI. After a recent update of cpanel the exim stats script stopped working, and produces the following error: Starting eximstats: DBI connect('eximstats:localhost','eximstats',...) failed: Client does not support authentication protocol

DBD::Sybase returns blank character instead of empty string

2005-04-27 Thread Rainer J. H. Brandt
Hi, I have stored en empty string in a varchar(255) column of a Sybase ASE. When I retrieve it via $r = $dbh-selectall_arrayref(select Value from Example where Id = 17); then the following is true: $r-[0]-[0] eq ' ' I expected it to be false and instead $r-[0]-[0] eq '' (with an empty

Re: Oracle ref cursors - documentation patch.

2005-04-27 Thread Charles Jardine
Michael A Chase wrote, on 27/04/2005 13:42: On 04/27/2005 03:01 AM, Charles Jardine said: Here is a patch to the pod documentation of DBD::Oracle-1.16. The patch alters the section headed 'Binding Cursors'. diff -ur DBD-Oracle-1.16.cursor-docs/Oracle.pm DBD-Oracle-1.16/Oracle.pm Your diff has

Re: cPanel / DBI / mySQL / Exim issue

2005-04-27 Thread JupiterHost.Net
After that did not work, they directed me to your list, in the hopes you could give me some assistance with how to resolve this. Any help you can offer is much appreicated. Er, you may want to not show your passwords on a public list... They were right, its not a cPanel issue. Have you upgraded

Re: DBD::Sybase returns blank character instead of empty string

2005-04-27 Thread Rainer J. H. Brandt
Hello again, I apologize for my previous email, which was both partially wrong and also premature -- rtfm would have helped. I had written: Notice: The Database really has an empty string, not a NULL value or any other weird thing. And in fact, Sybase had really stored a string consisting

RE: Need Help to install DBD-Oracle on Windows 2000

2005-04-27 Thread Wang, Weili
Thanks, Michael. I did read the instructions in http://ftp.esoftmatic.com/DBI/ and have tried to run ppm install ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.3/DBD-Oracle.ppd, actually ppm install http://24.249.249.7/outgoing/DBI/5.8.3/DBD-Oracle.ppd from my \perl\bin and got the following errors:

RE: Need Help to install DBD-Oracle on Windows 2000

2005-04-27 Thread Reidy, Ron
From google: http://www.issociate.de/board/post/162946/DBD::Oracle.html - Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Wang, Weili [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 9:34 AM To: Michael A Chase Cc: dbi-users@perl.org Subject:

Re: DBD::Sybase returns blank character instead of empty string

2005-04-27 Thread Terence J. Young, D.C.
Hi, Actually, when storing an empty string, '', to a varchar, sybase stores it as a space. Some apps provide a setting to strip trailing spaces. terry Rainer J. H. Brandt wrote: Hi, I have stored en empty string in a varchar(255) column of a Sybase ASE. When I retrieve it via $r =

RE: Efficient select/insert

2005-04-27 Thread mark.d.andrews
Is there a reason you need to make the round trip from the database, through your program, and then back to the database? If not then just do an insert select: my $sql = insert into table2 select null, col2, col3, col4 from table1 where col1 = ?; $dbh-do($sql); -Original Message- From:

Re: cPanel / DBI / mySQL / Exim issue

2005-04-27 Thread Rudy Lippan
On Wed, 27 Apr 2005 [EMAIL PROTECTED] wrote: vie DBI it does not: # perl -MDBI -e 'DBI-connect(DBI:mysql:eximstats:localhost,eximstats,IOcgBuMJ) or die DBI-errstr;' DBI connect('eximstats:localhost','eximstats',...) failed: Client does not support authentication protocol requested by

RE: Can't locate DBI.pm

2005-04-27 Thread Michael Nhan
Hi, Can you compile by setting the CC flag to gcc, ie: make CC=gcc If this works and you don't get errors, then all is well. If you get errors complaining about KPIC and other forte CC options, you will either have to modify the makefile (not fun). Or start over by compiling your own

RE: Can't locate DBI.pm

2005-04-27 Thread Reidy, Ron
1. Which C compiler was your Perl built with (perl -V)? 2. Do you have that C compiler on your system (which cc OR which (name of C compiler from #1 above)? If not, you will need to fix this situation by: a. Install the C compiler used to build your Perl and then try to install DBI and

RE: Can't locate DBI.pm

2005-04-27 Thread Chekuri, Lalitha
Hi ron, thanks for your input. When I try to install, it is saying cc is not there. Then I started installed gcc3.3 from gcc site. Now to install that also it is saying cc is not there.. what is going on Can you please help...Lalitha -Original Message- From: Reidy, Ron [mailto:[EMAIL

RE: Can't locate DBI.pm

2005-04-27 Thread Reidy, Ron
It looks like you have installed a binary version of perl. Since it also looks like you misunderstood my last email, you will find which C compiler your perl was built with by executing perl -V, not perl -v. It also looks like you do not have the Sun C compiler installed. You should really

Re: cPanel / DBI / mySQL / Exim issue

2005-04-27 Thread Ron Savage
On Wed, 27 Apr 2005 10:06:24 -0400, [EMAIL PROTECTED] wrote: Hi Search this page http://savage.net.au/Perl/html/upgrade-mysql.html for old_password. -- Cheers Ron Savage, [EMAIL PROTECTED] on 28/04/2005 http://savage.net.au/index.html Let the record show: Microsoft is not an Australian

Re: Can't locate DBI.pm

2005-04-27 Thread Michael A Chase
On 04/27/2005 01:13 PM, Reidy, Ron said: b. Install gcc properly (**AND** you will need to downgrade from the 3.x version to 2.96 as described in the Oracle installation manuals) Where did you see this? The advice is several years out of date. I've used a couple different gcc 3.x versions to

DBD::mysql 2.9007 and DBD::mysql 2.9015_3 (beta) released

2005-04-27 Thread Patrick Galbraith
Dear DBI/DBD::mysql developers, DBD::mysql 2.9007 and 2.9015_3 are now available via CPAN! * DBD::mysql 2.9007 is the production release and is available as the default version using CPAN shell, or if you go to the CPAN site and look up DBD::mysql by module. * DBD::mysql 2.9015_3 is a beta