I have a problem with SQL Server not returning an error when a divide by 0 occur.
I've created s short VB.net program below to show this. It calls SQL server 2005 twice, They both should error out with a divide by 0. However, only the 2nd block of code is caught. When I run the SQL through Mgmt Studio, both do error out.
Am I missing something in my code?
-------------
Module Module1
Sub Main()
Dim adoCon As
New SqlConnection
Dim adoCmd As
New SqlCommand
Dim NewRec As SqlDataReader
Dim txt As
String = ""
Try
adoCon.ConnectionString =
"Data Source=SQLSMST0;Initial Catalog=master;User ID=guest;Password=???;Connect Timeout=40"
adoCon.Open()
adoCmd.Connection = adoCon
txt =
"block1"
adoCmd.CommandText =
"select 1/0"
adoCmd.CommandType = CommandType.Text
NewRec = adoCmd.ExecuteReader()
NewRec.Close()
Catch ex As Exception
Debug.Print(txt)
End Try
Try
txt =
"block2"
adoCmd.CommandText =
"declare @i as integer; select @i=1/0"
adoCmd.CommandType = CommandType.Text
NewRec = adoCmd.ExecuteReader()
Catch ex As Exception
Debug.Print(txt)
End Try
End Sub
End
Module
