User interaction with SQL

[CJ]

I am a Windows admin who knows how to administer SQL server, but I don't
have any experience in creating a data interface so that regular users, who
don't know anything about SQL commands, can manipulate the data.

Any good books or suggestions? Basically I want to be able to create
something possibly by users using a web browser. I have some Perl scripting
experience if that helps.

Thanks,
CJ

[Simon Hayes]

"CJ" <ch****@illicom.net> wrote in message
news:kx*******************@monger.newsread.com...

I am a Windows admin who knows how to administer SQL server, but I don't
have any experience in creating a data interface so that regular users,
who
don't know anything about SQL commands, can manipulate the data.

Any good books or suggestions? Basically I want to be able to create
something possibly by users using a web browser. I have some Perl
scripting
experience if that helps.

Thanks,
CJ

That's a rather open question - you're basically asking how to build a
front-end application for working with MSSQL. There are plenty of possible
ways to do it, such as using ASP or PHP for a web interface, Access forms, a
full .NET Windows application etc.

It's hard to give any specific advice, but I'd suggest that the first thing
to do is identify what the application is for, and go from there. For tasks
like data entry or reporting, you can probably find plenty of samples via
Google; building a business application may be a more complicated story.

Simon

[Derrick Leggett]

You might want to check out www.asp.net It's a good site to just get
started. They have samples, tutorials, etc that will walk you through the
process. It will also help you pick up an entirely new skillset, which is
always a good thing. :)
"Simon Hayes" <sq*@hayes.ch> wrote in message
news:42**********@news.bluewin.ch...

"CJ" <ch****@illicom.net> wrote in message
news:kx*******************@monger.newsread.com...

I am a Windows admin who knows how to administer SQL server, but I don't
have any experience in creating a data interface so that regular users,
who
don't know anything about SQL commands, can manipulate the data.

Any good books or suggestions? Basically I want to be able to create
something possibly by users using a web browser. I have some Perl
scripting
experience if that helps.

Thanks,
CJ

That's a rather open question - you're basically asking how to build a
front-end application for working with MSSQL. There are plenty of possible
ways to do it, such as using ASP or PHP for a web interface, Access forms,

a full .NET Windows application etc.

It's hard to give any specific advice, but I'd suggest that the first thing to do is identify what the application is for, and go from there. For tasks like data entry or reporting, you can probably find plenty of samples via
Google; building a business application may be a more complicated story.

Simon