Solved

Want to have CGI Scripts to access SQL Database

Posted on 1997-10-16
2
171 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 80 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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

It is a general practice to get rid of old user profiles on a computer  in a LAN environment. As I have been working with a company in a LAN environment where users move from one place to some other place at times. This will make many user profil…
A quick Powershell script I wrote to find old program installations and check versions of a specific file across the network.
Learn the basics of strings in Python: declaration, operations, indices, and slicing. Strings are declared with quotations; for example: s = "string": Strings are immutable.: Strings may be concatenated or multiplied using the addition and multiplic…
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 …

617 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