|
|
Posted by dan_e on 10/29/06 21:40
The error message i get is:
CONNECT error: ORA-12705: Cannot access NLS data files or invalid
environment specified
My system environment vars are set to the instantclient_10_2 dir, and
my tnsnames.ora file is set-up correctly....what could this mean?
Cheers,
Dan.
Andy Hassall wrote:
> On 26 Oct 2006 00:11:12 -0700, "dan_e" <the.route@gmail.com> wrote:
>
> >I have got PHP 5 working on this windows box with APACHE 2.2. I cannot
> >however get PHP to connect to an oracle database.
> >
> >Here is all the info that may help determine what i'm doing wrong.
> >
> >PHP.ini file has been change to show the following:
> >
> >(under Windows extensions)
> >extension=php_oci8.dll
> >extension=php_oracle.dll
>
> Remove the second one, it's obsolete (based on Oracle 7).
>
> >I have unzipped the oracle 10.2 client and placed my tnsnames.ora file
> >in there with the following:
> >
> >DJD1 =
> > (DESCRIPTION =
> > (SDU=4096)
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST = dusrvdb)(PORT = 1522))
> > )
> > (CONNECT_DATA =
> > (SERVICE_NAME = djd1.corp.cranegroup)
> > )
> > )
> >
> >I have set the system environment variables on the windows box with the
> >following
> >
> >Path = C:\PHP\instantclient_10_2;c:\...etc (more paths)
> >tns_admin = C:\PHP\instantclient_10_2
> >
> >The \instantclient_10_2 directory only holds the dll's, etc and my
> >tnsnames.ora file.
> >
> >There is a version of Oracle 9.2 installed at this location:
> >c:\Oracle\Ora92\Bin....(and all the other dirs)
> >
> >but i make no reference to it (should i?)
>
> No, stick with Instant Client as you are. In fact, the more recent binaries of
> PHP's OCI8 extension won't work against 9i, as they use 10g features.
>
> >Below is the php code i am using to try and determine if i get a
> >connection or not:
> >
> ><?php
> >$database = OCILogon("the_username", "the_password", "DJD1");
> >if(!$database)
> > die("<H1>Unable to connect!</H1>");
> >OCILogOff($database);
> >echo("<H1>SUCCESS!</H1>");
> >?>
> >
> >If someone could please offer any advice that would great! I have done
> >a little with PHP before, but never touched Oracle. I am clueless...
>
> You've not posted what actually happened. Also use OCIError to get more
> information, assuming you even got that far.
>
> --
> Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
> http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
Navigation:
[Reply to this message]
|