Professional Web Applications Themes

Accessing ADO.NET data provider from ASP "classic" page - ASP.NET General

I'm not sure if this will be helpful to you, but here's what I know.... You can write a function in your codebehind that uses whatever you want to get your data, and then call that function from your classic ASP code. Just make your function return a recordset or whatever you want to store your data in. "Stephen Walch" <swalchproposion.com> wrote in message news:u8Z$hndXDHA.888TK2MSFTNGP10.phx.gbl... > I have a third-party ADO.NET data provider that I want to use from an ASP > page. I want to avoid resorting to ADO/ODBC due to the quality of the > "legacy" data driver, ...

  1. #1

    Default Re: Accessing ADO.NET data provider from ASP "classic" page

    I'm not sure if this will be helpful to you, but here's what I know....

    You can write a function in your codebehind that uses whatever you want to
    get your data, and then call that function from your classic ASP code. Just
    make your function return a recordset or whatever you want to store your
    data in.

    "Stephen Walch" <swalchproposion.com> wrote in message
    news:u8Z$hndXDHA.888TK2MSFTNGP10.phx.gbl...
    > I have a third-party ADO.NET data provider that I want to use from an ASP
    > page. I want to avoid resorting to ADO/ODBC due to the quality of the
    > "legacy" data driver, so I really need to find a solution that will allow
    > the use of my ADO.NET data provider. The ADO.NET interfaces do not seem
    to
    > be designed with COM interop in mind, so simply generating a COM wrapper
    > seems to be out of the question.
    >
    > So far, I can think of two possible solutions: (1) write an intermediate
    > wrapper class with COM-friendly interfaces and (2) find someone who has
    > written a generic ADO to ADO.NET interface. Before embarking on this
    > project, I thought I would check in here to see if anyone had any
    pointers.
    >
    > Thanks,
    >
    > Steve
    >
    >

    Joe Bleaux Guest

  2. #2

    Default RE: Accessing ADO.NET data provider from ASP "classic" page

    Hi Stephen,

    I think you have to create a wrapper for ADO.NET, for example a class
    library supporting COM interop,It is not necessary to implement all
    interface in ADO, you can just expose any required interface by the ASP
    appliaction. For example, a Getvalue and Setvalue method. You can treat it
    as a "data layer" in your design. Anyway, you also can coosider upgrading
    to ASP.NET and you wouldn't lost much for it.

    Luke

    "Microsoft Security Announcement: Have you installed the patch for
    Microsoft Security Bulletin MS03-026?? If not Microsoft strongly advises
    you to review the information at the following link regarding Microsoft
    Security Bulletin MS03-026
    [url]http://www.microsoft.com/security/security_bulletins/ms03-026.asp[/url] and/or to
    visit Windows Update at [url]http://windowsupdate.microsoft.com[/url] to install the
    patch. Running the SCAN program from the Windows Update site will help to
    insure you are current with all security patches, not just MS03-026."

    MSFT Guest

Similar Threads

  1. "Page" and "Rect" props of the Field prop in Javascript API
    By ArtIn_Act@adobeforums.com in forum Adobe Acrobat SDK
    Replies: 8
    Last Post: March 19th, 05:35 PM
  2. CFINPUT type="radio" w/ "value" requires "label"
    By Iceborer in forum Macromedia ColdFusion
    Replies: 2
    Last Post: February 21st, 06:16 PM
  3. Can't choose "page setup" or "print" - Mac OS 9x
    By chris.. webforumsuser@macromedia.com in forum Macromedia Freehand
    Replies: 0
    Last Post: November 19th, 12:20 PM
  4. Replies: 1
    Last Post: July 20th, 08:30 AM
  5. "Start" "Program" "Menu" list is empty
    By Pete in forum Windows XP/2000/ME
    Replies: 2
    Last Post: July 10th, 10:42 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139