Analytics Software

Software and Component detail
_________________________________________
Microsoft visual studio 2010
MS .NET Framework
Version 4.0.30319 RTMRel

MYSQL SERVER Database
Version 5.5
MySQL Connector 6.6.4 64 Bit

MySQL ODBC Driver Version 5.2.a

Crystal Report for Visusl Studio 64 Bit 13.0.5
(CRforVS_redist_install_64bit_13_0_5)

Current Setup
_____________
1. I have WebSite in ASP.NET Visual Basic which works fine and is connected to MySQL Database, using MySQl Connector 6.6.4 64 bit
and is using a connection string,defined in web.confg.
2. I am using a Crystal report( It is very complex report, so cannot dare to redo it). Data Source for the report is set using a connection string
DRIVER={MySQL ODBC 5.2a Driver};SERVER=Licensedb;DATABASE=License;pwd=root;PORT=3306;OPTION=3 and this report is called from website using the below code

Dim crystalReport As ReportDocument = New ReportDocument()
Dim repPath As String = Server.MapPath("~/Reports/") + "LicenseReport.rpt"
crystalReport.Load(repPath)
CrystalReportViewer1.ReportSource = crystalReport
crystalReport.SetParameterValue("InstanceID", CInt(Session("sessionInstanceID")))
crystalReport.Refresh()
crystalReport.SetParameterValue("InstanceID", CInt(Session("sessionInstanceID")))
CrystalReportViewer1.Visible = True

3. The above setup works fine, when I run the website from Visual studio 2010. But when i use IIS 7, the aspx page having crystal report viewer control load and its blank.
However it work very well from studio it self.
4. So I changed the setup in point 2, by having a ODBC Data source defined. And changed the report accordingly. It work fine in Visual studio , but from IIS
it gives error "Failed to Open Connection, Failed to Open Connection <Crystal Report File name.rpt>"
5. I tried creating a System DSN and same connection string in IIS Application Connection string. But nothing changed.

Please can anyone point in correct direction. I must admit this is my first website development work, so I might have overlooked some minor details.
Any help would be much appreciated.

Thanks
Dilpreet (ds185045@gmail.com)