SQL Driver Sample Programs

From CometWiki

(Difference between revisions)
Jump to: navigation, search
m
Line 1: Line 1:
This page shows how to set up MySql and sample IB programs to give you a better idea how the SQL Driver works in Comet.  Please refer to the [[SQL Driver]] page for a more thorough reference.
This page shows how to set up MySql and sample IB programs to give you a better idea how the SQL Driver works in Comet.  Please refer to the [[SQL Driver]] page for a more thorough reference.
-
==Setting Up MySql Community Server==
+
==Installing MySql Community Server==
In order to start using the SQL Driver in Comet, you must have access to a MySql database somewhere.  It can be on your local machine, on the local network, or out on the internet somewhere.  If you already have a MySql database server installed and configured, please skip forward to the [[#Example Database and Tables|Example Database and Tables]] section.
In order to start using the SQL Driver in Comet, you must have access to a MySql database somewhere.  It can be on your local machine, on the local network, or out on the internet somewhere.  If you already have a MySql database server installed and configured, please skip forward to the [[#Example Database and Tables|Example Database and Tables]] section.
 +
 +
If you are setting up a MySql server, we recommend you download the free Community Server version of [http://dev.mysql.com/downloads/mysql/5.1.html#downloads MySql 5.1].  This is simply because we have been using mostly version 5.1 for testing, but the SQL driver should work with all 5.x and later versions of MySql server.  Once you have downloaded the MSI installer, install it on your local machine (if you are simply testing), or on your server if you wish to host your MySql data elsewhere.  Once the installation is complete, the wizard should automatically start the MySql configuration utility, which guides you through the rest of the set up process.  If not, you can find it usually under <nowiki>Start->Programs->MySQL->MySQL Server X.X->MySQL Server Instance Config Wizard</nowiki>
==Configuring MSsql==
==Configuring MSsql==

Revision as of 17:40, 4 December 2009

This page shows how to set up MySql and sample IB programs to give you a better idea how the SQL Driver works in Comet. Please refer to the SQL Driver page for a more thorough reference.

Contents

Installing MySql Community Server

In order to start using the SQL Driver in Comet, you must have access to a MySql database somewhere. It can be on your local machine, on the local network, or out on the internet somewhere. If you already have a MySql database server installed and configured, please skip forward to the Example Database and Tables section.

If you are setting up a MySql server, we recommend you download the free Community Server version of MySql 5.1. This is simply because we have been using mostly version 5.1 for testing, but the SQL driver should work with all 5.x and later versions of MySql server. Once you have downloaded the MSI installer, install it on your local machine (if you are simply testing), or on your server if you wish to host your MySql data elsewhere. Once the installation is complete, the wizard should automatically start the MySql configuration utility, which guides you through the rest of the set up process. If not, you can find it usually under Start->Programs->MySQL->MySQL Server X.X->MySQL Server Instance Config Wizard

Configuring MSsql

Example Database and Tables

Example IB Programs

Personal tools