How do I connect to MySQL database from CodeCharge Studio and configure my database connection?

Products:   
Areas: Perl, IDE/GUI, General 

To connect to MySQL from a Windows program, such as MS Access, Excel or CodeCharge Studio, you will first need to install MyODBC driver from http://www.mysql.com/downloads/api-myodbc-2.50.html.
This driver will allow CodeCharge Studio to connect to a remote or local MySQL via ODBC in the design mode. During MyODBC driver installation process you should configure an ODBC/DSN connection on your computer so that it connects to your database. Then in CodeCharge Studio database connection dialog select Use ODBC Data Source Name and specify the name of the ODBC connection previously created. You can also specify
  Use Connection String -> Build -> Microsoft OLE DB Provider for ODBC Drivers -> Use data source name = (your ODBC connection name)
If your MySQL database is hosted remotely, sometimes it may be configured not to accept requests from outside. In such case you will need to use MySQL GRANT command to assign access permissions to your IP address, or you may ask your hosting company to do so.

Please keep in mind that CodeCharge Studio uses MyODBC during the design mode, however the generated programs can interact with MySQL directly via the native PHP commands, just by specifying the name of your database. To configure your server/run-time connection, in CodeCharge Studio database connection dialog please click on the "Server" tab, then specify:
  PHP Database Library = MySQL
  Database or ODBC connection name = (the name of your MySQL database)
  Login
  Password
The Host and the Port are optional.


Viewed 74849 times.   Last updated: 7/24/2002 9:50:10 AM