(Quote from an annotation found on
[EMAIL PROTECTED] 31-Mar-2000 11:32
Regarding connecting to an Oracle Db on NT from Linux, here is what you
need to do. Little Oracle knowledge is a prerequisite.
1. Install Oracle database client onto Linux.
2. Once installed on Linux, modify the tnsanmes.ora file to create an
alias to the database running on the NT box. Follow the syntax already
in the tnsnames.ora file
3. Depending on the version of Oracle you have and the Oracle Database
has the listener running there is a utility called tnsping(xx) that you
can use to verify that you can hit a remote 0racle database syntax is
tnsping <alias in tnsnames.ora>
4. You could use sqlplus to conenct to the remote database to verify the
login process works. Remember to use login_id@tnsnames_alias/password
5. Once you have gotten this far PHP should be able to hit the database.
Give it a shot. You might need to tool around the PHP config to get
things to work. use the phpinfo function to debug, its rather useful.
That's the only solution I've found without setting up a CGI on the
other end to retrieve the info...
From: Ken Sommers [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 6:56 PM
To: Matthew Loff; 'PHP DB Mailing List'
Subject: Re: [PHP-DB] remote database exchange
Suppose I Need to get Vendor prices from a very large remote (Oracle)
price list . They probably don't have PHP installed. What are my
----- Original Message -----
From: "Matthew Loff" <[EMAIL PROTECTED]>
To: "'Ken Sommers'" <[EMAIL PROTECTED]>; "'PHP DB Mailing
List'" <[EMAIL PROTECTED]>
Sent: Monday, July 16, 2001 3:31 PM
Subject: RE: [PHP-DB] remote database exchange
> The mysql_connect() function accepts a host name, which can be the
> internet address of another machine! However-- the MySQL database on
> that machine has to be set up to allow outside connections for
> whatever particular username/password you are using!
> Please see these pages to answer your questions:
> http://www.mysql.com/doc/A/d/Adding_users.html -- MySQL
> username/password configuration
> http://www.php.net/manual/en/ref.mysql.php --- MySQL functions
> The PHP page has an example on that page that will show you -exactly-
> how to do it.
> -----Original Message-----
> From: Ken Sommers [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 16, 2001 5:53 PM
> To: PHP DB Mailing List
> Subject: [PHP-DB] remote database exchange
> Is it possible to exchange data on remote databases in PHP mysql?
> Suppose I had a MUSIC database that you wanted your site visitors to
> be able to query,and it was OK with me because you had a MOVIE
> database that I wanted MY site visitors to be able to query,
> Could we swing this?
> what is the name of this process?
> remote process serving?
> remote database access?
> relay exchange process server?
> IF it exists,,where are all the tutorials and docs on it?
> 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]