Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Want to have CGI Scripts to access SQL Database

Posted on 1997-10-16
2
Medium Priority
?
173 Views
Last Modified: 2013-12-25
I am a novice to the CGI.  I just want to know the process from starting to ending that perform the access SQL database via CGI scripts.  Please tell me in details from the starting point, including where to get interpreter, scripts language.

My email address : warlord@netvigator.com
0
Comment
Question by:warlords
[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 Comments
 

Accepted Solution

by:
larsjordan earned 160 total points
ID: 1830926
You should create the application in Visual Basic 5.0 At the start of the program you should connect to the database using ODBC. When youre connected you can manipulate the database using VB's strong database features.
In order to use CGI in VB you must redirect the stdin and standard stdout.
Remember to diconnect the SQL Server at script exit
Note that this will only work in Windows NT/95 webservers, and you must create a setup program from your VB project
0
 
LVL 7

Expert Comment

by:faster
ID: 1830927
Using VB cause a lot of overhead.  You can consider using perl+odbc driver, since perl is quite powerful.  You can also use c+odbc driver, which gives you the best performance.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In this tutorial I will focus on how to use WhizBase as a tool for sending ICQ messages to ICQ. Here I will use a new technology in WhizBase, published in WhizBase 5.1 version. In this tutorial I will use 3 files, pager.wbsp for the processing, e…
Making a simple AJAX shopping cart Couple years ago I made my first shopping cart, I used iframe and JavaScript, it was very good at that time, there were no sessions or AJAX, I used cookies on clients machine. Today we have more advanced techno…
Learn the basics of if, else, and elif statements in Python 2.7. Use "if" statements to test a specified condition.: The structure of an if statement is as follows: (CODE) Use "else" statements to allow the execution of an alternative, if the …
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

664 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