Re: [PHP-DB] ORA-12154: TNS:could not resolve service name in XXX

2001-02-22 Thread Peter J. Krawetzky 

I appears that PHP does not know about the paths for Oracle.  I am only
guessing at this because I haven't installed Oracle on a Linux/Apache box
but I think Apache is not aware of the Oracle paths that are required.  You
might need to recompile Apache with the appropriate configuration
parameters.
-Original Message-
From: Vlad [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Thursday, February 22, 2001 7:40 AM
Subject: Re: [PHP-DB] ORA-12154: TNS:could not resolve service name in XXX


Hi All
Oracle is installed on SCO UnixWare
Client that I use to connect on Windows 98
env variables ORACLE_HOME, TNS_ADMIN for client is correctly defined
by the way I created ODBC source for my ORACLE connection and tested it.
Then I tryed to connect using PHP's odbc_connect and have the same
problem...
Is there any solution?
Thanks, Vlad

 Make sure your tnsnames.ora file is setup correctly and that your
 environment variables are setup correctly.

 What OS are you using on the machine that Oracle is installed on?

 Peter J. Krawetzky
 -Original Message-
 From: Vlad [EMAIL PROTECTED]
 To: [EMAIL PROTECTED] [EMAIL PROTECTED]
 Date: Thursday, February 22, 2001 3:25 AM
 Subject: [PHP-DB] ORA-12154: TNS:could not resolve service name in XXX


 Hello All
 I have some problems connecting ORACLe from my php script.
 connection string:
   $conn = OCILogon("asu", "asu", "asu");
 failed with
   ORA-12154: TNS:could not resolve service name in XXX
 
 Regards, Vlad
 e-mail: [EMAIL PROTECTED]
 IóQ: 1042225964
 
 
 
 --
 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]




-- 
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]

Re: [PHP-DB] ORA-12154: TNS:could not resolve service name in XXX

2001-02-22 Thread Joe Brown 

I had a similar problem.

Worked up a tnsnames.ora file on windoz machines.  Thought it would be no
big deal if it was copied over to linux and used.  But there is a big deal..
Oracle can't handle the CRNL character sequence, in a unix environment.

Go figure...

There used to be a dos2unix program lying around my linux box.  A couple of
distributions later, I find none..

vi works well though..

$ vi tnsnames.ora
:set ff=unix
:w!

Did the trick for me, HTH.
-Joe

""Peter J. Krawetzky"" [EMAIL PROTECTED] wrote in message
001801c09cce$8c530160$[EMAIL PROTECTED]">news:001801c09cce$8c530160$[EMAIL PROTECTED]...
 I appears that PHP does not know about the paths for Oracle.  I am only
 guessing at this because I haven't installed Oracle on a Linux/Apache box
 but I think Apache is not aware of the Oracle paths that are required.
You
 might need to recompile Apache with the appropriate configuration
 parameters.
 -Original Message-
 From: Vlad [EMAIL PROTECTED]
 To: [EMAIL PROTECTED] [EMAIL PROTECTED]
 Date: Thursday, February 22, 2001 7:40 AM
 Subject: Re: [PHP-DB] ORA-12154: TNS:could not resolve service name in XXX


 Hi All
 Oracle is installed on SCO UnixWare
 Client that I use to connect on Windows 98
 env variables ORACLE_HOME, TNS_ADMIN for client is correctly defined
 by the way I created ODBC source for my ORACLE connection and tested it.
 Then I tryed to connect using PHP's odbc_connect and have the same
 problem...
 Is there any solution?
 Thanks, Vlad
 
  Make sure your tnsnames.ora file is setup correctly and that your
  environment variables are setup correctly.
 
  What OS are you using on the machine that Oracle is installed on?
 
  Peter J. Krawetzky
  -Original Message-
  From: Vlad [EMAIL PROTECTED]
  To: [EMAIL PROTECTED] [EMAIL PROTECTED]
  Date: Thursday, February 22, 2001 3:25 AM
  Subject: [PHP-DB] ORA-12154: TNS:could not resolve service name in XXX

 
 
  Hello All
  I have some problems connecting ORACLe from my php script.
  connection string:
$conn = OCILogon("asu", "asu", "asu");
  failed with
ORA-12154: TNS:could not resolve service name in XXX
  
  Regards, Vlad
  e-mail: [EMAIL PROTECTED]
  IóQ: 1042225964
  
  
  
  --
  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]
 
 


 --
 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]

Re: [PHP-DB] ORA-12154: TNS:could not resolve service name in XXX

2001-02-22 Thread Peter J. Krawetzky 

If you ftp'ed your file as binary, then the CRLF would not work correctly.
Try ftp'ing as ascii next time and you shouldn't have to go through the
extra steps on unix.

Peter J. Krawetzky
-Original Message-
From: Joe Brown [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Thursday, February 22, 2001 12:08 PM
Subject: Re: [PHP-DB] ORA-12154: TNS:could not resolve service name in XXX


I had a similar problem.

Worked up a tnsnames.ora file on windoz machines.  Thought it would be no
big deal if it was copied over to linux and used.  But there is a big
deal..
Oracle can't handle the CRNL character sequence, in a unix environment.

Go figure...

There used to be a dos2unix program lying around my linux box.  A couple of
distributions later, I find none..

vi works well though..

$ vi tnsnames.ora
:set ff=unix
:w!

Did the trick for me, HTH.
-Joe

""Peter J. Krawetzky"" [EMAIL PROTECTED] wrote in message
001801c09cce$8c530160$[EMAIL PROTECTED]">news:001801c09cce$8c530160$[EMAIL PROTECTED]...
 I appears that PHP does not know about the paths for Oracle.  I am only
 guessing at this because I haven't installed Oracle on a Linux/Apache box
 but I think Apache is not aware of the Oracle paths that are required.
You
 might need to recompile Apache with the appropriate configuration
 parameters.
 -Original Message-
 From: Vlad [EMAIL PROTECTED]
 To: [EMAIL PROTECTED] [EMAIL PROTECTED]
 Date: Thursday, February 22, 2001 7:40 AM
 Subject: Re: [PHP-DB] ORA-12154: TNS:could not resolve service name in
XXX


 Hi All
 Oracle is installed on SCO UnixWare
 Client that I use to connect on Windows 98
 env variables ORACLE_HOME, TNS_ADMIN for client is correctly defined
 by the way I created ODBC source for my ORACLE connection and tested it.
 Then I tryed to connect using PHP's odbc_connect and have the same
 problem...
 Is there any solution?
 Thanks, Vlad
 
  Make sure your tnsnames.ora file is setup correctly and that your
  environment variables are setup correctly.
 
  What OS are you using on the machine that Oracle is installed on?
 
  Peter J. Krawetzky
  -Original Message-
  From: Vlad [EMAIL PROTECTED]
  To: [EMAIL PROTECTED] [EMAIL PROTECTED]
  Date: Thursday, February 22, 2001 3:25 AM
  Subject: [PHP-DB] ORA-12154: TNS:could not resolve service name in XXX

 
 
  Hello All
  I have some problems connecting ORACLe from my php script.
  connection string:
$conn = OCILogon("asu", "asu", "asu");
  failed with
ORA-12154: TNS:could not resolve service name in XXX
  
  Regards, Vlad
  e-mail: [EMAIL PROTECTED]
  IQ: 1042225964
  
  
  
  --
  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]
 
 


 --
 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]