"Stream does not support Writing" exception

From: "Allan Sullivan" <allan(dot)sullivan(at)nortak(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: "Stream does not support Writing" exception
Date: 2007-02-21 18:07:51
Message-ID: 3D9BF154E1B04444B6D07D04B1F0CD4F4EF7C9@ntk-mail2k3.nortak.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Ran into a strange problem that seems to appear randomly, and I haven't been able to pin down the conditions under which it 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, it does 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?

Browse pgsql-novice by date

  From Date Subject
Next Message Vishal Mailinglist 2007-02-21 18:36:22 VB.net and PostgreSQL readiness
Previous Message Nabil 2007-02-21 17:42:05