I was writing an application with Telerik ORM. Initially, the project was built to run on SQL Server 2005. After compiling the Data Layer in to a dll file, it worked fine when placed in the bin folder of the Web Application (together with the rest of the other dll, i.e Telerik.OpenAccess.dll. etc....
After a while, I realised that the targetted database is SQL Server 2000. I tried to change the configuration in Web.Config to point tot he SQL Server 2000 (pointing to a database with the same db structure). However, I encounter an error that says that it only works for SQL Server 2005 and above.
I had to recompile the data layer again to make it work on SQL Server 2000. I also needed to add an extra dll file called Telerik.OpenAccess.NTDS.dll.
I was wondering, if there there is a way for me to switch between Microsoft SQL 2005 and Microsoft SQL 2000 just by changing something in web.config instead of rebuilding the entire data layer? Also, is it correct for me to add the Telerik.OpenAccess.NTDS.dll in the bin folder? I read the deployment documents and it is not one of the recommended dlls that had to be present in the bin folder.