Figure 13.7 Creating a new Data Source.- The next window to appear is the TcX mysql Driver Configuration window. This
window contains all the information MyODBC needs to properly connect to the
designated database. Enter the following information into the appropriate fields:
Windows DSN Name: Meet-A-Geek
MySQL Host (name or IP): The name or IP of your MySQL server
User: root
Password: your root passwordPort and SQL command: leave blank
The completed window should look something like Figure 13.8.Figure 13.8 The configuration screen.- Click OK to compete the DSN configuration. You will be returned to the ODBC Data
Source Administrator. You should see your new DSN in the list box. Click OK to
close the Administrator. You have now successfully created your first MySQL
system DSN.
Remember that a DSN is simply a file that contains the data the driver needs to connect to a database.
It acts just like a configuration file.Active Server Pages and VBScript
Microsoft, in its efforts to create a heterogeneous data environment, has included ODBC connectivity in most
of its popular programs. For example, every application in its Office suite can connect to an ODBC data
source. Because it is easy to use and makes a lot of sense, other companies have jumped on the ODBC
bandwagon and now offer ways to connect to other data sources through ODBC.
The benefits ODBC can provide have not eluded the development community either. Software
developers realized right away what a heterogeneous data environment would mean, and Microsoft