Aynchronous connection to Oracle

[dgerdner]

This is probably a simple question, but I'm having difficulting finding the answer. How do I connect to an Oracle database asyncronously in a c# application?

 

[JurkMonkey]

Typically, I would write a component that deals with DB Queries that spawns worker threads. When the worker thread terminates it notifies my component of completion. In the meantime, your main thread is free to continue.

 

[chiph]

The Open method is synchronous, so you can't use a BeginInvoke or Invoke when connecting.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[dgerdner]

Perhaps I've worded this poorly.

I want to make an asyncronous connection to an Oracle Database; so that, for instance, long select statements can be cancelled from the front end.

 

[chiph]

You will need to be using ADO.NET 2.0, as this isn't supported under v1.1 (although you can execute your query on another thread...)

Take a look at:

http://www.devx.com/dotnet/Article/26747

and mentally change the objects used from Sql* to OracleClient*

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[dgerdner]

Thanks for the article, Chip. The only part with which I'm having problems (but it's an important part) is the connection string.

When I try using async=true (I also tried async=1 based on old PowerBuilder apps I have written) it throws an exception, telling me that async is not a valid connection string parameter.

 

[chiph]

Take a look at:
[tab]

http://www.connectionstrings.com/

for connection string help.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first