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
