1 Click DB Pro Software is easy to install 100% "Classic ASP" web server software. No custom components or DLL maintenance nightmares required. Just copy program files into a folder on your server, and start your favorite browser because you are ready to go !
Microsoft IIS or PWS 4.0+ web server required with Active Server Page support, Microsoft Data Access Components 2.1+, and VBScript 5.0+ installed. If your computer runs Windows 95/98/ME/NT/2000/2003/XP/XPsp2 then these components are either freely downloaded from Microsoft or already installed on your machine.
Click here for an ASP File to test your web server compatibility with 1 Click DB
1 Click DB Pro Software works great on most shared ASP hosting providers and is easily configured to run on sessionless server farms.
1 Click DB does not enable all program features for all ADO data sources. Far and away the most advanced support is for Microsoft SQL Server 7.0, 2000, and 2005 with graphic showplan support for query optimization, audit wizard, and advanced GUI for Table and View design. 1 Click DB Support for Microsoft Access is also quite good.
For most business sites, the best argument for using SQL Server over Access is that SQL Server offers much more sophisticated interfaces for programmability, security and backups for your db. There is also an absolutely free version of SQL Server available that is 100% compatible with SQL Server 2005 called Sql Server Express. You can get it from various places; one of which is http://ASP.net.
1 Click DB support for Oracle is limited to Browse-Search-Export and Add-Edit-Delete from Tables and eligible Views. However in using Oracle with Active Server Pages a developer misses out on many of its advantages when used for development with standard Java Server Pages and JDBC or alternative Oracle Objects for OLEDB technology.
1 Click DB is also okay for Browse-Search-Export Add-Edit-Delete from mySQL Tables and Views. However, in using mySQL with Active Server Pages a developer misses out on many of its advantages for development with standard PHP/Apache/Linux combo.
Due to underlying limitations of the standard Microsoft drivers, use of Text or Excel files for public web applications is generally not recommended (except for data imports).
ADO does not resolve datetime types to the millisecond !! Applications requiring greater precision are advised not to use ADO (at least not without special care !). For this reason tables with a date field in its primary key are only editable by 1 Click DB when an separate autonumber/identity can be used to identify the record. Any application using ADO may experience truncation of data beyond the second and this mismatch is the cause of a number of subtle issues associated with using SQL queries using ADO. Also note that SQL Server actually implements date time precision to the one three hundredth of a second and rounds the difference.
The 1 Click DB Pro GUI does not fully support SQL Server User Defined Types. The underlying technical issue is with 1 Click DB Pro's reliance on MS ADO technology to retrieve field type information. There is a prominent warning on current 1 Click DB distributions to indicate this incompatibility. Additional code to support a fuller GUI for for UDT (along with rules, default and UDFs) is planned for future release.
Not all supported databases have the identical features.
SQL Server and Access users please note, Oracle is less forgiving when it comes to object naming and natively supports case sensitive comparisons.