Digg
del.icio.us
Newsvine
Facebook
Google
LinkedIn
MySpace
Reddit
Slashdot
StumbleUpon
Technorati
Twitter
Windows Live
YahooBuzz
FriendFeedAn ISAPI project to show database information (including images) in frames
The main page generated by the ISAM consist of two frames: the first contains a list of all the records in the database and the second contains the information of a specific record. All the items on the list are links that change the current record on the second frame. You may want to see the html sources for the dinamically generated pages for a better understanding of how the ISAM works.
The full source code for the ISAM is provided, you will have to compile it in order to get a working site. Before compiling you will have to change some constants in the code: the module location and the ODBC data source name and connection string. These constants are found in isam.h and isam.cpp. Once you have compiled the project with correct site location and ODBC constants you will need to take the following steps to install:
- Create a directory under your http server root for the project
- Copy the isam.dll file, the database and the images to this directory
- Create an ODBC system data source for the database (note that the name for the data source must be the same that you set in the ISAM code)
- Create a virtual directory in your http server to access the dll (remember to grant execute rights). The name of the directory must be the same you set in the project
- If necesary, modify the database so the path for the images is valid (you will need Access to do that)
Last updated: 17 June 1998
Comments
Enhanced instructions ISAPI image data base project.
Posted by Legacy on 12/06/1998 12:00amOriginally posted by: David
Enhanced instructions for ISAPI ISAM image data base project.
(ISAM means Indexed Sequential Access Method (ISAM) databases.)
Before compiling you will have to change some constants in the code:
the module location and the ODBC data source name and connection string.
These constants are found in isam.h and isam.cpp.
Once you have compiled the project with correct site location and
ODBC constants you will need to take the following steps to install:
1. Create a directory under your http server root for the project
Copy the isam.dll file and the database to this directory
2. Place the images in any directory you want but see step five.
The HTML files need only be place in your DevStudio project workspace
because they become part of the isam.dll after compilation.
3. Create an ODBC system data source for the database. (DSN means "data source name.")
Use the ODBC icon in Control Panel, Use the System DSN tab, Click Add,
Hi-Lite Microsoft Access Driver(*.mdb), Click Finsh, Enter a name "Images",
Select Images.mdb, Click Ok..
Note that the name for the data source must be the same that you set in the ISAM.h code.
(szConnectString DSN=Images.)
4. Create a virtual directory in your http server to access the dll (remember to grant execute rights).
The name of the directory must be the same you set in the ISAM.cpp (szLocation = MyVirtualDirectory)
5. If necesary, modify the database so the path for the images is valid.
(Open images.mdb in Microsoft Access and change the image paths in the database table field #3.)
6. For fun you may want to change the HTML code. Here is how:
Edit the HTML resources in Dev Studio, Recompile all, stop the WWW service,
copy the isam.dll to it's WWW directory, restart the WWW service.
Reply