Mysql error

jain236

Hi all i am new to the DBI .
when i am trying to connect to mysql using perl script i am getting the following error

Can't connect to data source '$dsn' because I can't work out what driver to use (it doesn't seem to contain a 'dbi:driver:' prefix and the DBI_DRIVER env var is not set)
here is the way i am tryng to connect

Expand|Select|Wrap|Line Numbers

 
use strict;
 
use DBI;

use DBD::mysql;
 
my $drh = DBI->install_driver("mysql");
 
 my $dsn = 'DBI:mysql:my_database:localhost';

 my $dbh = DBI->connect('$dsn', 'root', '12345678',);

eWish

Here is what I use for a default connection.

Expand|Select|Wrap|Line Numbers

 my %config_vars = (DBServerName  => 'localhost',

                    DBName                => 'xxxx',

                    DBUserName         => 'xxxx',

                    DBPassword         => 'xxxx',

                    );
 
my ($dbh, $data_source);

my $dataSource = 'DBI:mysql:' . $config_vars{DBName} . ':' . $config_vars{DBServerName};

   $dbh = DBI->connect( $dataSource, $config_vars{DBUserName}, $config_vars{DBPassword}, {RaiseError=>1});

--Kevin

nithinpes

I use connect() method as below:

Expand|Select|Wrap|Line Numbers

 
$dsn = 'my_database';

$host= 'localhost';

my $dbh = DBI->connect( "dbi:mysql:database=$dsn;host=$host",'root','password') or die "Can't connect to mysql database: $DBI::errstr\n";

Mysql error

Post your reply

Similar topics