Accessing SQL Server in a worker thread

Code? I've used Asynchronous Delegates to so something similar, and it
works out just fine.

Thanks,
Michael C.

"Matthias Steinbart" <postamt@_REMOVEME_emvoid.de> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

Hi there,

I'm trying to access an SQL Server through an SqlConnection within a worker thread. This doesn't seem to work. If I call the Open() method, nothing
happens on the Server and no Exception is thrown. Is this by design or am I missing something out?

thanks in advance.

Matthias

--
-----
fragmente einer flugbahn - http://emvoid.de

Hi Matthias:

I've done this many times with success. Perhaps you could post some
code for us to take a look at and give suggestions as to why it might
not be working for you.

--
Scott
http://www.OdeToCode.com

On Fri, 16 Jul 2004 21:47:18 +0200, "Matthias Steinbart"
<postamt@_REMOVEME_emvoid.de> wrote:

Hi there,

I'm trying to access an SQL Server through an SqlConnection within a worker
thread. This doesn't seem to work. If I call the Open() method, nothing
happens on the Server and no Exception is thrown. Is this by design or am I
missing something out?

thanks in advance.

Matthias

Hey Scott,

thanks for your reply. I actually have been using a tiny framework that
makes the work with threads a lot easier. Obviously in this framework has
been a bug. It just took me ages to figure it out. Anyway, your reply is
greatly appreceated.

Matthias

--
-----
fragmente einer flugbahn - http://emvoid.de

"Scott Allen" <bitmask@[nospam].fred.net> schrieb im Newsbeitrag
news:0c********************************@4ax.com...

Hi Matthias:

I've done this many times with success. Perhaps you could post some
code for us to take a look at and give suggestions as to why it might
not be working for you.

--
Scott
http://www.OdeToCode.com

On Fri, 16 Jul 2004 21:47:18 +0200, "Matthias Steinbart"
<postamt@_REMOVEME_emvoid.de> wrote:

Hi there,

I'm trying to access an SQL Server through an SqlConnection within a workerthread. This doesn't seem to work. If I call the Open() method, nothing
happens on the Server and no Exception is thrown. Is this by design or am Imissing something out?

thanks in advance.

Matthias

Hi Michael,

as posted previously, the Bug actually was in a small framework I've been
using. Nevertheless I got curious about your solution using Asynchronous
Delegates. Could you please provide some cornerstones, so I can get the
picture. Thanks in advance.

Matthias

--
-----
fragmente einer flugbahn - http://emvoid.de

"Michael C" <mi*******@optonline.net> schrieb im Newsbeitrag
news:OF**************@TK2MSFTNGP11.phx.gbl...

Code? I've used Asynchronous Delegates to so something similar, and it
works out just fine.

Thanks,
Michael C.

"Matthias Steinbart" <postamt@_REMOVEME_emvoid.de> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

Hi there,

I'm trying to access an SQL Server through an SqlConnection within a worker

thread. This doesn't seem to work. If I call the Open() method, nothing
happens on the Server and no Exception is thrown. Is this by design or

am I

missing something out?

thanks in advance.

Matthias

--
-----
fragmente einer flugbahn - http://emvoid.de

I just saw your message. I don't have any code handy on this laptop, but
all I did was run my SQL Command inside an Asynchronous Delegate with
Callback. It took a little while to figure out, but once done it's easy to
do it over and over. I gathered a lot of info. on Async Callbacks from
previous posts in this newsgroup, on the MS website and in the book C# and
the .NET Platform. Once I get on my regular computer I'll post some code
here for you... might not be for a couple of days though.

Thanks,
Michael C.

"Matthias Steinbart" <postamt@_REMOVEME_emvoid.de> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

Hi Michael,

as posted previously, the Bug actually was in a small framework I've been
using. Nevertheless I got curious about your solution using Asynchronous
Delegates. Could you please provide some cornerstones, so I can get the
picture. Thanks in advance.

Matthias

--
-----
fragmente einer flugbahn - http://emvoid.de

"Michael C" <mi*******@optonline.net> schrieb im Newsbeitrag
news:OF**************@TK2MSFTNGP11.phx.gbl...

Code? I've used Asynchronous Delegates to so something similar, and it
works out just fine.

Thanks,
Michael C.

"Matthias Steinbart" <postamt@_REMOVEME_emvoid.de> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

Hi there,

I'm trying to access an SQL Server through an SqlConnection within a

worker

thread. This doesn't seem to work. If I call the Open() method, nothing happens on the Server and no Exception is thrown. Is this by design or

am

I

missing something out?

thanks in advance.

Matthias

--
-----
fragmente einer flugbahn - http://emvoid.de