Start options:
Normal catalog name is "Hermes", test catalog name is "Hermes.Client"
Error During Call of
private string CreateCorrectStoredProcedureName(string storedProcedureName)
{
DynamicQueryEngine dqe = (DynamicQueryEngine)CreateDynamicQueryEngine();
string procName = dqe.GetNewPerCallStoredProcedureName(storedProcedureName);
return DynamicQueryEngine.GetNewStoredProcedureName(procName);
}
storedProcedureName:"[Hermes].[dbo].[AufgabeList]"
dqe.GetNewPerCallStoredProcedureName(storedProcedureName) returns:
"Hermes.Client.[dbo].[AufgabeList]" (= procName in next method call)
DynamicQueryEngine.GetNewStoredProcedureName(procName) returns
"Hermes.Client.[dbo]"
The "CallRetrievalStoredProcedure" in DataAccessAdapter.cs fails with this name logically in line "adapter.Fill(tableToFill);"
Error message:
Could not find server 'Hermes' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
What kind of "CatalogNameToUse-Names" are not supported ?
The Use of "sqlServerCatalogNameOverwrites" gets the same result.
Change the "Hermes.Client.[dbo].[AufgabeList]" to "[Hermes.Client].[dbo].[AufgabeList]" manually before calling DynamicQueryEngine.GetNewStoredProcedureName method fixes the error.
Also change the Testname to "Hermes_Client"
Thanks
