Invalid object name 1

[tjherman]

I'm using Visual Studio 2005 (vb code) and have a stored procedure (named sp_Pricing) that supplies the data for a Crystal Report.

When I try to run the report, I get this message:

"Invalid object name (sp_Pricing)"

Here's the code I have so far:

Dim Connection As String = ConfigurationManager.ConnectionStrings("SmartConnectionString").ConnectionString
Dim strSQL As String = "Select * From sp_Pricing"
Dim DA As New SqlDataAdapter(strSQL, Connection)
Dim DS As New DataSet
DA.Fill(DS)

'Get the Report Location
Dim strReportPath As String = Server.MapPath("TJH.rpt")

'Check file exists
If Not IO.File.Exists(strReportPath) Then
Throw (New Exception("Unable to locate report file:" & vbCrLf & strReportPath))
End If

'Assign the datasource and set the properties for Report viewer
Dim rptDocument As New CrystalDecisions.CrystalReports.Engine.ReportDocument

rptDocument.Load(strReportPath)
rptDocument.SetDataSource(DS.Tables(0))
CrystalReportViewer1.ReportSource = rptDocument

******
The error code displays on the "DA.Fill(DS)" line.

Can anyone help me with this?

 

[kxramse]

I noticed that no one responded to your post. I'm not sure how to solve your problem, but I can direct you to forums that are more involed with VS2005 integration with Crystal.

http://forums.asp.net/76/ShowForum.aspx

http://support.businessobjects.com/forums/content.asp?fid=251&sk=5&

Perhaps those links might help?

Keith

 

[tjherman]

Thank you very much for the suggestions!