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 cConnstr As String Dim oConn As New ADODB.Connection Dim rs As New ADODB.Recordset Dim cSql As String cConnstr = "Driver=SQL Server;Server=WINXP-TEST-V\SQLEXPRESS;UID=sa;PWD=sa1234;database=aa_jobdata" Set oConn = New ADODB.Connection With oConn .CursorLocation = adUseServer .Mode = adModeShareDenyNone .Open cConnstr End With cSql = "Select * From Costtype WHere Code = 'ZZZZ'" With rs .CursorLocation = adUseServer .Open cSql, oConn, adOpenKeyset, adLockOptimistic, adCmdText .Delete .Close End With
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.