I get an error getting the result of a call similar to adapter.FetchEntityCollection(allItems, bucket). The error is: "An exception was caught during the execution of a retrieval query: Invalid column name 'TipoLink'.\r\nInvalid column name 'TipoLink'.. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception."

TipoLink is a colum in the table and it doesn't give any error on the same db on sql2005. When I switch the same application from sql2005 (set in compability mode) to sql2000 I get this error. The db are identical.

Any suggestions? Thanks

TipoLink is a colum in the table and it doesn't give any error on the same db on sql2005. When I switch the same application from sql2005 (set in compability mode) to sql2000 I get this error.

So to switch between both database servers (2000 & 2005), you change the connection string to point to the other database server instance and you change the DQE compatability configuration setting, right?

One way to debug this is to examine the generated SQL query in both cases and try to manually run it against the corresponding database server. Please refer to the LLBLGen Pro manual, "Using the generated code -> Troubleshooting and debugging"