Shearer Software

DB Admin

Web-based database administration

DBAdmin will run arbitrary SQL statements against a database. It also functions as a quick browsing tool, listing ODBC data sources (DSNs) defined on the server, tables in those databases, and records with field names.

Language PHP and Python. The Python portion is used for listing DSNs from the registry and requires win32all, available separately or as part of ActiveState Python.
Compatibility Windows NT 4 and 2000, ODBC-compatible databases. Tested with Access and SQL Server.
Download This package is not yet available for download.
Installation Copy the files into a protected area of your Web server. (The suggested method is to set NTFS permissions on the conatining folder allowing only database administrators access.) Make sure Python (2.0 or greater) and PHP (4.1.1 recommended) are installed, and the following Script Mappings are defined in IIS:
.pycgi path to python.exe
.php path to php.exe

Back to Andrew's Software Page

Screenshots

SQL input, database browsing DSN list