Solved

SQL server, IIS, VBscript

Posted on 1998-05-21
2
195 Views
Last Modified: 2011-10-03
My company have 1 SQL server and 1 Internet Information server.
I have want to write a VB script to build an intranet applicaiton to access the SQL server via Internet Information server.

Can you tell me what is simplest way to do this task?
0
Comment
Question by:cstsang
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 

Accepted Solution

by:
avla earned 190 total points
ID: 1090041

It seems to me that the best way to build an Intranet db solution by using IIS is through Active Server Pages. They have a VB-type syntax and allow for very easy retrieval and update of data within any ODBC compliant database, including SQL Server.  You can also use VBScript for client side scripting in conjunction with ASP.

For more information on ASP's, I advocate checking out
   http://www.genusa.com/asp.  This site has a lot of information on how to create  applications using ASP. It also has plenty of links to other ASP resources.

I hope this helps and just ask if you would like more information.

a.
0
 

Expert Comment

by:avla
ID: 1090042
PS You  have duplicate questions posted. You may want to delete one to keep the points.
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Query Task 11 44
sql query 5 44
SQL- GROUP BY 4 26
add stored proc on publlication 4 20
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question