whiter
|
| Posted: 05/06/2003, 9:30 AM |
|
OK .... after my last attempts, I've started CodeCharge Studio again from scratch and attempted to generate and then use the sample solution "Employee Directory".
I *now* get the following errors on the Default.php page:-
Database error: cannot use database employees
MySQL Error: 1049 (Unknown database 'employees')
Session halted.
Well .. I had assumed that CodeCharge would generate the database as well as the PHP code!
SO ... what configuration of the "settings" etc. do I need to do to get this sample solution to work?
AND... how do I generate the database tables, views, indexes etc.?
The sample solution comes with an assumed link to an "Intranet" MS Access database. I do have MS Access (in OfficeXP) installed, though whether CodeCharge is connecting to MS Access or not I have no idea ..... how would I find out??? Likewise, if it's generating an MS Access database, then *where*???? How would I find that out????
My environment is: WinXP, Apache [local] web server, PHP (already tested) and MySQL (tested via MySQL Control Center), plus CodeCharge Studio 2.0.5.6, and the MyODBC driver installed and connecting ok [via the test button].
Anybody have a idea what I need to do to get the database for this sample solution?
TIA
Richard
|
|
|
 |
Paulette
|
| Posted: 05/06/2003, 3:46 PM |
|
Richard,
you will need to go create the databases in MySQL before this will work. Look for a file called "Intranet_MySQL". On my system it's located at
G:\Program Files\CodeChargeStudio\Examples\Intranet_MySQL.sql
in this file is the script needed to recreate all the databases for the Intranet examples. Same thing for the Internet examples-look in the Internet folder under the examples folder of CCS.
Hope this helps !
Paulette :)
|
|
|
 |
|