Mike Rembisz
|
| Posted: 05/06/2002, 6:32 PM |
|
I'm sure this is a simple question but I don't know the answer... Can I develop an application with CCS on my Win89 computer and upload it to my FreeBSD server to run on the Internet?
In trying to get my setup working I have looked at the PHP code and see that it is very specific to local database drivers. I don't see an easy way to change the code so that it will open my MySQL database on my server once the application is uploaded. Do I have to manually add that code or am I totally in the dark? Thanks..
|
|
|
 |
Nicole
|
| Posted: 05/07/2002, 5:57 AM |
|
Mike,
you should set up publishing and db connection settings in project settings. All the necessary code will be generated automatically and you do not need to change anything.
Select menu item Project->Settings and open project settings window. First go to Publishing tab and select location where files are to be located and site url. The go to Connection settings. You should establish 2 connections to db. One is for design time, and the other is for live site. Note that now to avoid some problem with sql generation use MySQL db as design db (It is Beta version and for now design time db affects on sql syntax). I assume that you already have created connection. If no, click 'Add' and create new connection. Use ODBC connection to MySQL db for design time. Fill design time connection settings on Design tab of Modify Connection window. While it is done, go to Server tab and enter following db connection settings:
PHP Database Library: select MySQL
Database Name: db_name
Login: db_login
Password: db_pasword
Host: host_name or IP
That's all.
|
|
|
|
|
