Please someone tell me this ain't so! :-)
I'm getting this error inside Visual Studio:
An exception of type 'System.Data.SqlClient.SqlException' occurred in PetaPoco.dll but was not handled in user code
Additional information: Database 'dbo' does not exist. Make sure that the name is entered correctly.
When this line is executed:
Success = DotNetNuke.Data.DataProvider.Instance().ExecuteScalar(Of String)("CPP.HCT_Test", "Bob", 0)
BUT this line WORKS as expected:
Success = DotNetNuke.Data.DataProvider.Instance().ExecuteScalar(Of String)("HCT_Test", "Bob", 0)
The only obvious difference... I'm calling a SP that's not in the dbo schema. So it appears that the DNN PetaPoco DAL has a problem using somthing other that the default schema, because the error message "Database 'dbo' does not exist." does not make any sense. There is no database called "dbo" only a schema and it does exist.