HI,
Using DBI you can connect the database.
1. first you create user dsn and connect your access database.
2. Download DBI module and install the module
3. Use the below code and connece the access databse
use DBI;
use strict;
my $dbh = DBI->connect('DBI:ODBC:test','','') or die "Cannot connect: $DBI::errstr\n";
my $sth1 = $dbh->prepare('Select * from test');
regards
dhascruz
I think this is only for local mdb file.
I have tried to create a data source, but Host, server, serverport doesn't work.
Maybe not, it says: Can't alloc filename
Say: My mdb file is on D:\mdb\B2000.mdb from the remote machine.
And I use: Host = server ip
database = d:\mdb\B2000.mdb
Error:Unable to locate database d:\mdb\B2000.mdb
If I made database = http://serverip/mdb/B200.mdb ( I set the virtual directory named mdb from IIS)
Error:Unable to locate database http://128.128.108.110/mdb/B2000.mdb