Ms Sql Server 2000

[wchitamb]

Hie!! this is what I want to do although I am not very sure how to do it. I want to develop the front end using HTML or java (which one is easy and better??) using the middleware ODBC!!! though not very sure how to go about it.

The other general Qns?? Are since this is my first time using MS SQL Server 2000 what are the stages that I need to do in order to complete this project, like I said before this is what I have done
· Created the database
· Created the tables
· Assigned the primary keys
· Assigned the relations (relationship diagram)
. Done the stored procedures
. Roles and users (Granting them different access)


My ultimate goal is to develop a web based database so that workers can log online and be able to view and update the details, as their access rights will allow them.

N:B you can email me on will9898@hotmail.co.uk so that I can give you the full description

[rmiao]

Seems ok on db side. It's not web based database, you need web based application that accesses database on sql server.

[wchitamb]

That sounds encouraging!! So how do I go about it if I want to build the interface do I use HTML or Java as the front end.if I use java will I be using java applets?? I am not so sure how to do it cause I had never done something like this

[rmiao]

Or use asp if your web server is IIS.

[Rawhide]

What do you know how to do already? ASP? PHP? Java?

[wchitamb]

Although i know a bit of Java I intent to use ASP because there is IIS on the machine .now i do not know the step by step of doing this because i want to use ODBC as the middleware and ASP as the front end

[rmiao]

You map post the issue in asp-db forum.

[wchitamb]

Thank You very much for the help it’s working out well but I need to know how to join several tables in stored procedures so that the end form will be from a number of different tables. I have just realised that I did that wrong in my last attempt and that will not as I want when I execute them in ASPas I want when I execute them in ASP