SAMPLE: Embedcgi.exe CGI Application Shows How to Use Embedded SQL

• Microsoft SQL Server versions 6.5, 7.0
• Microsoft Visual C++, 32-bit Editions, version 6.0

SUMMARY

The Embedcgi.exe sample shows you how to use embedded SQL in a Common Gateway Interface (CGI) application. This sample works with any CGI-compatible Web server; for example, Microsoft Internet Information Server (IIS).

MORE INFORMATION

The following file is available for download from the Microsoft Download Center. Click the file name below to download the file:

Embedcgi.exe

http://www.microsoft.com/downloads/search.asp

Compiling the Sample

1. In the Microsoft Visual C++ Integrated Development Environment (IDE), on the Tools menu, click Options, and then click the Directories tab. Under the Show Directories For box, click Include Files and add the include directory for the SQL Server developer tools. For example:




C:\mssql7\DevTools\Include

2. Click Library Files in the Show Directories For box. Add the lib directory for the SQL Server developer tools. For example:




C:\mssql7\DevTools\lib

3. Open the Embedcgi.dsp project in Visual C++.



4. Modify the Embedtst.sqc file so that the server name, database, user ID, and password variables match your computer configuration. The following two lines need to be changed:

   
   	char szSERVERNAME[]= "MYSERVER.pubs";
   	char szUID_PWD[]= "sa."; 

   Note that this sample uses the SQL Server sample Pubs database.



5. On the Project menu, click Settings, and then click the Custom Build tab. Change the command to point to the correct location of the Nsqlprep.exe file on your computer. For example:




C:\mssql7\Binn\nsqlprep.exe $(InputName)

6. Compile your application.
   
   NOTE: The project contains a reference to a source file named Embedtst.c. This file is created by the Nsqlprep precompiler, so it does not need to exist prior to building the project.

Using the Sample

1. Copy the compiled .exe file into the default Web server directory's SCRIPT subfolder. For IIS, this directory is by default called "SCRIPTS" and is located immediately under the INETPUB folder. For example:




     C:\Inetpub\scripts 

2. Make sure that IIS has sufficient rights to run scripts in this directory.

Calling Your CGI Application from a Web Browser

http://WEBSERVER/scripts/embedded.exe?,,

Additional query words:

Keywords : kbfile kbDatabase kbSQLServ kbVC kbGrpVCDB kbDSupport
Version : winnt:6.0,6.5,7.0
Platform : winnt
Issue type : kbhowto