Mike,
Look at DBI::Proxyserver. or perldoc dbiproxy.
But in short.
dbiproxy --localport=6969
> -----Original Message-----
> From: Vasquez, Mike [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 29, 2001 11:06 AM
> To: [EMAIL PROTECTED]
> Subject: RE: :OBDC
>
>
> I'll be using a Linux server running the Web Server and the
> Access DB will
> reside on another machine running a win2k server. The Linux
> box will be the
> main web server that currently uses DBD::Oracle to connect to the main
> oracle database on a different machine. The access database
> is a smaller
> database on the win2k machine.
>
> In the DBD::Proxy manual it shows that the connect string should be:
>
> $dbh=DBI->connect("dbi:Proxy:hostname=$host; port=$port;
> dsn=$mydb",
> $user, $passwd);
>
> I understand all except for the port. What port number
> should I be using in
> the connect string. Is there a default port to connect to?
>
> Mike
>
>
> -----Original Message-----
> From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 27, 2001 4:46 PM
> To: Vasquez, Mike; [EMAIL PROTECTED]
> Subject: RE: :OBDC
>
>
> Well depends on what machine you application will reside. We
> need more
> info.
> If win32 machine, then just use ODBC to create a DSN to the
> remote Access
> db, if Unix/Linux type, then you need to either use DBD::Proxy and
> DBD::ProxyServer or you can use a third party ODBC driver.
>
> Ilya Sterin
>
> -----Original Message-----
> From: Vasquez, Mike [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 27, 2001 6:54 PM
> To: '[EMAIL PROTECTED]'
> Subject: DBD::OBDC
>
>
> I want to be able to access an Access db that resides on
> another machine.
> Can I access this small database using DBD::OBDC. If so, how
> and where do I
> set up the following:
>
> DBI_DSN The dbi data source, e.g.
> 'dbi:ODBC:YOUR_DSN_HERE' DBI_USER
>
> DBI_USER
> DBI_PASS
> ODBCHOME
>
> The DBI_USER and DBI_PASS I understand. I'm not sure about
> the DBI_DSN.
> How would one set this variable?
>
> Mike (a newbie)
>
__________________________________________________________________________
Please Note :
Only the intended recipient is authorised to access or use this e-mail. If
you are not the intended recipient,
please delete this e-mail and notify the sender immediately. The contents
of this e-mail are the writer's
opinion and are not necessarily endorsed by the Gunz Companies unless
expressly stated.
We use virus scanning software but exclude all liability for viruses or
similar in any attachment.
