Just reopening the thread. On a second thought - is it possible to connect to SQL Server from Oracle Server using Perl. :)
Cheers, Parag On Thu, Mar 25, 2010 at 12:04 AM, Parag Kalra <paragka...@gmail.com> wrote: > Hi Jeff, > > Heaps and Heaps of thanks to you man... > > Your solution (3) worked liked a breeze - absolutely out of the box... :) > > Now both me and Customer are happy... > > Thanks a lot once again... > > Cheers, > Parag > > > > On Wed, Mar 24, 2010 at 6:36 AM, Jeff Urlwin <jurl...@caci.com> wrote: > >> Some points I would add to the below: >> 1) I agree, grabbing a new perl is usually best, but, sometimes >> that isn't as easy (politically) as it should be. >> 2) I have had luck injecting DBI, and other perl modules, into the >> existing, Solaris perl, using Sun's Studio compiler. I believe you can get >> that for free, now. Don't use GCC for this. >> 3) I have had luck using the Perl that Oracle installs on DB >> machines, by just setting the right @INC at run time: >> >> OPERL_LIB=$ORACLE_HOME/perl/lib >> $ORACLE_HOME/perl/bin/perl -I$OPERL_LIB/5.8.3 >> -I$OPERL_LIB/site_perl/5.8.3/sun4-solaris-thread-multi foo.pl >> >> Your Oracle-installed perl may vary from the above, but this is working >> with 10.2.0.4 and includes, of course DBI and DBD::Oracle. I'm not sure if >> they install perl with the Oracle Client, but it is installed in the DB >> server, so it can be used... >> >> -----Original Message----- >> From: Jonathan Leffler [mailto:jonathan.leff...@gmail.com] >> Sent: Tuesday, March 23, 2010 6:42 PM >> To: Parag Kalra >> Cc: DBI Users Mailing List >> Subject: Re: Official DBI module for Solaris Box >> >> On Tue, Mar 23, 2010 at 2:49 PM, Parag Kalra <paragka...@gmail.com> >> wrote: >> > Surprised to see no response yet. :-) >> >> Well, the question is a bit odd too...I'll attempt to address the original >> too. >> >> > Anyways few more questions - >> > >> > For which version of Perl on Solaris, does DBI comes integrated with >> Perl or >> > is it like on Solaris we always explicitly need to install DBI module >> > externally. >> >> DBI is not distributed as standard on Solaris. >> >> > If the customer has valid support contract, can Sun Support help to get >> DBI >> > installed? >> >> Unlikely. >> >> > On Sat, Mar 20, 2010 at 7:31 PM, Parag Kalra <paragka...@gmail.com> >> wrote: >> >> I am facing this situation where I have coded a Perl framework on >> Windows >> >> and its all working fine. The framework mostly uses DBI and ODBC module >> to >> >> connect to both Oracle server, execute SQL queries, fetch Rows etc etc. >> >> OK - so far, so good. >> >> >> Now the customer wants to use the framework on a Solaris machine (it >> has >> >> Perl installed - 5.8.4). However that Solaris machine doesn't have DBI >> >> module as a result of which I can't use my framework. But it has Oracle >> >> client installed using which (sqlplus, sqlldr etc) I am able to connect >> to >> >> the Oracle DB Server (located remotely) >> >> This is perfectly normal - Perl on Sun does not come with DBI. >> Since Perl is provided by the o/s, I regard it is dubious, if not >> dangerous, to tinker with the system Perl. >> Besides, its usually archaic - so I always install the version of Perl >> I want on the machine, out of the way of the main system-provided >> Perl. >> That way, the o/s can use its version unmolested by me, and I can use >> my version unrestrained by the o/s. >> >> >> The best solution here seems to get the DBI module installed using Sun >> >> Support. Does Sun provide support for Perl modules (particulary DBI) on >> its >> >> own OS - Solaris? >> >> Doubtful. Ask Sun. But assume the answer is no. >> >> >> Customer doesn't want to install anything third party that didn't come >> >> pre-installed with Solaris box. >> >> This is weird...so, how is your application ever going to run? And >> how did Oracle get installed? It is not a part of base Solaris. >> >> >> However he may give a thought to installing >> >> new version of standalone Perl which will have DBI module integrated. I >> >> guess Perl 5.10.1 has DBI present by default. Could someone please >> confirm. >> >> Guess again. You have to add DBI to Perl. >> >> >> In addition to DBI do I need any other module to connect to Oracle DB >> from >> >> a Solaris machine? >> >> You're going to need a DBD module - presumably DBD::Oracle. >> >> >> Is there any other way I can convince the client that Perl is good >> >> OpenSource tool and certainly not a malacious software. >> >> Probably not. >> >> >> Also more solutions to install DBI module on Solaris are most wellcome. >> >> Either you're allowed to install software or you are not. >> If you are allowed, go ahead and install what you need. >> If you are not allowed, then leave the customer gently stewing in >> their own juice. >> >> -- >> Jonathan Leffler <jonathan.leff...@gmail.com> #include <disclaimer.h> >> Guardian of DBD::Informix - v2008.0513 - http://dbi.perl.org >> "Blessed are we who can laugh at ourselves, for we shall never cease >> to be amused." >> > >