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.

Thanks Sebastain, and while your explanation makes some sense regarding the error message itself I'm now more confused because it also seems like your saying the DAL DOES and DOES NOT support the use of schema other than dbo and that attempting to call a SP in a schema other than dbo does in fact "break" the DAL.

I'll explain... I'm not useing "." in my object names. "HCT_Test" is the name of the stored proc in the "CPP" Schema. 

So if I can't specify the schema in the procedurename argument using dot notation how do I call the HCT_Test SP that is in the CPP schema?

So your saying the answer to my question: "Is the DNN PetaPoco DAL limited to accessing SPs in default schema?" Is infact yes?