<% 'Using OLEDB 'strConnection = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & server.MapPath("/public/database/voiceofthecape.mdb") & ";" 'strConnection = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & server.MapPath("database/voiceofthecape.mdb") & ";" 'strConnection = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & server.MapPath("../database/voiceofthecape.mdb") & ";" 'Using DSN 'strConnection = "DSN=voiceofthecape;Uid=;Pwd=" 'DSN-less 'strConnection ="Driver={Microsoft Access Driver (*.mdb)};DBQ=" & server.MapPath("database/voiceofthecape.mdb") & ";" 'Mysql connection string 'Live strConnection = "Driver={MySQL ODBC 3.51 Driver}; Server=sql3de.your-server.co.za; Database=voiceofthecape; UID=vocfma_1; PWD=MJHEufA5; Option=3" 'Localhost 'strConnection = "Driver={MySQL ODBC 3.51 Driver}; Server=localhost; Database=voiceofthecape; UID=; PWD=; Option=3" Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open(strConnection) %>