dbTalk Databases Forums  

.net Data Provider - Problem with IIS6

comp.databases.btrieve comp.databases.btrieve


Discuss .net Data Provider - Problem with IIS6 in the comp.databases.btrieve forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Musa
 
Posts: n/a

Default .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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.