Results 1 to 9 of 9

Thread: Web classes vs RDS

  1. #1
    Guest

    Post

    Greetings

    I would like to access and manipulate MSSQL data over the Internet and using IIS with VB6 (by ADO - OLEDB no ODBC).
    I am in doubt regards two different approaches: Web Classes or RDS. I 'll appreciate any advice from anyone experienced in this field.

    Thanks in advance

    sasha
    [email protected]

  2. #2
    Hyperactive Member compuGEEK's Avatar
    Join Date
    May 1999
    Location
    Mpls,MN,USA
    Posts
    281

    Post

    I'm currently working on a project that uses webclasses and ADO.

    I have not worked with RDS, but Webclasses are very, very useful especially if you're not familiar with ASP. Webclasses are much easier to debug than ASP.

    ------------------

    CompuGEEK

  3. #3
    Guest

    Post

    WebClasses have worked pretty well for me so far. I'm on my second project using webclasses connected to mssql7 data, so far no major unsolvable probs.
    out of curiosity why no odbc?

  4. #4
    Hyperactive Member compuGEEK's Avatar
    Join Date
    May 1999
    Location
    Mpls,MN,USA
    Posts
    281

    Post

    Hi BG,

    When you are connecting to SQL7, are you using stored procedures?

    Also, how do manage state in your project? Just curious...
    Thanks

  5. #5
    Guest

    Post

    I havn't tried to execute a stored procedure from a webclass, I know the execute method on a ADODB.connection object works I have used that so you probably can.

    I use the database to maintain most of my state (user, profile, etc.). For simple values that I just need to pass from one template to another I use hidden input form fields, URLData, or if convenient in the eventname of my user events.

  6. #6
    Guru Clunietp's Avatar
    Join Date
    Oct 1999
    Location
    USA
    Posts
    1,844

    Post

    FYI

    There is a memory leak when using Webclasses, and the apps will not scale to handle more than a few hundred (I think) users at a time before your server crashes.

    Stick with ASP if you guys are doing any MAJOR internet apps


  7. #7
    Guest

    Post

    Hi Clunietp

    Does it mean that you are prefer RDS?

    sasha

  8. #8
    Hyperactive Member compuGEEK's Avatar
    Join Date
    May 1999
    Location
    Mpls,MN,USA
    Posts
    281

    Post

    Clunietp,

    Where did you hear that Webclasses produce a memory leak?

    As long as you set your SQL connection to allow connection pooling, set the appropriate state management in the WebClass app and configure IIS correctly, there should be absolutely no problems.



    ------------------
    CompuGEEK

  9. #9
    Guru Clunietp's Avatar
    Join Date
    Oct 1999
    Location
    USA
    Posts
    1,844

    Post

    what is RDS? Remote Data Service? I don't know much info about that, but the point I was trying to make was that real ASP pages are more scalable than Webclasses.

Posting Permissions

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



Click Here to Expand Forum to Full Width