Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
Dim rstest As ADODB.Recordset Dim SQLrs As String Dim cn As ADODB.Connection Dim strtest As String SQLrs = "SELECT tblProductNames.ID, tblProductNames.FName FROM tblProductNames WHERE (((tblProductNames.ID)=3));" strtest = "DSN=Berry_DatSQL;Integrated Security=True" cn = New ADODB.Connection cn.CursorLocation = CursorLocationEnum.adUseClient cn.Open(OdbcConnection1.ConnectionString, "", "", -1) rstest = New ADODB.Recordset rstest.Open(SQLrs, OdbcConnection1.ConnectionString, CursorTypeEnum.adOpenKeyset, LockTypeEnum.adLockOptimistic, 1) With rstest .MoveFirst() txtProduct.Text = rstest.Fields.Item(2).Value End With rstest.Close() rstest = Nothing
|How to simplify my SQL statement?||14||50|
|I need help embedding an image as HTML in my vb.net application||3||45|
|user defined date datatype in SQL Server- can it be overdone..||6||22|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!