If you really need to log into Access remotely, check out DBD::Proxy on CPAN.
Ted > -----Original Message----- > From: Jeff Urlwin [mailto:[EMAIL PROTECTED] > Sent: Monday, October 24, 2005 12:22 PM > To: [EMAIL PROTECTED]; dbi-users@perl.org > Subject: RE: Remote Login, using dbi:ODBC > > > This really isn't a perl/dbi issue. If it's an MS access > database, you > need to be able to access the MDB file itself. Thus, there is no > server/port, etc. > > Jeff > > > -----Original Message----- > From: Richard [mailto:[EMAIL PROTECTED] > Sent: Sunday, October 23, 2005 2:33 AM > To: dbi-users@perl.org > Subject: Remote Login, using dbi:ODBC > Importance: High > > I login to my remote mysql databases, using perl, this way: > > > > > > > > sub ConnectToDB > > { > > my $host_name = "01.002.003.04";# Ip Address Here > > my $db_name = "DataBaseName"; # Database Name to > connect to > > my $dsn = "DBI:mysql:host=$host_name;database=$db_name"; > > return (DBI->connect ($dsn, "usernameHere", > "PasswordHere", > > > {PrintError => 0, RaiseError => 1})); > > } > > > > So, to connect to a Remote Access Database, can I use this: > > > > > > sub ConnectToDB > > { > > my $host_name = "002.003.004.05"; > > my $db_name = "DBName"; > > my $dsn = > "dbi:ODBC:Clients:host=$host_name;database=$db_name"; > > return (DBI->connect ($dsn, "UserNameHere", > "PassWordHere")); # > Clients being the name I set in the Windows Data Sources (ODBC) > > } > > > > > > Is that how I would connect to this database? > > > > I would appreciate any help you could give me. > > > > Thanks! > > Richard > > > >
