clkung
Posts: 3
|
Posted: 02/07/2004, 9:47 AM |
|
Hi, I have recently download the Codecharge Studio 2,2 and like to use the Portal example. However, it is not clear whether I need to set up a msql database on my server ? or there is a configurator in the Portal example that I can use to configure a database ? I notice there is a Portal_MySQL file that came with the download package , how do I use this Portal_MySQL.sql ?
Can anyone be kind enough to suggest what I should do ?
My server run Linux.
Regards
Kung
|
|
|
peterr
Posts: 5971
|
Posted: 02/08/2004, 5:02 PM |
|
Indeed You would first need to setup MySQL on your server (or local computer). Here is the relevant part of the MySQL User Manual: http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html
Once you have MySQL installed you should create an initial database, then copy the file Portal_MySQL.sql to your server and run MySQL "against it", like:
mysql -D databasename -u username -p < Portal_MySQL.sql
(for the full list of command line options see: http://www.mysql.com/documentation/mysql/bychapter/manu...ipts.html#mysql)
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
clkung
Posts: 3
|
Posted: 02/08/2004, 10:02 PM |
|
Thanks for the advice, I have the mysql setup correctly now.
Can you advise how to configure a new Database connection from the Codecharge Studio ?
I believe I need to setup a connection to "localhost" at the server, but the Add Connection feature in the codecharge studio is leading me to confiure for 1. ODBC datasource name , or 2. Using connection string .
What should I type as connection string to connect to the MySql database in my server ? I would appreciate it if you can advise. Thanks a lot.
Regards
Kung C L
|
|
|
peterr
Posts: 5971
|
Posted: 02/08/2004, 10:14 PM |
|
Refer to "Design Time Connection to a MySQL Database" section of the User Manual (Help file). Also here: http://docs.codecharge.com/studio/html/UserGuide/Workin...gDatabases.html
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
clkung
Posts: 3
|
Posted: 02/18/2004, 10:07 AM |
|
Can anyone show me how I can convert a microsoft access database into a MySql database ? Thanks.
Kung CL
|
|
|
|