Groups > Databases > Oracle for ASP.NET > Re: link oracle database




link oracle database

link oracle database
Tue, 1 Apr 2008 01:29:58 +0000
Sub page_load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
            Dim conn, comm, dbread
            conn = New
System.Data.OleDb.OleDbConnection("provider=microsoft.jet.oledb.4.0;
datasource = oracle;user=******;password=******")
            conn.open()
            comm = New System.Data.OleDb.OleDbCommand("select * from
qiu.company", conn)
            dbread = comm.ExecuteReader()
            rp.DataSource = dbread
            rp.DataBind()
            dbread.close()
            conn.close()
            
            
        End Sub

 

error  message: conn.open() cannot start application, the group message lose or
open by excludable

could you give me same asp.net link database reference?
Post Reply
Re: link oracle database
Tue, 1 Apr 2008 07:19:20 +0000
Try this,

using System.Data.OleDb;

 OleDbConnection conn = new OleDbConnection();
 conn.ConnectionString = 
               "Driver=MSDAORA;" + 
               "Data Source=ServerName;" + 
               "User id=UserName;" + 
               "Password=Secret;"; 
 conn.Open();
Post Reply
about | contact