Computer Webmaster Gaming Console Graphics Forum

Welcome to the Computer Webmaster Gaming Console Graphics Forum forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact us.

MK PitStop Main Earn $25 Earn Money Posting Extras Members Blogs Image Hosting User Pages
Go Back   Computer Webmaster Gaming Console Graphics Forum > Webmaster Forum > Website Coding > PHP
Register FAQ/Rules Become A V.I.P. Member Search Today's Posts Mark Forums Read

PHP PHP for some can be one of the hardest website programming codes, so do you need help on your PHP script, if it is php4, php5 or lower this is the place for you for any PHP help.

Google
Closed Thread
 
LinkBack Thread Tools Display Modes
Old 02-05-2008, 12:21 PM   #1
Jeff Fox
 
Jeff Fox's Avatar
 
Posts: n/a
My Photos: (0)

Banked:
MK Cash: $

I am Worth:
MK Cash: $
Donate

Recent Blog: None

Default PHP4, PWS, Oracle, cannot connect, HELP!

I am running Winnt Workstation 4.0, PWS 4.0, PHP4, and Oracle 8.1.5 (on a
different box).
I also have PHP3 installed.

When I attempt to connect to an Oracle database from PHP3 it works fine.
When I attempt to connect to the same database with PHP4, with the exact same
code I get this error:
Warning: Oracle: Connection Failed: ORA-12154: TNS:could not resolve service
name in
c:\inetpub\wwwroot\test\oratest.php4 on line 2

Here is my test code:
<?
$conn = Ora_Logon("msds@tst3.world", "password") or die;
$curs = ora_open($conn);
ora_commitoff($conn);
$query = sprintf("select * from msds");
ora_parse($curs, $query);
ora_exec($curs);
$ncols = ora_numcols($curs);
while (ora_fetch($curs))
{
for ($i=0; $i<$ncols; $i++)
{
printf("%s = %s", ora_columnname($curs,$i), ora_getcolumn($curs,$i));
printf("<br>");
} }
ora_close($curs);
ora_logoff($conn);
?>

I can connect to the database and execute the SQL from SQL-Plus. I *know* that
Oracle name resolution works.

Please help, if I can get this working then I can use PHP instead of ASP. I need
to use PHP4 for session
support. I don't want to use PHPLIB because I will eventually move this code to
a Solaris box and I want to use
'pure' PHP4 if at all possible.
-------------------------------------------------
Created by Zkey.com - http://www.zkey.com
Awarded PCMagazine's Editors' Choice
 
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit!
Featured Websites
Free Space
Free Space
Free Space Free Space
Closed Thread
Tags:




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Oracle and PHP UUnet PHP 2 02-05-2008 12:21 PM
How can I connect to Oracle from Win32 version of PHP4? Ondrej Kuchar PHP 0 02-05-2008 12:19 PM
XBOX not connect to Belkin Router, Does Connect to Modem! tedzeppelin Console Subjects 2 06-26-2007 2:14 AM
XBOX not connect to Belkin Router, Does Connect to Modem! tedzeppelin Console Subjects 6 06-26-2007 2:14 AM
Encription in Oracle eric Database 2 07-16-2006 6:50 AM


Featured Websites




All times are GMT +1. The time now is 11:41 PM.


Powered by: vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO 3.0.0
Cheap Computers
MK PitStop Copyright 2005 - 2008

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98