Hi all,
I am meeting a big problem.
I try to use Perl to connect MS Access database from a remote
machine .
But I can not find a good way.
I want use the DSN-less way.
I search it from google, and get this example:
use DBI;
$dbh = DBI->connect('dbi:ODBC:driver=Microsoft Access Driver
(*.mdb);dbq=f:\db1.mdb');
My question is how to setup the host name or port number?
Like this:
$dbh = DBI->connect('dbi:ODBC:driver=Microsoft Access Driver
(*.mdb);ServerPort:128.128.110.110;dbq=f:\db1.mdb');
, right?
or replace ServerPort with HOST?
All of them do not work.
And if I make the "dbq" value as a .mdb file from local machine.
It queries records from the local file without connect remote machine.
I am tired about this. Maybe I can try make DSN, but I am afraid it
can not connect a remote machine.
Does anybody have a solution?
Help me!
Best Regards,
Xu
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/
