Hi all,

I have an odd problem, which I traced back to a line of code.

I have a record set coming back into a DataReader (OdbcDataReader in my
case). I can .Read() once, but when the loop starts again and the
..Read() is executed a second time, the application just ends.

There are NO exceptions, logs or anything, its as if the .Read method
called Application.Exit().

Any ideas?

Thanks
Andy

Do you have a try catch around the DataReader.Read?

Try executing the exact same SQL through ADO classic using VBScript, see if
that throws a GPF.

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.ma.../13/63199.aspx
----------------------------------------------------------------------------



"Andy" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi all,
>
> I have an odd problem, which I traced back to a line of code.
>
> I have a record set coming back into a DataReader (OdbcDataReader in my
> case). I can .Read() once, but when the loop starts again and the
> .Read() is executed a second time, the application just ends.
>
> There are NO exceptions, logs or anything, its as if the .Read method
> called Application.Exit().
>
> Any ideas?
>
> Thanks
> Andy
>

Sahil,

Yes, I have a try catch. The program simply terminates. No
exceptions, its as if running the line were Application.Exit().

I did find the cause though; a very badly design ODBC driver. You can
have an OR in the WHERE clause, but if you don't do it EXACTLY the way
it wants, it closes the caller.

Andy

That is quite terrible, I agree.

--

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.ma.../13/63199.aspx
----------------------------------------------------------------------------

"Andy" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Sahil,
>
> Yes, I have a try catch. The program simply terminates. No
> exceptions, its as if running the line were Application.Exit().
>
> I did find the cause though; a very badly design ODBC driver. You can
> have an OR in the WHERE clause, but if you don't do it EXACTLY the way
> it wants, it closes the caller.
>
> Andy
>