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

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 rele

Re: Can't locate DBI.pm

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 bu

Re: cPanel / DBI / mySQL / Exim issue

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 compan

RE: Can't locate DBI.pm

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 t

RE: Can't locate DBI.pm

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 PRO

RE: Can't locate DBI.pm

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 DBD::

RE: Can't locate DBI.pm

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 p

Re: cPanel / DBI / mySQL / Exim issue

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 req

RE: Efficient select/insert

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: DBD::Sybase returns blank character instead of empty string

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 = $dbh->selecta

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

>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: Need Help to install DBD-Oracle on Windows 2000

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: E

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

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: cPanel / DBI / mySQL / Exim issue

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 My

Re: Oracle ref cursors - documentation patch.

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 t

DBD::Sybase returns blank character instead of empty string

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

cPanel / DBI / mySQL / Exim issue

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

Re: Oracle ref cursors - documentation patch.

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 re

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

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 website and unzipped it. Could you tell me how to install DBD-Oracle on Windows 2000 system? Did you read the instructions in http://ftp.esoftmat

Re: DBD::Oracle Installation problem

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 http://www.nntp.perl.org/group/perl.dbi.

Oracle ref cursors - documentation patch.

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 norm

Need Help to install DBD-Oracle on Windows 2000

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

Re: load_dbnames() function - DBD::Oracle

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 ifi