sp commandtext not initialized

Posts   
 
    
wvnoort
User
Posts: 96
Joined: 06-Jan-2005
# Posted on: 06-Sep-2007 10:42:57   

We are trying to port an existing application build with an earlier version to Sql Server 2005. Upgrade to newer versions of LLBLGen and .NET Framework is not planned until next year, but we need to do the upgrade to Sql Server 2005 now.

The problem is that when a retrieval stored procedure is executed an exception occurs stating that the commandtext is not initialized. Other fetches (tables and views) are OK. This problem only occurs on a database that is created from scratch. A restored database (from a backup from SqlServer 2000) works OK.

Dynamic Query Engine version: 1.0.2004.2

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 06-Sep-2007 11:11:40   

I think a similar question was asked here: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=3678

wvnoort
User
Posts: 96
Joined: 06-Jan-2005
# Posted on: 06-Sep-2007 12:39:52   

Thanks - We traced the problem back to the 'HandleCatalogNameStoredProcedure' method. It my own fault, the database name contained a dot and the split then return 4 parts instead of three flushed