Re: Oracle connection

Hi Doug, ODBC can certainly be used from a Linux client to NT Oracle server. You will want to examine OpenLink's Multi-Tier drivers. Install the trial copy with client side components on Linux, and the server-side components on the NT Oracle box. The HOWTO at www.iodbc.org discusses using --with-iodbc when compiling PHP as an apache module on Linux. iODBC is a Driver Manager, which makes PHP "ODBC-aware" and provides the ability to use any ODBC drivers. The trial copy of OpenLink's ODBC drivers don't expire, nor limit any functionality except to limit concurrency to 2 connections. A paid license is needed above that. Free support is provided for installation at http://www.openlinksw.com/support/suppindx.htm Please let me know if I may be of assistance. Best regards, Andrew --------------------------------------- Andrew Hill - OpenLink Software Director Technology Evangelism eBusiness Infrastructure Technology http://www.openlinksw.com On 3/12/01 10:31 PM, "Doug Schasteen" <dschast@escindex.com> wrote: > can odbc be used from php on linux, or is it just a windows thing? > > > ----- Original Message ----- > From: "Andrew Hill" <ahill@openlinksw.com> > To: "Joe Brown" <joebrown@somewhere.com>; <php-db@lists.php.net> > Sent: Monday, March 12, 2001 5:32 PM > Subject: Re: [PHP-DB] Oracle connection > > >> Or, you can use ODBC :) >> >> A PHP/ODBC HOWTO is available at http://www.iodbc.org >> and driver are available at www.openlinksw.com >> >> Please let me know if you require assistance. >> >> Best regards, >> Andrew >> --------------------------------------- >> Andrew Hill - OpenLink Software >> Director Technology Evangelism >> eBusiness Infrastructure Technology >> http://www.openlinksw.com >> >> >> On 3/12/01 6:22 PM, "Joe Brown" <joebrown@somewhere.com> wrote: >> >>> You need to acquire the oracle network drivers for linux, from Oracle. > I'm >>> only aware of the ones that come with Oracle for linux, though they may > have >>> them bundled seperately. >>> >>> Fight your way through the inconcievably difficult installation process. >>> >>> After defining some environment variables (they can be set after the > fact >>> too) which point the the oracle/home;net drivers, compile > php --with-oci8 or >>> similar argument. >>> >>> Start apache server the proper set of environment variables, be sure to > set >>> your nls_lang, etc... >>> >>> Now you should be able to access 'em. >>> >>> There is a fair amount of work involved, but it seems to be working > nicely >>> for me. A little tenacity will prevail. :-) >>> >>> Oh, you can put_env(SID=ORCL) etc... in your php code, instead of > setting >>> up environment variables, prior to compile/apache start. If you have >>> mutiple instances, this may be the preferred method. With a single >>> instance, I find it simpler to start apache w/a script that sets the >>> variables prior to startup. >>> >>> Oh yeah, lots of reading is involved too.... ;-) >>> >>> ""Marco Eyzaguirre"" <meyzagui@ilender.com.pe> wrote in >>> message >>> news:002601c0ab42$fac54f40$ce0410ac@ilender.com.pe... >>>> >>>>> I got a question: >>>>> >>>>> How can I access an Oracle database located on an Oracle 8i installed > in >>>>> Windows NT from PHP installed on a Linux box? >>>>> >>>>> thanx in advance for you answers >>>>> >>>>> Greetings >>>>> >>>>> Marco Eyzaguirre >>>>> DB Administrator >>>>> Ilender Peru S.A. >>>>> www.ilender.com.pe >>>>> >>>> >>>> >>>> -- >>>> PHP Database Mailing List (http://www.php.net/) >>>> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net >>>> For additional commands, e-mail: php-db-help@lists.php.net >>>> To contact the list administrators, e-mail: > php-list-admin@lists.php.net >>>> >>> >>> >> >> >> -- >> PHP Database Mailing List (http://www.php.net/) >> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net >> For additional commands, e-mail: php-db-help@lists.php.net >> To contact the list administrators, e-mail: php-list-admin@lists.php.net >> >> >> >> >