Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!
<% Dim adoCon 'Holds the Database Connection Object Dim rsAddComments 'Holds the recordset for the new record to be added Dim strSQL 'Holds the SQL query to query the database Set adoCon = Server.CreateObject("ADODB.Connection") adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("******.mdb") Set rsAddComments = Server.CreateObject("ADODB.Recordset") strSQL = "SELECT tblComments.Drawings_Number, tblComments.Drawing_Title FROM tblComments;" rsAddComments.CursorType = 2 rsAddComments.LockType = 3 rsAddComments.Open strSQL, adoCon rsAddComments.AddNew rsAddComments.Fields("Drawings_Number") = Request.Form("Drawings_Number") rsAddComments.Fields("Drawing_Title") = Request.Form("Drawing_Title") rsAddComments.Update rsAddComments.Close Set rsAddComments = Nothing Set adoCon = Nothing Response.Redirect "dwgreg.asp" %>
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.