ASP.NET

ASP.NET RSS

ASP.NET Crystal Report ODBC MySQL

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: May 2005

Posts: 7

Reputation: digioz is an unknown quantity at this point

Solved Threads: 0

digioz

Offline

Newbie Poster

ASP.NET Crystal Report ODBC MySQL

Sep 23rd, 2006

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:

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
 
		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()
		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()

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:

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
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()
 
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()

But so far no luck. Does anyone know what the problem is with it? Any help would be appreciated.

Thank You

•

Join Date: Mar 2007

Posts: 1

Reputation: jeni73 is an unknown quantity at this point

Solved Threads: 0

jeni73

Offline

Newbie Poster

Re: ASP.NET Crystal Report ODBC MySQL

Mar 1st, 2007

Have you tried just passing the database login for the crystal report?

Try this guide and see if it helps:

http://www.instantcrystal.net/instantguide.aspx

•

Join Date: May 2005

Posts: 7

Reputation: digioz is an unknown quantity at this point

Solved Threads: 0

digioz

Offline

Newbie Poster

Re: ASP.NET Crystal Report ODBC MySQL

Mar 2nd, 2007

•

Originally Posted by jeni73

Have you tried just passing the database login for the crystal report?

Try this guide and see if it helps:

http://www.instantcrystal.net/instantguide.aspx

Thank you. I actually did solve my problem a few month ago. The only thing I was doing wrong was I was trying to pass the database login information to the report, while setting the wizard that comes with the Crystal Report Viewer at the same time! I took out the information in the wizard and it worked like a charm.