asked on

Connect to Oracle database in C# ASP

Please help me in connecting to Oracle via a VPN connection.
My database is located on my school's server. I can connect to it using the following parameters:
* Name: apollo.ite.gmu.edu
* Port: 1521
* Oracle SID: ite10g

As long as I'm on the school network I can connect. But I am not sure how to add these parameters for my ASP page. Thank you,

slightwv (䄆 Netminder)

What data provider are you wanting to use? I suggest ODP.Net which is Oracle's .Net data provider but some people like OLEDB and use either Oracle's or Microsofts.

Once you have the dataprovider installed you'll just need the proper references.

There's a decent page that has just about ever type of connection string available:
http://www.carlprothman.net/Default.aspx?tabid=81

adajani1

ASKER

MY *.asp page will be on the school's network.

I was only provided with the above parameters. Not sure what driver they installed.

adajani1

ASKER

I did an application with java b4 using the following parameters and it worked.. I just don't know how to include this info for my ASP.

String driverName = "oracle.jdbc.driver.OracleDriver";
Class.forName(driverName);

System.out.println("Connecting to Oracle...");

String url = "jdbc:oracle:thin:@apollo.ite.gmu.edu:1521:ite10g";
Connection conn = DriverManager.getConnection(url,"name","password");

ASKER CERTIFIED SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

ramumorla

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

slightwv (䄆 Netminder)

I suggest a split between ramumorla and myself.

ramumorla

i agree