data_source syntax

[Robert Denton]

Question:

While connecting to a MSsql database, do you need to pass the uid and  
pwd in the $data_source string as well as in the parameter list for  
the connect call?  For example, are either of these correct:

#~~~ this:

my $data_source = 'driver={SQL Server};Server=<192.168.0.149>;  
database=<userFeedback>;uid=<testUser>; pwd=<testPass>;';
my $username = 'testUser';
my $password = 'testPass';

$dbh = DBI->connect( $data_source, $username, $password );

#~~~ or this:

my $data_source = 'driver={SQL Server};Server=<192.168.0.149>;  
database=<userFeedback>;';
my $username = 'testUser';
my $password = 'testPass';

$dbh = DBI->connect( $data_source, $username, $password );


Thanks!
Robert