Database Reference
In-Depth Information
Figure 14.8
Some MyODBC data source errors.
ing to debug connection problems in the program that is accessing the data source.
Figure 14.8 shows three of the possible responses from clicking on the
Test Data Source
button.
The first error in Figure 14.8 shows the type of error that you may get if you have speci-
fied the host name of the MySQL server incorrectly. The last error shown in the figure can
occur if the username or password is incorrect, or if the user does not have access rights
from the machine where the data source is trying to connect from.
Once your data source has tested correctly, you will be able to refer to it and use it in
other programs that can communicate with data sources.
Example Connections
To demonstrate how to use the MyODBC data source from other programs, we will show
examples of its use with ASP and with ColdFusion.
ASP, or Active Server Pages is a technology that allows you to create dynamic webpages
by means of scripts that run on a server. ASP was first implemented by Microsoft when it
came built in to its webserver, IIS which comes bundled as part of many of Microsoft's
modern operating systems.
ColdFusion was originally produced by Allaire Corporation who have now merged with
Macromedia, Inc. ColdFusion again is a server side scripting language which allows the cre-
ation of dynamic webpages on your server by means of tags that you insert into HTML
code.
The following two examples will show how you can use MyODBC to connect these two
products back to your MySQL server to utilize your data.
Search WWH ::
Custom Search