Re: is this a viable option?

2012-10-02 Thread Martin Hall
If there's a database link between the two databases, you could connect to database A from Perl and execute a query against B over the DBLink without doing a Perl connect to B. On 01/10/2012 18:29, Jack Craig wrote: Hi Folks, I have an html / perl app running on host A, i want to do a

Re: is this a viable option?

2012-10-01 Thread Jon
Hello Jack, If I'm understanding you correctly, you want to run a perl app on your webserver and have it connect to your database server? What's wrong with setting the host name/ip if your DB server in the DSN? e.g.: my $dsn = dbi:*SQL Platform*:*database_name*:*host_name*:*port * Am I maybe

Re: is this a viable option?

2012-10-01 Thread Martin J. Evans
On 01/10/2012 18:29, Jack Craig wrote: Hi Folks, I have an html / perl app running on host A, i want to do a remote oracle query on host B from host A. Assuming proper credentials, is this a viable configuration? This as opposed to running perl dbi module installed on host B. TIA, jackc...