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" <[EMAIL PROTECTED]> wrote:
> can odbc be used from php on linux, or is it just a windows thing?
>
>
> ----- Original Message -----
> From: "Andrew Hill" <[EMAIL PROTECTED]>
> To: "Joe Brown" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> 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" <[EMAIL PROTECTED]> 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"" <[EMAIL PROTECTED]> wrote in message
>>> 002601c0ab42$fac54f40$[EMAIL PROTECTED]">news:002601c0ab42$fac54f40$[EMAIL PROTECTED]...
>>>>
>>>>> 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: [EMAIL PROTECTED]
>>>> For additional commands, e-mail: [EMAIL PROTECTED]
>>>> To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
>>>>
>>>
>>>
>>
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> For additional commands, e-mail: [EMAIL PROTECTED]
>> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>>
>>
>>
>>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
