Perl

Perl RSS

Warning message: 'old-style' syntax

Thread Solved

•

Join Date: May 2008

Posts: 30

Reputation: punitdam is an unknown quantity at this point

Solved Threads: 3

punitdam

Offline

Light Poster

Warning message: 'old-style' syntax

Apr 4th, 2009

I am trying to connect Mysql5.1 from Perl 5.8.8 on RHEL5 as follows:

 Help with Code Tags 
 Perl Syntax (Toggle Plain Text) 
$dsn="DBI:mysql:database=mysql";
$dbh=DBI->connect($dsn, 'root', 'root', 'mysql',{RaiseError => 1});
$dsn="DBI:mysql:database=mysql";
$dbh=DBI->connect($dsn, 'root', 'root', 'mysql',{RaiseError => 1});

When I try to run perl containing above connection, it gets connected to Mysql and fetches data but displays following warning.

•

DBI->connect using 'old-style' syntax is deprecated and will be an error in future versions

What can be done to remove this warning?

Thanks and Regards

•

Join Date: Mar 2006

Posts: 898

Reputation: KevinADC has a spectacular aura about

Solved Threads: 67

KevinADC

Offline

Practically a Posting Shark

Re: Warning message: 'old-style' syntax

Apr 4th, 2009

I don't know, you can try www.perlmonks.com or ask on the dbi modules mailing list (see the DBI module for details)

•

Join Date: Dec 2004

Posts: 2,413

Reputation: Comatose is a jewel in the rough

Solved Threads: 211

Comatose

Offline

Taboo Programmer

Re: Warning message: 'old-style' syntax

Apr 4th, 2009

You need to remove the 'mysql' parameter from connect. Should look something like this:

 Help with Code Tags 
 perl Syntax (Toggle Plain Text) 
use DBI;
 
$dsn="DBI:mysql:database=mysql";
$dbh=DBI->connect($dsn, 'root', 'root', {RaiseError => 1});
use DBI;

$dsn="DBI:mysql:database=mysql";
$dbh=DBI->connect($dsn, 'root', 'root', {RaiseError => 1});

•

Join Date: Jun 2008

Posts: 147

Reputation: GDICommander is an unknown quantity at this point

Solved Threads: 19

GDICommander GDICommander is offline

Offline

Junior Poster

Re: Warning message: 'old-style' syntax

Apr 5th, 2009

You can do this:

no warnings ;
no warnings 'all' ;

•

Join Date: May 2008

Posts: 30

Reputation: punitdam is an unknown quantity at this point

Solved Threads: 3

punitdam

Offline

Light Poster

Re: Warning message: 'old-style' syntax

Apr 6th, 2009

•

Originally Posted by Comatose

You need to remove the 'mysql' parameter from connect. Should look something like this:
Help with Code Tags

perl Syntax (Toggle Plain Text)
use DBI;
 
$dsn="DBI:mysql:database=mysql";
$dbh=DBI->connect($dsn, 'root', 'root', {RaiseError => 1});
use DBI; $dsn="DBI:mysql:database=mysql"; $dbh=DBI->connect($dsn, 'root', 'root', {RaiseError => 1});

Thanks it is working fine now.