EntLib and Oracle

[Guest]

First let me say I know little or nothing about Oracle.

I want to configure the EntLib June 2005 to read from an oracle database. I
added a new database type and selected the Oracle assembly

I added a new database instance using that type then...

I add a new oracle connection string this is where I am not sure it shows a
package and a server. not sure what should be here? what is the package
property...

Please help

Thanks
Steve

 

[Matt Noonan]

First let me say I know little or nothing about Oracle.

I want to configure the EntLib June 2005 to read from an oracle
database. I added a new database type and selected the Oracle assembly

I added a new database instance using that type then...

I add a new oracle connection string this is where I am not sure it
shows a package and a server. not sure what should be here? what is
the package property...

Steve,

Here's an example connection string from a project I did with Oracle:

<connectionString xsi:type="OracleConnectionStringData" name="BAAN
Production Database">
<parameters>
<parameter name="Data Source" value="baan" isSensitive="false"
/>
<parameter name="Password" value="********" isSensitive="true"
/>
<parameter name="User ID" value="user" isSensitive="false" />
</parameters>
<packages />
</connectionString>

I did not set the package name because I had to do it in code. The value in
the Data Source is the TNS Name.

HTH

 

[Guest]

Matt,

Thanks for your help!

a couple of question...

You mentioned you didn't set the package property because you had to set it
in code? What is the package property and will I have to set it in code.

also there is currently a dsn set up on the application server to hit the
Oracle database (through another program) can I just configure the entlib to
use that dsn?

if so, how?

Thanks
Steve

 

[Matt Noonan]

You mentioned you didn't set the package property because you had to
set it in code? What is the package property and will I have to set
it in code.

I'd have to go back and read the EntLib help files. I think it basically
adds the package name automatically to every call for stored procs. I was
using multiple packages, so I couldn't take advantage of that functionality.

also there is currently a dsn set up on the application server to hit
the Oracle database (through another program) can I just configure
the entlib to use that dsn?

I'm not sure. Typically I don't use DSNs and I prefer to just set the
connection string in the config file. I'm not really an Oracle guru, I just
had to develop a couple of applications against it.