I am using visual studio 2010 with crystal report for visual studio
when i am checking with my development machine it works fine
but when i deploy it on server it shows error that logon fail
I am using blank Password which works fine on local machine
Below is the Code which I am Using
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.OleDb;
using System.Data;
using System.Data.SqlClient;
using CrystalDecisions.Shared;
using CrystalDecisions.CrystalReports.Engine;
public partial class _Default : System.Web.UI.Page
{
public string ServerConn = "Provider=SQLOLEDB;data source=DB;Initial Catalog=Shriraj;Persist Security Info=True;User
ID=sa";
OleDbConnection cn = new OleDbConnection();
protected void Page_Load(object sender, EventArgs e)
{
OleDbConnection cn = new OleDbConnection();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
cn.ConnectionString = ServerConn;
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = cn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from [PhoneDetails]";
try
{
cn.Open();
cmd.ExecuteNonQuery();
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
da.Fill(ds);
}
catch
{
}
finally
{
cn.Close();
}
dt = ds.Tables[0];
ReportDocument report = new ReportDocument ();
report.Load("E:\\practices\\update\\emp_details\\crystalreports\\CrystalReport1.rpt");
report.Load(Server.MapPath("CrystalReport1.rpt"));
//2. set logon info
CrystalDecisions.Shared.ConnectionInfo conn = new ConnectionInfo();
CrystalDecisions.CrystalReports.Engine.Table myTable;
CrystalDecisions.Shared.TableLogOnInfo myLog;
conn.AllowCustomConnection = true;
conn.ServerName = "DB";
conn.DatabaseName = "shriraj";
conn.UserID = "sa";
conn.Password = "";
conn.IntegratedSecurity=false;
for (int i = 0; i < report.Database.Tables.Count; i++)
{
myTable = report.Database.Tables[i];
myLog = myTable.LogOnInfo;
myLog.ConnectionInfo = conn;
myTable.ApplyLogOnInfo(myLog);
myTable.Location = myLog.TableName;
}
// report.SetDatabaseLogon("sa", "", "db", "Shriraj",true);
// report.SetDataSource(ds);
CrystalReportViewer1.ReportSource = report;
CrystalReportViewer1.RefreshReport();
}