• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 419
  • Last Modified:

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');
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:

and I have cygwin installed which could contribute to the
1 Solution
sosolalaAuthor Commented:
Proxy window display the following.....

Thu Feb 27 23:18:41 2003 debug, Accepting client from, 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=;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

PAQ'd and points refunded.

Community Support Moderator @Experts Exchange
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now