Hi,

     I am using vs2008 and Crystal Reports 9
for a windows application using c#

i am getting the following error
""Logon failed.
Details: IM002:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Error in File C:\DOCUME~1\Zafar\LOCALS~1\Temp\RptAngio {E983CDAD-A4E6-4BDD-8420-DD48839EF293}.rpt:
Unable to connect: incorrect log on parameters.""

this is my code


 rptObj = new ReportDocument();
            ConnectionInfo oConnectionInfo = new ConnectionInfo();
            TableLogOnInfo oTableLogOnInfo = new TableLogOnInfo();


            oConnectionInfo.ServerName = "win2k3";
            oConnectionInfo.DatabaseName = "HMS";
            oConnectionInfo.UserID = "dhmc";
            oConnectionInfo.Password = "dhmc152jt";

            rptObj.Load(@"G:\UpGrade\Angio\DotNet\OPDAngio\UI\Reports\RptAngio.rpt");

            foreach (CrystalDecisions.CrystalReports.Engine.Table oTable in rptObj.Database.Tables)
            {
                oTableLogOnInfo = oTable.LogOnInfo;
                oTableLogOnInfo.ConnectionInfo = oConnectionInfo;
                oTable.ApplyLogOnInfo(oTableLogOnInfo);
            }

            for (int i = 0; i <= rptObj.Database.Tables.Count - 1; i++)
            {
                rptObj.Database.Tables.Location = oConnectionInfo.DatabaseName + "." + "dbo" + "." + rptObj.Database.Tables.Location.Substring(rptObj.Database.Tables.Location.LastIndexOf(".") + 1);
            }


this is my connection
<add name="AngioCONNECTION"  connectionString="Data Source=win2k3;Initial Catalog=HMS;User Id=dhmc;pwd=dhmc152jt;" providerName="System.Data.SQLOLEDB" />



can anyone help me on this problem?
Regards


Edited by Sagitariusmzi - 27 Aug 2010 at 8:16pm