ORACLE 10g with C#

Hi,

This time I would like to share my experience with the Oracle 10g Free edition (XE).

After installing the OracleXE successfully, I tried to connect to it with VS .NET 2005, and to my surprise it is not a straight process. I’ve read many article I can find by GOOGLING but no luck, non of the article I found can help me connect to the Oracle XE from my VS .NET 2005.

It took about 4/5 hours  for me to figure it out how to connect to the OracleXE from .NET.

Below are steps that I took:

1. Install OracleXE

2. Connect to OracleXE from Web Site Admin to make sure that It’s running (use the ’system’ login, supplied with administrator password that I supplied at the installation process).

3. Install the ODAC ( Oracle .NET Tools latest version for 10g)

4. Use Oracle Net Manager (under ODAC->Migration tool Start Menu).

5. Add New Service Naming with the Oracle Net Manager

- Service_Name, You can name it whatever you wanted.

- Choose the Protocol (I choose TCP / IP)

- (Oracle 8i or later) Service Name IS ‘XE’ (Default value for Oracle 10g XE).

-  Finished the setup and exit the NET Manager (Choose to save when asked).

If you failed to connect after doing all those thing, please make sure you supplied the correct ‘Oracle 8i or later Service Name’, go to Oracle Web Site Admin, and look for it in the => Administration=>About the Database. Check the Setting check box and press ‘Go’ button, you can find the ‘NAME’ field value(default ‘XE’).

I hope this little ‘how to’ can help others that bumped into the same problem as me connecting to Oracle 10g XE edition with VS .NET 2005.

Cheers…