Re: AW: AW: Oracle 10g for Windows
- From: Jared Still <jkstill@xxxxxxxxxx>
- To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 19 Feb 2004 07:47:46 -0800
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
>
> To answer my own question (maybe somebody else might use that, too):
>
> Getting DBI 1.40 from CPAN plus the DBI::Proxy related modules =
> (Storable (I
> got 2.07), PlRPC and Net::Daemon and compiling them on cygwin (Perl =
> 5.8.2)
> works.
>
> Get and install ActiveState Perl 5.8.3 (build 809) for Windows.
>
> Then download the DBI 1.40 plus DBD Oracle module for ActiveState 5.8.2 =
> from
> http://www.cedet.dk/perl/.
> Install all the modules using ppm3.
>
> Start the dbiproxy server on windows, using a config file like this:
>
> {
> 'localport' =3D> 3333,
> 'pidfile' =3D> 'c:\perl\etc\dbiproxy.pid',
> 'logfile' =3D> 1,
> 'debug' =3D> 1,
> 'mode' =3D> 'single',
> 'timeout' =3D> 60
> }
>
> Try using the proxy from cygwin with a script like this:
>
> use DBI;
> use Data::Dumper;
>
> my ($dbh, $sth, $row);
>
> $user=3D"myuser";
> $pwd=3D"mypwd";
> $dsn=3D"dbi:Oracle:host=3Dlocalhost;sid=3Dmysid";
>
> $dbh =3D
> DBI->connect("dbi:Proxy:hostname=3D127.0.0.1;port=3D3333;dsn=3D$dsn",$us=
> er,$pwd,{R
> aiseError =3D> 1, PrintError =3D>1}) or die$DBI::errstr;
> print "Connected ...\n";
>
> $sth =3D $dbh->prepare('select * from subject where id < 5');
> $sth->execute;
>
> while ($row =3D $sth->fetchrow_hashref)
> {
> print Dumper($row);
> }
>
> $sth->finish;
> $dbh->disconnect;
>
> I had trouble first with the set username and the disconnect methods, =
> but as
> soon as both dbi version were 1.40, everything worked.=20
>
> Whoever is interested: Perl Tk800.025 (from CPAN) also works on cygwin. =
> That
> plus a multiwindow XFree config makes you almost feel like /home ;).
>
> Stefan
>
> -----Urspr=FCngliche Nachricht-----
> Von: Stefan Jahnke=20
> Gesendet: Wednesday, February 18, 2004 1:14 PM
> An: 'oracle-l@xxxxxxxxxxxxx'
> Betreff: AW: AW: Oracle 10g for Windows
>
>
> Hi
>
> If Net::Daemon doesn't work on windows, I'm actually wondering about =
> =3D
> how to
> get dbiproxy to work on windows anyway.
> In O'Reilly's DBI programming, the author suggests a setup for =3D
> connecting to
> a DB running on Windows via Proxy from=3D20
> a UNIX machine. Totally doesn't work for me.
>
> Did anybody ever get this to work? Or am I on the wrong list for =3D
> questions
> like this?
>
> Stefan
>
> -----Urspr=3DFCngliche Nachricht-----
> Von: Jared.Still@xxxxxxxxxxx [mailto:Jared.Still@xxxxxxxxxxx]
> Gesendet: Tuesday, February 17, 2004 8:15 PM
> An: oracle-l@xxxxxxxxxxxxx
> Betreff: Re: AW: Oracle 10g for Windows
>
>
> 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.
>
> These are daemons on that interact with services.exe.
>
> It may be possible to subvert HTTP::Daemon for use as Net::Daemon,
> but I really don't know.
>
> When I need to interact with something on a Windows system, I tend
> to do it with this checklist in mind:
>
> * 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.
>
> If it has to be done on the server, and Perl is the tool of choice, I =
> =3D
> try
> to minimize the number of components.
>
> ie. I don't want to rely on Cygwin.
>
> I will install Perl, and the modules needed to do the job.
>
> I've don't try to setup the Cygwin Perl to use DBD::Oracle, etc.
>
> 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
