Hi,
I have installed oracle 10g client on my system. But still i am getting
error while trying to connect to oracle as follows:
DBI connect('host=10.7.85.32;sid=SMDB1;port=1521','wb',...) failed: ERROR
OCINls
EnvironmentVariableGet(OCI_NLS_CHARSET_ID) Check ORACLE_HOME and NLS
settings et
c. at test.pl line 19
Pls help me to get rid of this error.
Regards,
Vinod.
On Mon, Jul 19, 2010 at 1:57 PM, Alexander Foken <alexan...@foken.de> wrote:
> No, even with DBD::ODBC you need an Oracle client, not for DBD::ODBC
> itself, but the ODBC manager needs one. Windows comes out of the box with a
> prehistoric Oracle client that causes more trouble than it is worth, so even
> there, you want to install a RECENT Oracle client.
>
> The only way to avoid installing an Oracle client on a specific machine is
> to use another machine with an installed Oracle client as a proxy, using
> DBD::Proxy or DBD::Gofer, or some other proxying code.
>
> Alexander
>
>
> John Scoles wrote:
>
>> I guess you could use DBD::ODBC that does net require an oracle client.
>>
>> cheers
>> John Scoles
>>
>> On Fri, Jul 16, 2010 at 4:50 AM, Martin J. Evans
>> <martin.ev...@easysoft.com>wrote:
>>
>>
>>
>>> Vinod Guleria wrote:
>>>
>>>
>>>> Dears,
>>>>
>>>>
>>>> Could you pls let me know that Is there a way to connect to oracle DB(on
>>>> remote system) without having oracle client on my system.
>>>>
>>>>
>>>> Thanks & Regards,
>>>> Vinod Guleria.
>>>>
>>>>
>>>>
>>> If you are absolutely sure you cannot install any Oracle software on
>>> your machine you need to search for Oracle Wire Protocol drivers.
>>> However, none of these are made by Oracle and if Oracle change the
>>> network protocol they will probably stop working until you can get an
>>> update from the manufacturer. Also, these WP drivers don't tend to
>>> support encryption, XA, failover etc and many other features you get
>>> with the Oracle client.
>>>
>>> A better bet in my opinion is to install Oracle Instant Client. It is a
>>> relatively small download and can be installed anywhere - you do not
>>> need root permission.
>>>
>>> Martin
>>> --
>>> Martin J. Evans
>>> Easysoft Limited
>>> http://www.easysoft.com
>>>
>>>
>>>
>>
>> --
>> New! Learn why & how to love your data with Pythian's new webinar series.
>> Topics, details & register: http://www.pythian.com/webinars
>>
>>
>>
>>
>
