VB6 wih SQL 2005
Posted on 2011-04-27
if i run this code in vb6 to remove few rows from the SQL2005 database, its entering in to a unstoppable loop. Please help me to resolve this
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
conn.Open "Provider = sqloledb;" & "Data Source=10.10.10.1;" & "Initial Catalog=Master;" & "User ID=sa;" & "Password=password;"
rs.Open "select * from applications", conn, adOpenStatic, adLockOptimistic, adCmdText
Do Until rs.EOF
If rs.Fields(1) = HID Then
All other connectivity with the same connection is working fine. While trying to delete this problem occurs..