SQL EDITOR

[seminar class]

Presented by:
Joy Upadhyay
Anuran Sarkar
Soham Mukherjee
Animesh Jana

---

[attachment=12158]
SQL EDITOR
OBJECTIVES
 We are going to assemble two Data Base software ( MS SQL Server & MS ACCESS) in a single program . It will make our database language fully workable for both.
 This program is fully based on user - program interaction . This is the positive side of this program . This program can be defined as much more user friendly than the other programs.
 This program guides in almost every cases so any non programmer person who has little bit idea of SQL query he/she can easily work with this program . So simplicity of this program is one of our objectives .
 The above mentioned objectives shows the strength of our program . People will accept this program for it’s facilities.
 In future following our program new more powerful software on Data Base handling , can be made.
HARDWARE & SOFTWARE REQIREMENTS
Hardware Requirement
 256 MB RAM ( preferable 512 MB RAM)
 40 GB HARD DISK
Software Requirements
 Visual Basic 6.0
 MS ACCESS
 MS SQL Server
 Operating System –
Windows 98, XP
DATA FLOW DIAGRAM OF OUR SOFTWARE
SYSTEM IMPLIMENTATION
For MS ACCESS Connection:
 Firstly we have designed forms according to our planning . We have used VB tools like menu bar , textboxes , labels , command buttons , timer , ADODB (for database connection ) , Data Grid, AODC etc.
 We have created database tables using MS ACCESS .
 We have connected our form with database table using ADODB object and connection event .
 Using this ADODC we are accessing the data records .
For MS SQL Server Connection:
 For the SQL server connection we should have the software of SQL server installed in our machine .
 We have created a connection page link between SQL server and VB 6.0 form using the ADODB object operation in VB 6.0 tool .
 We wrote the code for accessing the data records from SQL tables under cmdConnect_ Click() and accessing the object we wrote the code under cmdExecute_Click() .
USER MANUAL
Here user manual is given for the users of our software .Kindly follow these guide .
 Open the SQLEditor folder first .
 Click on the project 1. vbp file.
 Now VB Project file will be loaded.
 Select the run button or select the Run option from the menu bar.
 After form 2 opened , go top menu bar and select database file name with it’s full path description from the File option of menu bar.
 Select database type & press connect button .
 Now write your SQL query in the mentioned place .
 Check the validity of your query by pressing Validity button .
 If query is valid press execute button and see the result and if message indicates invalid query rewrite your query and again check validity of it .
 Cut , Copy , Paste options can be found in Edit menu bar option .These tasks can be done by the shortcut keys which are assigned with each options.
[ N.B : As we have MS OFFICE installed in our machine , so we have not to install the MS ACCESS . But for accessing SQL database we have to install the SQL Server Express first to SQL query in our Software . ]
LIMITATIONS
 As we are working with two different types of database language in a single form , so this form is becoming clumsy.
 For accessing any record we have to write queries . So it is difficult use to a person who has no idea on Structured Query Language .
 Total Software system design is complex , so it is little bit tuff to understand.
 Too many objects are created , which are linked up complexly .So the coding is too much complex to understand .
 Our project is limited to use on Microsoft technology only.
SCOPE OF OUR PROJECT
 Their is scope that our software should be used for other types of Data Base Management System ( such as ORACLE , MySQL , SYBASE etc. ) .
 If the project is implemented using platform Independent language like JAVA , the software can be used in any Operating System ( Windows / Linux ) for various database connectivity .
 In place of Active Data Base Object & Data Control ( ADOBC) if we use Open Data Base Connectivity ( ODBC ) , our project will open various database connectivity .
 Instead of writing pure SQL queries, If we can manage to provide GUI based interface which will substitute SQL queries, then non-SQL knowledged person can use this software.