Yup tht was the prob....
Thanks for pointing it out :-)
----- Original Message -----
From: "Michael Glaesemann" <[EMAIL PROTECTED]>
To: "Gayatri" <[EMAIL PROTECTED]>
Cc: "S, karthik (IE03x)" <[EMAIL PROTECTED]>; <beginners@perl.org>
Sent: Friday, November 18, 2005 3:41 PM
Subject: Re: Query on databases
>
> On Nov 18, 2005, at 18:56 , Gayatri wrote:
>
> > $host = "nnn.nn.nnn.nn"; ## 'n' is a number, host is ip address.
> > $databaseName = "MyDatabase";
> > $dbh = DBI->connect('DBI:mysql:database=$databaseName;host=$host',
> > $userName,
> > $password, {RaiseError => 1}) || die "Can not connect to database
> > $DBI::errstr";
>
> I think you need to use double-quotes if you want the $database,
> $host, $userName, and $password variables to interpolate.
>
> > Is this a correct way of doing? Bcoz im getting following err. Is
> > it ok if I
> > mention host ip address, Pls let me know if thr are any other
> > criterias
> >
> > DBI connect('database=$databaseName;host=
> > $host','ValidUserName',...) failed:
> > Unknown MySQL server host '$host' (11001) at D:\Gayatri\database.pl
> > line 6
>
> Looking at the error, you can see that it's looking for a host $host,
> not nnn.nn.nnn.nn.
>
> Also, please use vowels and proper capitalization, and don't
> abbreviate your words. It makes your message more difficult to read
> for the people who may want to help you. Code can be hard enough to
> decipher :)
>
> Michael Glaesemann
> grzm myrealbox com
>
>
>
>
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
