Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2003-02-27
2
Medium Priority
?
411 Views
Last Modified: 2008-02-01
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.
0
Comment
Question by:sosolala
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 1

Author Comment

by:sosolala
ID: 8037394
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

0
 

Accepted Solution

by:
SpideyMod earned 0 total points
ID: 8147602
PAQ'd and points refunded.

SpideyMod
Community Support Moderator @Experts Exchange
0

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many time we need to work with multiple files all together. If its windows system then we can use some GUI based editor to accomplish our task. But what if you are on putty or have only CLI(Command Line Interface) as an option to  edit your files. I…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
Six Sigma Control Plans

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question