I would have to look at the module (not before next week).
I was surprised, too, that it was readily available at ActiveState FOR
Windows.
Stefan
-----Urspr=FCngliche Nachricht-----
Von: Jared Still [mailto:jkstill_at_cybcon.com]
Gesendet: Thursday, February 19, 2004 4:48 PM
An: Oracle-L Freelists
Betreff: Re: AW: AW: Oracle 10g for Windows
Interesting.
Any idea how Net::Daemon was made to work on Windows?
Jared
On Thu, 2004-02-19 at 01:32, Stefan Jahnke wrote:
> Hi myself
>=20
> To answer my own question (maybe somebody else might use that, too):
>=20
> Getting DBI 1.40 from CPAN plus the DBI::Proxy related modules =3D
> (Storable (I
> got 2.07), PlRPC and Net::Daemon and compiling them on cygwin (Perl =
=3D
> 5.8.2)
> works.
>=20
> Get and install ActiveState Perl 5.8.3 (build 809) for Windows.
>=20
> Then download the DBI 1.40 plus DBD Oracle module for ActiveState =
5.8.2 =3D
> from
> http://www.cedet.dk/perl/.
> Install all the modules using ppm3.
>=20
> Start the dbiproxy server on windows, using a config file like this:
>=20
> {
> 'localport' =3D3D> 3333,
> 'pidfile' =3D3D> 'c:\perl\etc\dbiproxy.pid',
> 'logfile' =3D3D> 1,
> 'debug' =3D3D> 1,
> 'mode' =3D3D> 'single',
> 'timeout' =3D3D> 60
> }
>=20
> Try using the proxy from cygwin with a script like this:
>=20
> use DBI;
> use Data::Dumper;
>=20
> my ($dbh, $sth, $row);
>=20
> $user=3D3D"myuser";
> $pwd=3D3D"mypwd";
> $dsn=3D3D"dbi:Oracle:host=3D3Dlocalhost;sid=3D3Dmysid";
>=20
> $dbh =3D3D
> =
DBI->connect("dbi:Proxy:hostname=3D3D127.0.0.1;port=3D3D3333;dsn=3D3D$ds=
n",$us=3D
> er,$pwd,{R
> aiseError =3D3D> 1, PrintError =3D3D>1}) or die$DBI::errstr;
> print "Connected ...\n";
>=20
> $sth =3D3D $dbh->prepare('select * from subject where id < 5');
> $sth->execute;
>=20
> while ($row =3D3D $sth->fetchrow_hashref)
> {
> print Dumper($row);
> }
>=20
> $sth->finish;
> $dbh->disconnect;
>=20
> I had trouble first with the set username and the disconnect methods, =
=3D
> but as
> soon as both dbi version were 1.40, everything worked.=3D20
>=20
> Whoever is interested: Perl Tk800.025 (from CPAN) also works on =
cygwin. =3D
> That
> plus a multiwindow XFree config makes you almost feel like /home ;).
>=20
> Stefan
>=20
> -----Urspr=3DFCngliche Nachricht-----
> Von: Stefan Jahnke=3D20
> Gesendet: Wednesday, February 18, 2004 1:14 PM
> An: 'oracle-l_at_freelists.org'
> Betreff: AW: AW: Oracle 10g for Windows
>=20
>=20
> Hi
>=20
> If Net::Daemon doesn't work on windows, I'm actually wondering about =
=3D
> =3D3D
> how to
> get dbiproxy to work on windows anyway.
> In O'Reilly's DBI programming, the author suggests a setup for =3D3D
> connecting to
> a DB running on Windows via Proxy from=3D3D20
> a UNIX machine. Totally doesn't work for me.
>=20
> Did anybody ever get this to work? Or am I on the wrong list for =
=3D3D
> questions
> like this?
>=20
> Stefan
>=20
> -----Urspr=3D3DFCngliche Nachricht-----
> Von: Jared.Still_at_radisys.com [mailto:Jared.Still_at_radisys.com]
> Gesendet: Tuesday, February 17, 2004 8:15 PM
> An: oracle-l_at_freelists.org
> Betreff: Re: AW: Oracle 10g for Windows
>=20
>=20
> I don't believe that Net::Daemon will work under Windoze.
> The only daemons I have personally created have been
> via Dave Roth's Win32::Daemon.
>=20
> These are daemons on that interact with services.exe.
>=20
> It may be possible to subvert HTTP::Daemon for use as Net::Daemon,
> but I really don't know.
>=20
> When I need to interact with something on a Windows system, I tend
> to do it with this checklist in mind:
>=20
> * should this be done in Perl?
> * if so, can I do it from a linux box?
> * darn, looks like this has to be done from the server.
>=20
> If it has to be done on the server, and Perl is the tool of choice, I =
=3D
> =3D3D
> try
> to minimize the number of components.
>=20
> ie. I don't want to rely on Cygwin.
>=20
> I will install Perl, and the modules needed to do the job.
>=20
> I've don't try to setup the Cygwin Perl to use DBD::Oracle, etc.
>=20
> Instead, I just use the Active State perl when in a Cygwin shell,
> which I only do from my laptop.
...
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
=20
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Thu Feb 19 2004 - 10:57:19 CST
