Member Avatar for jayz_raul

hye there...anyone can help me out here...im having problem in running sql command
its shows error : "sqlConnection does not support parrallel transactions"
trans = conn.BeginTransaction()
Dim strs As New SqlCommand
strs.Transaction = trans
strs.Connection = conn
strs.CommandText = "Insert into StudentSMS (RecipientCode,RecipientNumber) values ('" & RecipientCode & "' , '" & RecipientNumber & "' )"
strs.ExecuteNonQuery()

any ideas and help need urgently....thankz

  • 2 Contributors
  • 1 Reply
  • 158 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by Sulley's Boo
Member Avatar for Sulley's Boo

before you begin your transaction, make sure the conn is open ..

and close it when you are done ..

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.