Ran into a strange problem that seems to appear randomly, and I haven't been able to pin down the conditions under
whichit appears.
I have 2 functions that I use to access my database. These functions are called from multiple locations. In one of the
functions,I have the following code:
Dim sql as string = "select ..... "
Dim conn As New Npgsql.NpgsqlConnection(ConnectionString)
conn.Open()
Dim command = New Npgsql.NpgsqlCommand(sql, conn)
Try
Dim dr As Npgsql.NpgsqlDataReader = command.ExecuteReader()
' perform processing
dr.Close()
conn.Close()
catch ex As Exception
....
For some reason, an exception "Stream does not support Writing" is being thrown on the ExecuteReader command. However,
itdoes not occur all the time (nor does it always appear when the same function is calling it.
Did a quick search and didn't find any reference to this error with Postgres. Any idea what the cause could be?
