Please review the following information before working with the Database Component.
The Database Component requires v.7.5 Update #3
or higher. Click here to visit the product downloads
page.
The code generated by the Database Component is
evaluated on the server you publish to. It is important that you verify
your server supports the database language you will be using. For information
on server requirements, check with your hosting provider and/or platform
documentation.
Databases and data sources should be created before
using the Database Component.
Note that while some database applications, such as Microsoft Access
and SQL Server, allow spaces in table names, the Database Component will
allow table names with no spaces. (Ex. Name your table FirstName rather
than First Name.)
The ASP and ColdFusion components connect to any
database using ODBC.
The PHP component connects directly to any MySQL
database or to an MS Access database on a Windows platform using a datasource.
Full support for MS Access and MySQL are provided and can be selected
in the PHP Connector Properties palette.
In addition, Adodb v3.05 drivers are available in the PHP components
directory. To use one of these additional drivers, locate the correct
file at ..\Components\DBComponent\db\php\000.Connector,
and then type the file name in the Custom Engine field in the PHP Connector
Properties palette.
For databases that you don't see a driver you may get them from the
Adodb v3.05 for PHP distribution and install to the following location:
...\Components\DBComponent\db\php\000.Connector.
Verify your data source has been successfully established.
Website Pros offers a Tag Library Component that works with the Database Component to fully integrate dynamic elements into your Web site. To download the component, launch NetObjects Fusion and download the Tag Library Component from the Control Panel in your Online view.