Post reply

HTML Connection to SQL 2005 Question

  • December 11, 2008 at 9:49 am

    #196914

    SQL Gurus:

    I need to provide data from a SQL 2005 database up to four users at my work. I'm not sure if I should use an HTML or ASP page to provide that data. Moreover, I am unsure as to what method (ADO, RDO) I should access the data. My thought early on was to create a view for the HTML to connect to since the table will be updated multiple times.

    Your help would be greatly appreciated.

    Thank you.

    Dave 🙂

  • December 11, 2008 at 11:02 am

    #911235

    Don't use RDO, i am sure this is no longer supported, use ADO.NET

    as for the pages, i would use ASP (either c# or vb.net) and run these from IIS.

    you can open up end-points on sql server to allow HTML connections, but i have never really seen the advantage in doing this over creating an ASP.NET/SQL server website.

  • December 11, 2008 at 11:07 am

    #911238

    Thank you, Steve. Your information is helpful. Are you aware of any sites that could assist in helping me set that up?

    Thanks again,

    Dave

  • December 11, 2008 at 11:11 am

    #911242

    There are thousands of websites that provide .net tutorials

    check out MSDN for some walk-throughs.

    http://msdn.microsoft.com/en-gb/default.aspx

    it really depends on how much experience you have..

  • December 11, 2008 at 11:14 am

    #911244

    Thanks, I'll check it out.

  • December 11, 2008 at 4:45 pm

    #911395

    Thanks, I surfed around a little and found what I need. Thanks for your help. I created a view to access the data from ASP page because the table is constantly being updated.

    Thanks again.

    Dave:D

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply