[2.0] [crystal report] [ms acess] acces à la base de donnée [Résolu]

[Jfrancois57]

Erreur d'accesà la base de donnée sous access

Code c# :

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
 
ReportDocument report = new ReportDocument();
report.Load(Server.MapPath("fichimc1.rpt"));
CrystalReportViewer1.ReportSource = report;
crParameterFields = CrystalReportViewer1.ParameterFieldInfo;
 
           // parameter
            crParameterField_0 = crParameterFields["date_heure"];
            crParameterValues = crParameterField_0.CurrentValues;
            crParameterDiscreteValue_0 = new ParameterDiscreteValue();
            crParameterDiscreteValue_0.Value = "1";
            crParameterValues.Add(crParameterDiscreteValue_0);
 
 
          // base de donnée  
 
          CrystalReportViewer1.ParameterFieldInfo = crParameterFields;
 
            crConnectionInfo = new ConnectionInfo();
crConnectionInfo.ServerName = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=C:\\cergimmo\\ficbase\\prtimmo.mdb;Persist Security Info=False;User ID=Admin;Jet OLEDB:Database Password=";
         //   crConnectionInfo.ServerName = "DRIVER={Microsoft Access Driver (*.mdb)};Data Source=C:\\cergimmo\\ficbase\\prtimmo.mdb;Persist Security Info=False";
            crConnectionInfo.DatabaseName = "prtimmo.mdb";
          //  crConnectionInfo.UserID = "Admin";
          //  crConnectionInfo.Password = "";
 
 
            foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in report.Database.Tables)
            {
 
                TableLogOnInfo logOnInfo = crTable.LogOnInfo;
 
                // Set the connection
                logOnInfo.ConnectionInfo = crConnectionInfo;
 
                // Apply the connection to the table!
                crTable.ApplyLogOnInfo(logOnInfo);
          CrystalReportViewer1.DataBind();

merci pour votre aide

[Jfrancois57]

ci joint le "message d'erreur"