Avatar of sosolala
sosolala
 asked on

On windows Access.mdb ->ODBC -> DBI->Proxy::Linux DBI<-Proxy<-Query<-Failed!

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:hostname=localhost;port=1522;dsn=dbi:ODBC:thedatabase','','',{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.
Perl

Avatar of undefined
Last Comment
SpideyMod

8/22/2022 - Mon
sosolala

ASKER
Proxy window display the following.....

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/PlServer/Comm.pm line 145
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.pm line 63.
DBI connect('hostname=192.168.10.10;port=1522;dsn=dbi:ODBC:somedb','',...) failed: Cannot log in to DBI::ProxyServer: Unexpected EOF from server at /usr/share/perl5/RPC/PlClient.pm line 83.
 at ./testdatabasecon line 15

ASKER CERTIFIED SOLUTION
SpideyMod

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Your help has saved me hundreds of hours of internet surfing.
fblack61