Sorry if this double posts..
So I changed like you said, however fixing some quoting issues..
my $dbh = DBI->connect("DBI:ODBC:driver={SQL Server};","SERVER=Bobs.pa
+ncake.hut;DATABASE=flapjacks;","account","password");
I got the following errors:
DBI->connect using 'old-style' syntax is deprecated and will be an err
+or in futu
re versions at C:\temp\temp.pl line 14
install_driver(password) failed: Can't locate DBD/password.pm in @INC
+(@INC cont
ains: C:/Perl/site/lib C:/Perl/lib .) at (eval 4) line 3.
Perhaps the DBD::password perl module hasn't been fully installed,
or perhaps the capitalisation of 'password' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, ODBC, Proxy, SQLite, Sp
+onge.
at C:\temp\temp.pl line 14