Discussion Locked

ASP.Net Oracle Connection

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Dear all,
Please let me know, how to connect oracle with asp.net web application.My code below:
public WebForm1()
{
InitializeComponent();
ConnStr="Provider=msdaora.1;DSN=assetmgr;User Id=scott;Password=tiger;";
conn = new OleDbConnection(ConnStr);
conn.Open();

dataadpt = new OleDbDataAdapter("Select * from tblast",conn);
cbuild = new OleDbCommandBuilder(dataadpt);
dataSet1=new DataSet("tblast");
dataadpt.Fill(dataSet1,"tblast");
}

i had created the assetmgr in ODBC datasource Administrator. But it was not asking any test connection.
in which I gave assetmgr as data source name.
i gave user name as scott
server name as what it is...
Please let me know
Thanks in advance

1 reply

This discussion is closed to new replies.