troubleshooting Question

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

Avatar of sosolala
sosolala asked on
Perl
2 Comments1 Solution451 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
SpideyMod

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros