Due to a customer requirement I am forced to use classic ASP, so I am wondering if I could use .Net (or maybe JScript which as new features) to try to add some advanced features. I really would like a decent way to connect to SQL Server, so if anyone has any ideas I would appreciate it. Thanks.
Wade
Update:
Amazingly the customer relented and would like to go with ASP.Net now. Thanks for all the help.
You can use JScript for the page scripting language on new pages, but you can't directly use .NET to add new features to classic ASP. Depending on what you need to do, you can write a .net assembly and access it as a COM component, but there is a strong possibility that this is more trouble than it's worth.
Since you talked about accessing SQL Server in classic ASP, I would look here. It may at least point you in the right direction, depending on what you know about classic ASP and visual basic 6.
You can use AspCompat="true" in the aspx page, which makes it compatible with classic asp. The n you can write classic asp type scripting.
check out - http://msdn.microsoft.com/en-us/library/ydy4x04a.aspx
I have some links for you to try
1) .NET COM+ Interop Component with Classic ASP
2) Consume a .NET Assembly from a classic ASP page.
Good luck