ASP.NET 2.0 Crystal Reports Issue with MySQL DB
-
Hi I am trying to display a Crystal Report developed using MySQL database and ASP.NET 2.0 (VS.NET 2005), and for some reason when I pass the database login information to the report it does not accept them (still shows a db login screen). Here is the code: [CODE] Dim cnString = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=servername;DATABASE=dbname;UID=user name;PASSWORD=password;OPTION=3" Dim cn As New OdbcConnection(cnString) cn.Open() Dim MyReport As New CrystalDecisions.CrystalReports.Engine.ReportDocum ent MyReport.Load("C:\Inetpub\wwwroot\Report1.rpt") MyReport.SetDataSource(cnString) MyReport.SetDatabaseLogon("username", "password") MyReport.SetParameterValue("parameter1", "1001") CrystalReportViewer1.ReportSource = MyReport CrystalReportViewer1.DataBind() cn.Close() [/CODE] I have one Crystal Report Viewer and one Crystal Report Source objects on the form. The Crystal Report Source is set to "Report1.rpt" and the Viewer's source is set to that as well. When I run it, I get a parameter field request followed by a server login information request. The actual Report properties are: Database DLL: crdb_odbc.dll DSN: NameOfDSNSource UseDSNProperties: False UserID: databaseUserName I have even tried this: [CODE] Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared Imports System.IO Imports MySql.Data.MySqlClient ' Class Name etc here ... Dim conn As New MySqlConnection conn = New MySqlConnection("Server=servername; Database=dbname; User ID=dbuser; Password=dbpass; charset=utf8;") conn.Open() Dim MyReport As New CrystalDecisions.CrystalReports.Engine.ReportDocum ent MyReport.Load("C:\Inetpub\wwwroot\Report1.rpt") MyReport.SetDataSource("Server=servername; Database=dbname; User ID=dbuser; Password=dbpass; charset=utf8;") MyReport.SetParameterValue("parameter1", "1001") CrystalReportViewer1.ReportSource = MyReport CrystalReportViewer1.DataBind() [/CODE] But so far no luck. Does anyone know what the problem is with it? Any help would be appreciated. Thank You