--- herostar1981 <[EMAIL PROTECTED]> wrote:
> 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?
AFAIK,MS Access is a local file-based database,which doesn't have ports
listening.How can you access it from remote host via connecting to its
non-exist port?
You can check the document for DBD::ODBC,
http://search.cpan.org/~mjevans/DBD-ODBC-1.14/ODBC.pm
--
Jeff Pang
____________________________________________________________________________________
Feel safe with award winning spam protection on Yahoo!7 Mail.
www.yahoo.com.au/mail
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/
