Cant see data on shared web server

[Jupiter]

Locally data can be seen, but when uploaded to whared web server, report dosent show any record. Here is the code

<%

@ Register assembly="Telerik.ReportViewer.WebForms, Version=4.2.10.1221, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" namespace="Telerik.ReportViewer.WebForms" tagprefix="telerik" %>

 

 <%

@ Import Namespace="System.Collections.Generic" %>

 

 <%

@ Import Namespace="System.Data" %>

 

 <%

@ Import Namespace="System.Data.sqlClient" %>

 

 <%

@ Import Namespace="Telerik.Reporting" %>

 

 <%

@ Import Namespace="Telerik.ReportViewer.WebForms" %>

 

 <%

@ Import Namespace="UnityTelerik" %>

 

 

page load code:

Con.Close()

Con.Open()

 

Dim dts As New  DataSet

 

 

da =

New SqlDataAdapter("select * from purchase order by lot_no", Con)

 

 da.Fill(dts,

"purchase")

 

  

 

Dim objectDataSource As New

Telerik.Reporting.ObjectDataSource()

 objectDataSource.DataSource = dts.Tables(0)

  

 

Dim c As New Report1

 c.DataSource = objectDataSource

 

ReportViewer1.Report = c

 ReportViewer1.RefreshReport()

 

Please advice me. to see my uploaded page visit telerik.mallikasoft.com

[Steve]

Hello Jupiter,

The code provided looks correct and the fact it does not work on the web server only means that most likely the connectionString is not correct.

Regards,
Steve
the Telerik team

[Jupiter]

Hi Steve,

 

Thank you. I really appreciate your help to find out the reason. i had to modify connection string in web config file.