SQL Web Query

Project License Changed

Fri, 30 Nov 2007 19:18:38 GMT

Microsoft Public License (Ms-PL) This license governs use of the accompanying software. If you use the software, you accept this license. If you do not accept the license, do not use the software. 1. Definitions The terms "reproduce," "reproduction," "derivative works," and "distribution" have the same meaning here as under U.S. copyright law. A "contribution" is the original software, or any additions or changes to the software. A "contributor" is any person that distributes its contribution under this license. "Licensed patents" are a contributor's patent claims that read directly on its contribution. 2. Grant of Rights (A) Copyright Grant- Subject to the terms of this license, including the license conditions and limitations in section 3, each contributor grants you a non-exclusive, worldwide, royalty-free copyright license to reproduce its contribution, prepare derivative works of its contribution, and distribute its contribution or any derivative works that you create. (B) Patent Grant- Subject to the terms of this license, including the license conditions and limitations in section 3, each contributor grants you a non-exclusive, worldwide, royalty-free license under its licensed patents to make, have made, use, sell, offer for sale, import, and/or otherwise dispose of its contribution in the software or derivative works of the contribution in the software. 3. Conditions and Limitations (A) No Trademark License- This license does not grant you rights to use any contributors' name, logo, or trademarks. (B) If you bring a patent claim against any contributor over patents that you claim are infringed by the software, your patent license from such contributor to the software ends automatically. (C) If you distribute any portion of the software, you must retain all copyright, patent, trademark, and attribution notices that are present in the software. (D) If you distribute any portion of the software in source code form, you may do so only under this license by including a complete copy of this license with your distribution. If you distribute any portion of the software in compiled or object code form, you may only do so under a license that complies with this license. (E) The software is licensed "as-is." You bear the risk of using it. The contributors give no express warranties, guarantees or conditions. You may have additional consumer rights under your local laws which this license cannot change. To the extent permitted under your local laws, the contributors exclude the implied warranties of merchantability, fitness for a particular purpose and non-infringement.

Source code checked in

grummer — Tue, 07 Aug 2007 00:22:19 GMT

SQLWebQuery Source

Source code checked in

grummer — Mon, 06 Aug 2007 23:38:10 GMT

SQLWebQuery Source with new security fixes

UPDATED RELEASE: SQL Web Query 1.0 (Aug 06, 2007)

Mon, 06 Aug 2007 23:25:03 GMT

_Supported Operating Systems: Windows 2000 Service Pack 4; Windows Server 2003; Windows XP, Windows VISTA_

*SQL Web Query requires:*
* Microsoft SQL Server 7 SP2 or later
* Microsoft .NET SDK 2.0 or Microsoft Visual Studio .NET 2005
* Microsoft Internet Explorer 6 or later
* Microsoft Internet Information Services (IIS) -- optional, a portable web server* is also distributed with the project
* Microsoft ASP.NET AJAX Extensions (http://go.microsoft.com/fwlink/?LinkID=77296)
* Microsoft ASP.NET AJAX Control Toolkit – optional, may be necessary for editing some parts of the application (http://www.codeplex.com/Release/ProjectReleases.aspx?ProjectName=AtlasControlToolkit)

*Download Instructions*
# Click "Release" tab when you're on the "SQL Web Query" project page.
# Click "SqlWebQuery.zip" link under "Runtime Binaries".
# Click "I Agree" button if you agree with the project license.
# Click "Open" or "Save" the zip file "SqlWebQuery.zip" to your computer.
# Extract the zip file "SqlWebQuery.zip". This will create two folders "SqlAdmin" and "SqlWebQuery"

*Setup Instuctions*
# Create an IIS website (either a website or "Application" on an existing site). If you are installing this on Windows XP or VISTA you will only be able to create an “Application”.
# Enter a description for your new site. This screen will not be presented if you are installing on Windows XP or VISTA.
# Enter the full path and name of the "SqlWebQuery" directory created from the download as the website home directory.
# Make sure that the Application Pool's user has Read and Execute access to the directory.
# Click "Finish" button.
# Make sure the .NET 2.0 is the current ASP.NET runtime. In IIS console, right click the website just created, choose "Properties" option.
# Run the website.
# Browse the list of the files under the website, right click "default.aspx", and click "browse". That will start the web application.

CREATED RELEASE: SQL Web Query 1.0

Mon, 06 Aug 2007 22:25:10 GMT

UPDATED WIKI: Home

grummer — Mon, 06 Aug 2007 22:20:33 GMT

Project Description
The SQL Server Web Query application allows you to run queries on any SQL Server database from anywhere via the web. You can also save queries for later use, or recall stored procedures in the database to run. There are also some very basic intellisense-like tools in the application to make writing queries fast and easy, automatically retrieving table and column names in the database, and completing T-SQL and ODBC statements for you.
Whether you’re at home, at work, or on the go with a laptop or internet-capable cell phone, SQL Server Web Query makes it quick and easy to build and execute queries on a remote SQL Server database.
System Requirements

Supported Operating Systems: Windows 2000 Service Pack 4; Windows Server 2003; Windows XP, Windows VISTA

SQL Web Query requires:

Microsoft SQL Server 7 SP2 or later
Microsoft .NET SDK 2.0 or Microsoft Visual Studio .NET 2005
Microsoft Internet Explorer 6 or later
Microsoft Internet Information Services (IIS) -- optional, a portable web server* is also distributed with the project
Microsoft ASP.NET AJAX Extensions (http://go.microsoft.com/fwlink/?LinkID=77296)
Microsoft ASP.NET AJAX Control Toolkit – optional, may be necessary for editing some parts of the application (http://www.codeplex.com/Release/ProjectReleases.aspx?ProjectName=AtlasControlToolkit)

Download Instructions

Click "Release" tab when you're on the "SQL Web Query" project page.
Click "SqlWebQuery.zip" link under "Runtime Binaries".
Click "I Agree" button if you agree with the project license.
Click "Open" or "Save" the zip file "SqlWebQuery.zip" to your computer.
Extract the zip file "SqlWebQuery.zip". This will create two folders "SqlAdmin" and "SqlWebQuery"

Setup Instuctions

Create an IIS website (either a website or "Application" on an existing site). If you are installing this on Windows XP or VISTA you will only be able to create an “Application”.
Enter a description for your new site. This screen will not be presented if you are installing on Windows XP or VISTA.
Enter the full path and name of the "SqlWebQuery" directory created from the download as the website home directory.
Make sure that the Application Pool's user has Read and Execute access to the directory.
Click "Finish" button.
Make sure the .NET 2.0 is the current ASP.NET runtime. In IIS console, right click the website just created, choose "Properties" option.
Run the website.
Browse the list of the files under the website, right click "default.aspx", and click "browse". That will start the web application.

UPDATED WIKI: Home

grummer — Mon, 06 Aug 2007 22:19:55 GMT

Project Description

The SQL Server Web Query application allows you to run queries on any SQL Server database from anywhere via the web. You can also save queries for later use, or recall stored procedures in the database to run. There are also some very basic intellisense-like tools in the application to make writing queries fast and easy, automatically retrieving table and column names in the database, and completing T-SQL and ODBC statements for you.
Whether you’re at home, at work, or on the go with a laptop or internet-capable cell phone, SQL Server Web Query makes it quick and easy to build and execute queries on a remote SQL Server database.
System Requirements

Supported Operating Systems: Windows 2000 Service Pack 4; Windows Server 2003; Windows XP, Windows VISTA

SQL Web Query requires:

Microsoft SQL Server 7 SP2 or later
Microsoft .NET SDK 2.0 or Microsoft Visual Studio .NET 2005
Microsoft Internet Explorer 6 or later
Microsoft Internet Information Services (IIS) -- optional, a portable web server* is also distributed with the project
Microsoft ASP.NET AJAX Extensions (http://go.microsoft.com/fwlink/?LinkID=77296)
Microsoft ASP.NET AJAX Control Toolkit – optional, may be necessary for editing some parts of the application (http://www.codeplex.com/Release/ProjectReleases.aspx?ProjectName=AtlasControlToolkit)

Download Instructions

Click "Release" tab when you're on the "SQL Web Query" project page.
Click "SqlWebQuery.zip" link under "Runtime Binaries".
Click "I Agree" button if you agree with the project license.
Click "Open" or "Save" the zip file "SqlWebQuery.zip" to your computer.
Extract the zip file "SqlWebQuery.zip". This will create two folders "SqlAdmin" and "SqlWebQuery"

Setup Instuctions

Create an IIS website (either a website or "Application" on an existing site). If you are installing this on Windows XP or VISTA you will only be able to create an “Application”.
Enter a description for your new site. This screen will not be presented if you are installing on Windows XP or VISTA.
Enter the full path and name of the "SqlWebQuery" directory created from the download as the website home directory.
Make sure that the Application Pool's user has Read and Execute access to the directory.
Click "Finish" button.
Make sure the .NET 2.0 is the current ASP.NET runtime. In IIS console, right click the website just created, choose "Properties" option.
Run the website.
Browse the list of the files under the website, right click "default.aspx", and click "browse". That will start the web application.