possible to use SqlConnection in ASP Classic?

[jason]

i was just curious if anyone knows whether or not the SqlConnection
class is exposed to the COM environment? i have a some class libraries
to handle data access that were coded for ASP.NET. the class library
methods expect to be passed an active SqlConnection, which of course
the classic ASP can't provide, unless there is a bridged interface to
the SqlConnection class available through COM.

it's no big deal if it can't be done, i can always modify the class
library to open its own data connections, but i wanted to check if
SqlConnections were possible in ASP classic just in case.

jason

 

[Kevin Spencer]

Anything CAN be done. ASP can communicate only with COM. .Net isn't COM, but
Visual Studio.Net has tools to create Interop COM wrappers for ASP.Net
classes. However, this is a lot of trouble to go to, and has serious
performance issues as well. IOW, it's a bad idea. But yes, it can be done.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
What You Seek Is What You Get.