RE: [PHP-DB] remote database exchange

(Quote from an annotation found on http://www.php.net/manual/en/function.ocilogon.php): rkohli@xperts.com 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... -----Original Message----- From: Ken Sommers [mailto:mrsql.php@worldnet.att.net] 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 options? Ken ----- Original Message ----- From: "Matthew Loff" <matt@willetts.com> To: "'Ken Sommers'" <mrsql.php@worldnet.att.net>; "'PHP DB Mailing List'" <php-db@lists.php.net> 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 in > PHP > > The PHP page has an example on that page that will show you -exactly- > how to do it. > > --Matt > > > -----Original Message----- > From: Ken Sommers [mailto:mrsql.php@worldnet.att.net] > 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? > > > Ken > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: > php-list-admin@lists.php.net > >