How do I connect to MySQL database from CodeCharge Studio and configure my database connection?
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
Related Questions
- Every time I try to connect to a MySQL database on remote Linux server, I get the Lost connection to MySQL server during query error. Whats wrong?
- Im not able to connect to the ClockWork database using the connection tool. How can I troubleshoot?
- How do I configure a MySQL database for remote connection?
