Parag Kalra wrote: > Ok thanks Martin. Sorry for turning up so late on this > > One quick question - The box on which I am trying to connect has Informatica > ODBC driver to connect to SQL server.
Never heard of this driver or used it. Perhaps it is really the Data Direct driver. > So any idea if I can use this driver to connect Oracle to SQL Server or as a > matter of fact by any chance I can make it use through Perl. > > Cheers, > Parag If you have an ODBC Driver for SQL Server you should be able to talk to SQL Server through DBI and DBD::ODBC but you'll need an ODBC Driver manager too. This is where things might get a little tricky in your case as IF the Informatica ODBC Driver is actually the Data Direct driver then they used to have some unusual licensing terms about only using their drivers with their driver manager and I have no experience with either. Otherwise, you'll need unixODBC for an ODBC Driver Manager (http://www.unixodbc.org). To make Oracle talk to SQL Server you install Oracle's dgodbc but bare in mind that dgodbc comes in 32bit and 64bit builds and you'll need to match it with your driver and driver manager. See http://www.easysoft.com/applications/oracle/database-gateway-dg4odbc.html If you can install other software there are other ODBC drivers that come packaged with a driver manager to suite your platform that I know work behind dg4odbc - like ours :-) Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com > On Fri, Apr 9, 2010 at 12:40 AM, Martin Evans > <martin.ev...@easysoft.com>wrote: > >> Parag Kalra wrote: >>> Just reopening the thread. >>> >>> On a second thought - is it possible to connect to SQL Server from Oracle >>> Server using Perl. :) >>> >>> Cheers, >>> Parag >>> >> You can connect Oracle to SQL Server using dg4odbc (from Oracle) and an >> ODBC Driver (which you'll have to get else where). Not sure where Perl >> comes in to this as once you've done this tables in SQL Server are >> visible in Oracle so if you are already using Perl to talk to Oracle >> nothing changes. >> >> Martin >> -- >> Martin J. Evans >> Easysoft Limited >> http://www.easysoft.com >> >>> 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." >>>>> >
