CODEWITHSUNDEEP
c#.netoracle-xe
chongchian
chongchian

Reputation: 1

Oracle 10g Express .NET Connector

I was wondering if I could get any advice on connecting to Oracle 10g Express to .NET? I saw a solution in one of the threads here, but could not seem to find a download link.

my intention is to use Visual Studio 2010 (.NET 4.0) to connect to a Oracle 10g Express database.

Appreciate any advice.

Upvotes: 0

Views: 1361

Answers (1)

V4Vendetta
V4Vendetta

Reputation: 38230

Check out the files under server/network/admin You need to setup the TNSNAMES.ora file which would have the credentials for the Express 

XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = [machinename])(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )

Listener.ora file LISTENER = (DESCRIPTION_LIST = (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = [machinename])(PORT = 1521))
) )

And finally check if the listener is up via cmd 

lsnrctl status

This should show you connecting to the XE instance mentioned above.

You will need Oracle.DataAccess dll to communicate with the instance, add a reference of it and with the query string you should be good to start off

Upvotes: 1

Related Questions