.net Data Provider - Problem with IIS6 -
06-27-2005
, 09:38 AM
I have a unusual problem when I use the .net provider to access V8
database.
within a few minutes of using the aspx page which has the code for the
data access using pervasive, the IIS6 hangs and requires to be
restarted.
The error logged in the events log is as under:
aspnet_wp.exe (PID: 1676) stopped unexpectedly.
code is as follows:
Protected Overridable Function Update_saveuntilrequired() As Boolean
'Implements IPreserve.Update
Dim conn As New
Pervasive.Data.SqlClient.PsqlConnection(_connStrin g)
Dim cmd As New Pervasive.Data.SqlClient.PsqlCommand
Dim sql As New System.Text.StringBuilder
try
cmd.CommandType = CommandType.Text
sql.Append("Update APVEN Set ")
sql.Append(" TEXTSTRE1 = '" & _street1 & "',")
sql.Append(" TEXTSTRE2 = '" & _street2 & "',")
sql.Append(" TEXTSTRE3 = '" & _street3 & "',")
sql.Append(" NAMECITY = '" & _city & "',")
sql.Append(" CODESTTE = '" & _province & "',")
sql.Append(" CODEPSTL = '" & _postalCode & "',")
sql.Append(" CODECTRY = '" & _countryName & "'")
sql.Append(" Where VendorID = '" & _vendorID & "'")
cmd.CommandText = sql.ToString
cmd.Connection = conn
conn.Open()
cmd.ExecuteNonQuery()
Catch ex As Exception
Return False
Me._Messages.AddMessage(1, ex.Message, 0)
Finally
conn.Close()
conn = Nothing
sql.Length = 0
End Try
End Function
Any suggestions will be appreciated |