Database Connectivity

Introduction

Zinc™ v2.5 can connect to Microsoft Access* and MySQL Databases, and with added ADO support, you can practically connect to any Database Type! Zinc™ v2.5 supports SQL statements which means that you can execute all INSERT, UPDATE, DELETE and SELECT commands on your database connections. There's no need for server side scripts such as PHP, ASP or CGI as Zinc™ v2.5 creates a direct connection with the Database.

*Microsoft Access Databases can only be connected offline. To connect to an online Access Database, you would still need to use ASP.

Notes

a) This Tutorial will go through the steps of connecting to a local Microsoft Access Database. The same methodology can be applied to MySQL Databases.

b) This Tutorial assumes a basic understanding of Databases and SQL statements.

c) This Tutorial uses {mdm}Script™ 2.0 which is only available from Zinc™ 2.5