cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal Reports and database schema, database vendor code 2812

etiennesteyn1
Explorer
0 Kudos
395

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

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

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

Answers (0)