dbTalk Databases Forums  

User interaction with SQL

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss User interaction with SQL in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
CJ
 
Posts: n/a

Default User interaction with SQL - 05-05-2005 , 09:59 AM






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



Reply With Quote
  #2  
Old   
Simon Hayes
 
Posts: n/a

Default Re: User interaction with SQL - 05-06-2005 , 12:15 PM







"CJ" <chrisj (AT) illicom (DOT) net> wrote

Quote:
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




Reply With Quote
  #3  
Old   
Derrick Leggett
 
Posts: n/a

Default Re: User interaction with SQL - 05-07-2005 , 11:35 AM



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" <sql (AT) hayes (DOT) ch> wrote

Quote:
"CJ" <chrisj (AT) illicom (DOT) net> wrote in message
news:kxqee.3372$Cz3.470793 (AT) monger (DOT) 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





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.