CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 Error 1049 on trying sample solution

Print topic Send  topic

Author Message
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 :)

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.