myODBC for MySQL
If you are planning to connect to mySQL from your PC you will need to install and set up a myODBC connection. Below are the steps you will need to get a connection installed.
myODBC Driver for your PC
Important Note: If you have installed help on your PC. Always check the on-line version of this help page on the web using this address: http://www.dbqwiksite.com/help/5000/index.htm?myodbc.htm
In order to design using a mySQL database, you will need to download and install the ODBC driver for MySQL before you are able to connect to a mySQL database.The ODBC driver for mySQL is called myODBC and can be downloaded from the mySQL web site at the following URL: http://dev.mysql.com/downloads/
The recommended version of MyODBC for dbQwikSite 5 is 126.96.36.199.
Important ‘Advanced Settings’ are required. Read the details on the last section of this page
myODBC Configuration Settings
You can access mySQL connection setting by using the Connection Wizard or the ODBC Administrator. When setting up a mySQL ODBC connection your will be presented with the following myODBC dialog.
myODBC Login Dialog
You must fill this in with the details that are particular to your environment:
Make sure all options on your connection are set as above.
Note: ‘Enable Auto-Reconnect’ resolves most cases of ‘My server has gone away’ errors.
Your test must be successful in order to use this connection in dbQwikSite projects.
If your test fails please verify your settings and try again. If you are sure the settings are correct, but you cannot connect to your database on a host server, it is likely that your hosting has blocked remote connections to mySQL for security reasons. If this is the case, you have the options to either user dbQwikSite's mySQL Script Import feature, or to install mySQL on your PC.