possible to use SqlConnection in ASP Classic?

Discussion in 'ASP .Net' started by jason, May 9, 2005.

  1. jason

    jason Guest

    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
    jason, May 9, 2005
    #1
    1. Advertising

  2. 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.

    "jason" <> wrote in message
    news:...
    >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, May 9, 2005
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Bob
    Replies:
    11
    Views:
    2,122
    Angel Saenz-Badillos[MS]
    Apr 12, 2004
  2. mid
    Replies:
    4
    Views:
    7,265
    Scott Allen
    Dec 14, 2004
  3. =?Utf-8?B?Q2F0YWRtaW4=?=

    ASP.Net SQLConnection leaving orphans

    =?Utf-8?B?Q2F0YWRtaW4=?=, Feb 22, 2005, in forum: ASP .Net
    Replies:
    3
    Views:
    550
    Prodip Saha
    Feb 22, 2005
  4. Mike Kansky

    Force SqlConnection object to use SQLNCLI

    Mike Kansky, Jul 22, 2006, in forum: ASP .Net
    Replies:
    0
    Views:
    466
    Mike Kansky
    Jul 22, 2006
  5. techno

    Ado.Net SqlConnection in Classic ASP

    techno, Feb 28, 2010, in forum: ASP General
    Replies:
    2
    Views:
    1,375
    Bob Barrows
    Feb 28, 2010
Loading...

Share This Page