Using Enterprise Blocks with Oracle

[Guest]

I downloaded Microsoft Enterpreise Patterns & Practices (June 2005).
I'm trying to use the Data.Oracle library to connect to Oracle 9i
database with no luck.
Does anyone know how to connect to Oracle database? How? I'm unable to
find any useful material to refer to.

 

[cbDevelopment]

We use ODP.NET, which is a free (although huge) download from Oracle's
site. There is not too much code difference in using MS's or Oracle's db
drivers.

You will need the Oracle client installed (included with the ODP download)
so you can get the base database connectivity. This includes the service
name to attach to. The service name will be in your Oracle\Network\Admin
folder in a .TNS file. Your Oracle DBA should be able to help there. You
can check http://www.connectionstrings.com/ for the connection string to
use. That's all I know that's different between MS SQL Server and Oracle.

Hope this helps.