You've got the connection string and DSN definition confused.
For a DSN-less connection use something like:
my $DSN = 'driver={SQL Server};
Server=.;database=vision;
uid=sa;pwd=secret;';
my $dbh = DBI->connect("dbi:ODBC:$DSN") or die "$DBI::errstr\n";
--
Simon Oliver
Hi,
When I tried to run the perl program, I got the following error. Could
anyone give me a help?
I tried to use the control pane, then ODBC and built a system DSN, the
connection works ok.
Thanks
Jenny
DBI->connect(driver={SQL
Server};Server=.;database=vision;uid=sa;pwd=;QuotedID=no) failed: