on 2021 May 03 12:38 PM
Hi
I just recently made some major changes to an application and in the process i created a new database schema called "Transfers" now my new stored in proc is this case is called "Transfers.CheckStock" the old proc dbo.CheckStock has been deleted.
I updated my mapping in for the report in VS2019 to use the latest procs that have the new schema "Transfers.CheckStock" these report will not work and give me the above error "as per subject". NOTE that did select the corresponding proc in database location editor and updated it too. i could see the owner is "Transfers" and not "dbo"
If i drop and re-create the proc under dbo schema example dbo.CheckStock things work. even after creating a report from scratch using the new schema name it does not work. what am i missing.
Please note that i am using Crystal Report View control in windows forms application. version 13.0.26
here is the example of login code routine
Private Sub SetDBLogonForReport(ByVal myConnectionInfo As ConnectionInfo, ByVal myReportDocument As ReportDocument)
For Each myTable As CrystalDecisions.CrystalReports.Engine.Table In myReportDocument.Database.Tables
Dim myTableLogonInfo As TableLogOnInfo = myTable.LogOnInfo
myTableLogonInfo.ConnectionInfo = myConnectionInfo
myTable.ApplyLogOnInfo(myTableLogonInfo)
Next
End Sub
Request clarification before answering.
CR is simply passing that error code to you, what does it mean?
Maybe this: https://www.sqlservercentral.com/forums/topic/could-not-find-stored-procedure-sql-server-error-2812
Seems like a permission issue....
Don
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
52 | |
10 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.