Pete Finnigan's Oracle Security Forum


    
      
        Pete Finnigan's Oracle Security Forum
        (http://www.petefinnigan.com/forum/yabb/YaBB.cgi)
      

        MySQL General >> MySQL General Questions >> Build a database front end with ASP
        
(Message started by: Pete Finnigan on Jul 9^th, 2010, 4:55pm)

Title: Build a database front end with ASP
Post by Pete Finnigan on Jul 9^th, 2010, 4:55pm

There are various ways to interface with a database, including Access and HTML, but one approach takes advantage of legacy Microsoft ASP (with ADO/ADOX) to build a front end.

This method, which I will explain below, uses sample code that provides a quick and dirty application for connecting to a database and for adding, dropping, and viewing table definitions within that database. You can also extend the functionality of the sample code to provide a deeper and broader control of database management functions. Let's dive in and create a sample application.

The sample application
The source code for the sample application is contained within a single file (dbfe.asp). If you want to test the application yourself, you'll need to replace the UNC filename with one that points to an Access database file to which you have full privileges. Alternatively, you could change the whole connection string to whatever you need to connect to the database of your choice.