Re: [PHP-DB] ORA-12154: TNS:could not resolve service name in XXX
Actually, if I had ftp'd the files I probably would have used ascii (*probably*). I used an SMB mount to copy the files. Never crossed my mind that CRLF would be an issue. Rarely is anymore, but... Wanted to let the world know there's an easy way to convert files with vi. Wish I know how to do it with emacs... ;-) Didn't take long to figure it out with vi, so I went that route. (BTW who's the joker at Microsoft that thinks ctrl-p should print things?) -Joe ""Peter J. Krawetzky"" <[EMAIL PROTECTED]> wrote in message 000c01c09cf2$c00a8ef0$[EMAIL PROTECTED]">news:000c01c09cf2$c00a8ef0$[EMAIL PROTECTED]... > 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 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 > > -- 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
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 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] > > -- 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
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 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
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
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]
Re: [PHP-DB] ORA-12154: TNS:could not resolve service name in XXX
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-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]