I just ported my SqlServer 2000 database to SqlServer 2005, changed the connection info in my application config file and started the application again. Everything seems to work fine, but when i try to use a retreival stored procedure i now get a database exception:

 Must declare the scalar variable @DebiteurNummer

I am using LLBLGen version 1.0.2004.2. De file version of the runtime libraries for SqlServer is 1.0.20042.50729

Do i only need an updated driver, or must i regenerate and recompile with different runtime libs?

Is the proc in the llblgen pro project in sync with the proc in the db? Apparently the # of parameters generated into the code isn't correct. As this si all generated code, could you check that please?

Found the problem: the SqlServer 2005 instance was created as case sensitive and there were some case mismatches burried in the stored proc code. I should have investigated my own code better.