SQL Reporter (Freeware)

SQL Reporter is a simple Reporting Tool for SQL Databases
(currently tested with MySQL and SQL Server).

Before you start choose a Connect String for each Database:




1. For MySQL Databases use in Toolbar to define an ODBC User DSN:
   - As Driver use MySQL ODBC 8.0 ANSI Driver
   - Configure an User with read rights on your Database and a Password
   

   

   - Specify the Connect String: DSN= in the SQL Reporter Settings.
   

   
   You also may change the Root Directory:
   Each Database uses a folder Root Directory\Database Name.

2. For SQL Server you have 3 Options:
   
   • ADO: Server=tcp:sqlsrv.org.net; Database=YourDB; Integrated Security=true
   • OLE: Provider=sqloledb; Server=sqlsrv.org.net; Database=YourDB; Integrated Security=SSPI
   • ODBC: Use in Toolbar to define an ODBC User DSN:
     - Enter a name for the DSN, a description and the name of your SQL Server.
     - Use Windows Authentication and set the Standard DB to the Name of your SQL Database.
     - Specify the Connect String: DSN= in the SQL Reporter Settings.
3. SQL Reporter Features:

   Status	Feature
   	Show DB Properties
   	Show DB Schema
   	Define Custom Reports with Custom Queries
   	Export CSV Reports
   	...

SQL Reporter Version 0.9.0.5 (C#, .NET 4)
sqlrepo.exe Any CPU
sqlrepo.chm Help File