> > > Hi, > > Why do I need to supply user name and password with DBI->connect() if I am > using DBD:ODBC? This information is already supplied in the DSN? > > my $DSN="dbi:ODBC:sqlserver_dsn"; > my $DBI_USER="Why do I need this?" > my $DBI_PASS="Why do I need this?" > > $dbh=DBI->connect($DSN,$DBI_USER,$DBI_PASS);
Err -- you don't -- I don't think -- at least I don't need to, here. But my SQL Server is configured for NT authentication. what happens when you just $dbh=DBI->connect($DSN);? Jeff
