silvia
|
| Posted: 03/05/2002, 9:31 AM |
|
can CodeCharge connect to a remote database - during development as well as when the site is live? I'm still evaluating the trial version, considering work on a project where I'll need to tap into an already existing database that's not going to be on the same server as my site. Would I need to design a new database which updates at certain intervals using the original one, so that I have the database that I link to on the same server as the site? I'll appreciate!
|
|
|
 |
Ron Borkent
|
| Posted: 03/05/2002, 3:04 PM |
|
Yes, as long as you make sure there is an odbc connection to the remote server. At work I use the mysql-server for development. Before I go home I dump that databse to my laptop and develop local at home. The next day I make sure any changes in tables are updated to the intranet mysql-server and go on developing. No problem what so ever. For making sure the website connects to a remote server you have to provide the details in the properties->database section.The first part is the above mentioned odbc stuf the second is what php uses on your website.Where it says host you give the IP of the remote instead of saying localhost, that's all.
This is all assuming we're talking about a mysql server. If it is something like Oracle there are other things you have to pay attention to. The webserver must contain the client portion of the oracle software(you can download that for free) You have to configure this with the info for your oracle database server. This information is then used by php. Without it no connection is possible to oracle. If your webserver is a linux with apache it can be a bitch to configure because you also have to compile php with the oracle flag.
On windows with apache it's relatively easy. just make sure the client part is installed and you activated the oci8 or oracle extensions.
Ron
|
|
|
|
|
