Re: Want To Know about Databse Connection

Hello, Manisha wrote: > > Hi, > > We are developing web application. The client wants it to get connected to > their central database server in USA. Web server is in Singapore. > > Web server configuration - Situated in Singapore, unix / php / mysql - > this database is only for some special cases where application does not > require central database. > > Main central database server - Situated in USA, HP UX / sybase > > On web site we will be providing product listing and order form. After the > order is confirmed and payment is made, client wants to update some fields > on central database. > > Can anybody give me the details, how to do it? If I am using php, how to > connect to remote server's database? What are the components require on > both servers? How will be the network configuration? Any information > source? etc etc... Making database connections over the Internet is not a wise solution because of security and performance problems. I would recommend you to use SOAP based services over the Web to make remote procedure calls to services that execute tasks or just return information. Here you may find a PHP class that is a base for implementation for SOAP services: http://phpclasses.UpperDesign.com/browse.html/package/251 Manuel Lemos