ismael
|
| Posted: 10/03/2002, 4:07 PM |
|
Please tell me how can i connect mysql database from my code charge application
Tell me the process in detail.
Regards
Ismael
|
|
|
 |
Gene Akins
|
| Posted: 10/03/2002, 9:40 PM |
|
I just did this 2 days ago... and I know nothing about database stuff so if I could do it, any1 should be able to. It really wasnt that hard.
First you need to install the mysql driver, you can get it at http://www.mysql.com. The file I downloaded was for Windows 2k file name: myodbc-2.50.39-nt.zip
After this is installed, in your codepage project you select properties and the Database tab.
If you need to connect to a mysql database locally on your system or a mysql server take a look at the help document in CodeCharge, it explains this very well. Open Codecharge and hit F1, select User Guide, Site Properties, Database. Scroll down the page to the Setting up MyODBC for MySQL
Note: This is only if the database you are pulling data from into CodeCharge is from a mysql database.
For Publishing....
Under the SERVER section enter your database name.(This is the name of your online database.)
Enter you servers ip address in the Host field, your login name, and password for connecting to your server.
Select the database type as Mysql
Now your ready to connect to the server.
As I said Im just new to this too, but the help documentation about mysql in CodeCharge made it very easy to configure. The screen shots helped alot.
I would also recommend downloading from http://www.mysql.com a program called MySQL-Front. It is a easy-to-use-interface for dealing with MySQL-Databases. I use it to create my tables online.
Gene Akins
gene@momotek.com
|
|
|
|
|
