Database Management Systems	Signin
Home | Syllabus |Assignments | SQL Tutorial | SQL Learn | Quick SQL | Downloads | Handouts | MY Page | Contact

Downloads

Databases for SQL Query

SQL Query 1.0

SQL Query is a simple Windows tool to connect and query databases. It supports almost all databases that have OLEDB drivers. It uses connect files, that contain connection information to make a connection to the database. You can download this software and use it for free. If you require source code, u could contact me.

Prerequisites:

In order to run SQL Query you need Microsoft .NET framework. You can download it here

QuickStart

When you double click on the SQLQuery.exe it will ask you to give a connect file. A connect file is a normal text file that contains connection information in the first line. An Example connect file and sample database is provided to you in the ZIP file

Here are some examples of connect files.

MS Access
-------------------------------------
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=sample.mdb

Oracle
-------------------------------------
Provider=MSDAORA;Data Source=liu;User ID=uid;Password=pwd

SQL Server
-------------------------------------
With Windows Auth:-
Provider=SQLOLEDB;Data Source=SERVER.com;Integrated Security=SSPI;Initial Catalog=LIU
With SQL Auth:-
Provider=SQLOLEDB;Data Source=SERVER.com;User Id=uid;Password=pwd;Initial Catalog=LIU

Once connected you will see the all the tables in the connected database.

Screen Shots