<% Response.CharSet = "utf-8" Response.CodePage = 1252 strConnString = "Driver={MySQL ODBC 5.1 Driver}; SERVER=localhost;" & "charset=UTF8; DATABASE=test; UID=test; PASSWORD=test; OPTION=3" 'Create the connection object Set objConn = Server.CreateObject("ADODB.Connection") objConn.Open strConnString 'Create the recordset object Set objRec = Server.CreateObject("ADODB.RecordSet") 'Build the Demographic_Answers SQL string strSQL = "Select * FROM test WHERE test = 1" ' Open the recordset using the query built objRec.Open strSQL, objConn Response.Write("Test is " & objRec("Test") & "

") %>