Failed to open the connection. Details: [Database Vendor Code: 12154 ]

Dear All,

We have created almost 15 crystal reports designed in Delphi XE4 application which points to different schema.

We revamped the same application Visual Studio 2013 application. Everything is converted and working fine in the application

except Crystal reports. We are now using different schema in our Visual studio application.

I tried to connect using the same rpt file with different schema it is showing error like.

Database logon failed. Failed to open the connection.

So how to resolve the issue without pointing the new instance.

We are working for logistics company so we will get so many instances. so we don't want to map the Data source, user Id and password.

Is there anyway to resolve the issue. While i'm pointing to the schema then it works.

How to get the connection string from Web.config file.

  private void ViewCystalReport(bool exportall, string crystalid, string crystalname)
    {
        try
        {
            OracleConnectionStringBuilder builder = new OracleConnectionStringBuilder(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
            TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
            Tables CrTables;
            DataSet Ds = new DataSet();
            string dbDataSource = builder.DataSource;
            string userId = builder.UserID;
            string pass = builder.Password;
            ReportDocument cryRptdocUMENT = new ReportDocument();
            string sRptFolder = Server.MapPath("~/CrystalReports");
            string ReportName = crystalid;
            string path = sRptFolder + @"\" + @ReportName + ".rpt";
            cryRptdocUMENT.Load(path);


            ConnectionInfo crConnectionInfo = new ConnectionInfo();
            crConnectionInfo.ServerName = builder.DataSource;
            crConnectionInfo.DatabaseName = string.Empty;
            crConnectionInfo.UserID = builder.UserID;
            crConnectionInfo.Password = builder.Password;


            crConnectionInfo.IntegratedSecurity = false;
            crConnectionInfo.Type = ConnectionInfoType.CRQE;
            CrTables = cryRptdocUMENT.Database.Tables;
            cryRptdocUMENT.SetDatabaseLogon(crConnectionInfo.UserID, crConnectionInfo.Password, crConnectionInfo.ServerName, string.Empty);
        
            //Getting Value from the Array       
            Database database = cryRptdocUMENT.Database;
            Tables tables = database.Tables;


            foreach (CrystalDecisions.CrystalReports.Engine.Table table in tables)
            {
                TableLogOnInfo tableLogOnInfo = table.LogOnInfo;
                tableLogOnInfo.ConnectionInfo = crConnectionInfo;
                table.ApplyLogOnInfo(tableLogOnInfo);             
            }


           
            foreach (InternalConnectionInfo internalConnectionInfo in cryRptdocUMENT.DataSourceConnections)
            {
                // Must set the UseDSNProperties flag to True before setting the database connection
                if (internalConnectionInfo.LogonProperties.ContainsKey("UseDSNProperties"))
                {
                    internalConnectionInfo.LogonProperties.Set("UseDSNProperties", true);
                }
                // Sets the database connection for all objects in the report (ie. main report, tables, sub reports)
                internalConnectionInfo.SetConnection(crConnectionInfo.ServerName, crConnectionInfo.DatabaseName, crConnectionInfo.UserID, crConnectionInfo.Password);               
            }           
            if (ParameterArrayList.Count != 0)
            {
                //Getting Value From the Report (Parameter and Formula Feild)               
                int ParameterFieldCount = cryRptdocUMENT.DataDefinition.ParameterFields.Count;
                for (int i = 0; i < ParameterFieldCount; i++)
                {
                    string paramname = cryRptdocUMENT.DataDefinition.ParameterFields[i].Name;
                    switch (paramname.ToUpper())
                    {
                        case "TRADINGTYPE":
                            cryRptdocUMENT.SetParameterValue(paramname, "T");
                            break;
                        case "HFT":
                            cryRptdocUMENT.SetParameterValue(paramname, Convert.ToBoolean(ParameterArrayList["HFT"]) == true ? "T" : "");
                            break;
                        case "AFS":
                            cryRptdocUMENT.SetParameterValue(paramname, Convert.ToBoolean(ParameterArrayList["AFS"]) == true ? "A" : "");
                            break;
                        case "HTM":
                            cryRptdocUMENT.SetParameterValue(paramname, Convert.ToBoolean(ParameterArrayList["HTM"]) == true ? "H" : "");
                            break;
                        case "M_HFT":
                            cryRptdocUMENT.SetParameterValue(paramname, Convert.ToBoolean(ParameterArrayList["HFT"]) == true ? "T" : "");
                            break;
                        case "M_AFS":
                            cryRptdocUMENT.SetParameterValue(paramname, Convert.ToBoolean(ParameterArrayList["AFS"]) == true ? "A" : "");
                            break;
                        case "M_HTM":
                            cryRptdocUMENT.SetParameterValue(paramname, Convert.ToBoolean(ParameterArrayList["HTM"]) == true ? "H" : "");
                            break;                       
                        default:
                            if (!paramname.Contains("Pm-?"))
                            {
                                if (paramname == "ActualBreach" || paramname == "HistoricalAvgVaR")
                                    break;
                                var pValue = ParameterArrayList.FirstOrDefault(x => x.Key.ToUpper() == paramname.ToUpper());
                                cryRptdocUMENT.SetParameterValue(paramname, pValue.Value);
                            }
                            break;
                    }
                }
            }
            //Set generated report document as Crystal Report viewer report source           
            crystalreport1.ReportSource = cryRptdocUMENT;
            crystalreport1.ToolPanelView = CrystalDecisions.Web.ToolPanelViewType.None;
            crystalreport1.DataBind();
            //crystalreport1.EnableParameterPrompt = false;
        }
        catch (Exception e)
        {
        }
    }

     

Here some of the parameter are not mandatory but it is listed all the parameter from the rpt file.

Kindly send me the quick reply to resolve the issue.

Thank you for your valuable time and help,

Deepan