Malathi

Malathi

  • NA
  • 20
  • 7.4k

Visual Studio 2012 c# asp.net Report viewer

Jun 29 2015 6:54 AM
How to connect a rdlc report to Oracle database table using Web.config connection string in Visual Studio 2012 c# asp.net.
The database connection is NOT THROUGH Server Explorer Data Connection [gives Error ORA-12154  OR ORA-6413 OR ERROR[IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application.].
 
try
{
conn.Open();
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM Employee ORDER BY ID ASC";
cmd.Connection = conn;
OracleDataReader rs = cmd.ExecuteReader();
 if (rs.Read()) // C#
{
 ReportViewer1.Enabled = true;
ReportViewer1.DataBind();
}
}
 finally
{
conn.Close();
conn.Dispose();
}
Thanks in advance.

 

 

 

 


Answers (1)