Due to the security concerns with using System Data Source Names (DSNs) on shared systems, we try to encourage the use of DSNless connections our servers. This means that the connection credentials (passwords etc) must be supplied in a connection string that you provide to the ADO/ODBC layer, rather than us storing them for you in a DSN which anyone on the system could use.

First, an ADODB.Connection object must be created; then a specially crafted connection string must be passed to the Open method, as the following code demonstrates.

Example

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={MySQL}; SERVER=sandbank.zetnet.co.uk; DATABASE=test; UID=username; PWD=password;"

You will need to replace the SERVER, DATABASE, UID and PWD entries with details provided to you when your database was first setup. If you have lost these details, please get in touch with webweaver@zetnet.net.

Links

Here are some links that may be useful while developing your web applications:

Zetnet MySQL Web Admin Interface
https://www.secure.zetnet.co.uk/mysqladmin/

Google Search for "ASP database"
http://www.google.com/search?q=asp+database+tutorial

Microsoft's Universal Data Access Site
http://www.microsoft.com/data/

MySQL / MyODBC Reference Manual
http://www.mysql.com/products/myodbc/manual_toc.html

MySQL / MyODBC Download Site (Zetnet allow you to connect from your own test servers)
http://www.mysql.com/downloads/api-myodbc.html

MySQL Download Site (Run your own test/development server)
http://www.mysql.com/downloads/mysql.html