|
|
Evaluation of ASP-dbAs a member of the ASPAlliance I was able to review a product which is one of our sponsors here at the ASPAlliance. ASP-db is a product which is used to get your database on the web quickly and enable several different capabilities including sorting, filtering, adding records, updating records, deleting records, download (as .csv file), and more that I do not yet know about.The idea behind this product is that if you have already designed your database, you can have a full fledged web based application developed almost within one minute with a few lines of code. Online Documentation is very comprehensive and so is the manual. My Experience with installing ASP-dbI received a link from Mark Harpootlian of ASP-db Sales where I could download a copy of ASP-db. I also received an "ID" file which was my license. My development PC was running Windows 2000 Professional and I already had SQL Server 2000 evaluation and IIS5 already installed.I then downloaded and installed ASP-db on my PC. It was a very painless installation. These are the steps below: 1. Download file 2. Extract ZIP file onto your hard drive 3. Copy the .ID file which they send you into the system32 directory (this is to take it out of eval mode) 4. Register the dll: Control Panel--Administrative Services--Component Services Create a new application and register the ASP-db component. 5. Copy the aspdb folder into your wwwroot folder 6. Run the test page to ensure everything is working correctly. Linked is the code for the asp-test.asp. On your server the test page would be http://localhost/aspdb/default.htm if your files are in c:\inetpub\wwwroot\aspdb\ Connecting to databases with the samples1. There was a basic sample and another which can be edited to match your database parameters.2. I replaced the DSN information with connection strings (DSNless) and ASP-db still worked fine both with Access and SQL Server. Conclusions
|