Is there an OR/M for Classic ASP?

Question

Is there an OR/M (object relational mapper) that can be used in Classic ASP? Even a simplified class object would be a great help in handling simple CRUD tasks.

Yes I know ASP.NET has many and I use a few of them for ASP.NET sites. However this is a legacy e-commerce site that uses ASP/VBScript and a total rewrite it not a possibility.

Answer 1

There is nothing stopping you from using C# or VB.Net and COM Interop to create a DLL that could be read by your classic ASP page. We have done that several times.

MSDN has two good tutorials on COM Interop.

Answer 2

You could use .net through COM Interop, and do your ORM in .net. Another option would be to use Code Smith, or MyGeneration and generate VB6 classes.

Here's some VB6 ORM I have not used or researched any of these: http://www.sparxsystems.com.au/products/ea/features.html

If I find anymore Ill update