Enterprise Library 3.1 Data Access Application Block Connection St

[Guest]

Using .NET 2 with the above.

Instead of doing Database myDB=
DatabaseFactory.CreateDatabase("myDBNameDefinedInConfigFile");

to connect to an Oracle 10g database

How can I programatically set the UserID and password (which I take from the
User Interface) at run time?

 

[Jesse Houwing]

Hello Patrick,

Using .NET 2 with the above.

Instead of doing Database myDB=
DatabaseFactory.CreateDatabase("myDBNameDefinedInConfigFile");

to connect to an Oracle 10g database

How can I programatically set the UserID and password (which I take
from the User Interface) at run time?

No. You'll need to set up Oracle to use NT Integrated Security or roll your
own OracleDataBase class. I've written this before and it isn't that hard.
But you will loose connectionpooling on the .NEt side and perfomance and
scalability suffer accordingly (quite bad). You won't have these problems
if you configure Oracle to use Integrated Security, or use a single accoutn
to connect to Oracle. If you absolutely need the username for every query,
you might consider passing it as a parameter.