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

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.

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:

$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";