<% set cn = server.CreateObject("ADODB.Connection") cn.CursorLocation = 3 cn.Open "Provider=MSDASQL;Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=test6;UID=root;PWD=;OPTION=16386;" cn.Execute "DROP TABLE IF EXISTS bug30590" cn.Execute "CREATE TABLE bug30590 (id int not null primary key auto_increment,test_text text, test_int int, test_char char(50));" cn.Execute "INSERT INTO bug30590 (test_text, test_int, test_char) values ('this is a test', '1234', 'this is another test');" Set oRS = cn.Execute("select * from bug30590") response.Write ("") cn.Close Set cn = Nothing %>