How to Establish an ODBC Connection to the SQL Database. Windows 7 includes an ODBC manager that lets you connect from your desktop to a SQL server. You create a data source name (DSN) to save ...

I would like the user to be able to click a button on the web page that will run a SQL query (canned report) and export the result data to an Excel spreadsheet. The data does not need to display ...

SQL Plus opens a dialog box for logging into your Oracle database. Type your Oracle database username and password into the dialog box and then click the "OK" button.