On Sep 19, 5:45 am, [EMAIL PROTECTED] wrote:
> --- 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.
But I search "connect remote ms access database" from google.
I get these results:
http://www.google.com/search?q=connect+remote+ms+access+database%22&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a
How can you access it from remote host via connecting to its
> non-exist port?
Sorry, can you tell me how to set port for ms access database?
I have no idea about this.
> You can check the document for
> DBD::ODBC,http://search.cpan.org/~mjevans/DBD-ODBC-1.14/ODBC.pm
>
Thanks a lot.
> --
> 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/
