<% DIM connString, conn ConnString = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=www3.north.londonmet.ac.uk; PORT=3307; DATABASE=dbname; UID=userid; PASSWORD=userpw; OPTION=3" SET conn = Server.CreateObject("
ADODB.Connection") conn.Open(connString) SET rs = Server.CreateObject("
ADODB.recordset") rs.open "SELECT * FROM table_name", conn %> The embedded SQL query, SELECT * FROM table_name, was to select every filed from the table_name table of the dbname MySQL database.
Data is stored in a single database: MySQL and PostgreSQL are best supported, but it can also be used with commercial databases, ADO and generic ODBC database access, since it uses
ADOdb