RE: Remote Login, using dbi:ODBC
- From: ted.behling@xxxxxxxxxxxxxxx (Ted Behling)
- Date: Tue, 25 Oct 2005 09:43:32 -0400
If you really need to log into Access remotely, check out DBD::Proxy on CPAN.
Ted
> -----Original Message-----
> From: Jeff Urlwin [mailto:jurlwin@xxxxxxxxxxxx]
> Sent: Monday, October 24, 2005 12:22 PM
> To: richard@xxxxxxxxxx; dbi-users@xxxxxxxx
> 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:rjones@xxxxxxxxxx]
> Sent: Sunday, October 23, 2005 2:33 AM
> To: dbi-users@xxxxxxxx
> 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
>
>
>
>
.
- Prev by Date: Re: ANNOUNCE: MySQL 5.0 now final/stable/GA
- Next by Date: RE: Newline inserted?
- Previous by thread: RE: Remote Login, using dbi:ODBC
- Next by thread: RE: Newline inserted?
- Index(es):
Relevant Pages
|
