Heya! I'm forced to use an Access database within my project, and am attempting to use DBI::ODBC to connect to my Access file (users.mdb). However, i cannot seem to find sufficient data to learn this procedure outside of the perldoc functions, this is what i have so far...
my $dsn = "DBI:ODBC:driver=Microsoft Access;dbq=users.mdb";
my $dbh = DBI->connect($dsn,'','') or die "Cannot Connect to Server";
However, this doesn't connect, it says it "cannot connect to server". Could anybody point me in the direction of any good DBI::ODBC tutorials ?
Any help is appreciated, thank you!
BazB added code tags.