Hi all,
Have a access.mdb that needs to be connect via odbc to a
linux machine so on the linux machine I can run queries
on windows I have installed the following:
Activestate 5.6.x of perl
ppm install DBI
ppm install DBD-ODBC
ppm install Net-Daemon
ppm install PlRPC
I have setup the proxy serverscript
and when I run the following script
use DBI;
use Data::Dumper;
my ($dbh, $sth, $row);
$dbh = DBI->connect('dbi:Proxy:ho
stname=loc
alhost;por
t=1522;dsn
=dbi:ODBC:
thedatabas
e','','',{
RaiseError
=> 1, PrintError =>1})
or die $DBI::errstr;
$sth = $dbh->prepare('select * from focuslist');
$sth->execute;
while ($row = $sth->fetchrow_hashref)
{
print Dumper($row);
}
this all works :-)
then I have setup the linux machine
the linux machine is using perl 5.8.x
but now when I run this script from linux
it fails because the perl version of is blix 2.5 and this dbi proxy server on windows is failing because it uses 2.4
:-((( (The quites with proxy server error _EOF)
The problem is how can I solve this?
Is there an other methode of connecting without going to
DBI->proxy? (maybe directly)
upgrading the perl on the windows to perl 5.8.x
I could do but then the package PlRPC is missing from the
new ppm :-(( and according to active state modules page
it faild to compile on windows platform.
Once again the connecting with this script from localhost
going thrue the proxy works.
ps. this is the manual I have followed:
http://www.awilcox.com/geek_stuff/perl/proxy.html
and I have cygwin installed which could contribute to the
solution.
Thu Feb 27 23:18:41 2003 debug, Accepting client from 192.168.10.3, port 1051
Thu Feb 27 23:18:41 2003 err, Child died: Storable binary image v2.5 more recent
than I am (v2.4) at blib\lib\Storable.pm (autosplit into blib\lib\auto\Storable
\thaw.al) line 340, at D:/Perl/site/lib/RPC/PlSer
Thu Feb 27 23:18:41 2003 debug, Child terminating.
and linux
Argument " " isn't numeric in repeat (x) at /usr/lib/perl5/DBD/Proxy.p
DBI connect('hostname=192.168.
at ./testdatabasecon line 15