Hi,

I need to connect to an Oracle 9i Database from ASP.NET. Although I can connect to the Oracle Database through SQL*Plus using the same userid/password and service name.

I have downloaded and installed the latest Oracle ODBC drivers for 9.01 from Oracle's website and it didnt help. Also I installed Microsoft .NET Oracle Client and it produced the same results.


I have included the following namespaces and am using the following connection string to connect to Oracle -


<%@ Page Language="VB" Debug="true" Trace="true" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OleDB" %>

szConStr = "Provider=OraOLEDB.Oracle;Data Source=abc; User ID=xyz; Password=xyz123;"


In ASP.NET however I get the following error -

ORA-12154: TNS:could not resolve service name

Stack Trace:


[OleDbException (0x80004005): ORA-12154: TNS:could not resolve service name]
   System.Data.OleDb.OleDbConnection.ProcessResults(I nt32 hr) +20
   System.Data.OleDb.OleDbConnection.InitializeProvid er() +57
   System.Data.OleDb.OleDbConnection.Open() +203
   ASP.G3_ASPX.Page_Load(Object Sender, EventArgs E) in D:\timesheet\ts04\g3.aspx:50
   System.Web.UI.Control.OnLoad(EventArgs e) +67
   System.Web.UI.Control.LoadRecursive() +35
   System.Web.UI.Page.ProcessRequestMain() +725

What could be wrong. Please suggest. Thanks.

I'm using vb with Oracle.
In Global.asax:
Session("ELTS") = OleDbConnection1

In Webform:
Imports System.Data.OleDb
Dim ELTS As OleDbConnection

In Page_Load:
Dim connection As New OleDb.OleDbConnection()
connection.ConnectionString = "Provider=MSDAORA.1;Password=fme9elts;User ID=mp_elts;Data Source=fme9;"
connection.Open()

Not sure if this was the fastest solution, but here it is:
- I had Oracle 8 and 9 clients, so I removed both and installed Oracle 9 client
- Downloaded Microsoft .NET Managed Provider for Oracle at http://www.microsoft.com/downloads/d...displaylang=en
- Switched my code to use System.Data.OracleClient

Example:
        Dim cmd As System.Data.OracleClient.OracleCommand
        Dim con As New System.Data.OracleClient.OracleConnection()
        con.ConnectionString = "Password=test;User ID=test;Data Source=service.domain.com;" 'domain.com is optional if it is default in sqlnet.ora
        con.Open()
        cmd = con.CreateCommand()
        cmd.CommandText = "select report_desc from report"
        cmd.CommandType = CommandType.Text
        Dim rs As System.Data.OracleClient.OracleDataReader
        rs = cmd.ExecuteReader
        ListBox1.Items.Clear()
        Do While rs.Read
            ListBox1.Items.Add(CType(rs(0), String))
        Loop
        'Do not forget to close, big problems later
        rs.Close()