Solved

Third-party database access tools

Posted on 2014-01-20
14
414 Views
Last Modified: 2014-01-21
From a textbook:   "A person can access the data by using query or reporting tools that are of the DBMS or by using application programs specifically written to access the data."

Please give two examples of application programs specifically written to access the data.
(in SQL Server).
0
Comment
Question by:Peter
  • 3
  • 2
  • 2
  • +4
14 Comments
 
LVL 16

Assisted Solution

by:Surendra Nath
Surendra Nath earned 100 total points
ID: 39795415
in here the textbox is refering the application programs that may be written application layer

generally using .NET or JAVA technologies.
in order to connect to SQL Server they generally use the ODBC.
0
 
LVL 2

Assisted Solution

by:jaLouden
jaLouden earned 200 total points
ID: 39795419
Hey jonmarsh44,

You can use report Builder that ships with Sql Server Reporting Services, or you can use Sql Server Management Studio that is a part of the client tools install within Sql server.

There are many 3rd party tools that will do it as well. Toad for SQl by Quest, and squirrel can be used to test all sorts of jDBC drivers to a sql server.

Is this for an Essay or General Knowledge?

Cheers
JL
0
 
LVL 2

Expert Comment

by:jaLouden
ID: 39795425
Actually  Surendra Ganti is right on the money with his answer :)
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 39795426
Seems like an assignment question to me ?
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 39795545
The first one is SQL Server Management Studio which is usually used as an Admin interface but you can also do SQL queries with it.  http://en.wikipedia.org/wiki/SQL_Server_Management_Studio
0
 
LVL 51

Expert Comment

by:Mark Wills
ID: 39796301
@jonmarsh44

What is it that you don't understand ?

While we cannot give you the answer, we can certainly help resolve any misunderstanding or confusion.
0
 

Author Comment

by:Peter
ID: 39797304
I'm truly surprised. No, this is not a homework assignment; there is no academic dishonesty going on here. I'm a newbie to databases. I don't think I phrased my question correctly.

One response said:  "There are many 3rd party tools that will do it as well. Toad for SQl by Quest, and squirrel can be used to test all sorts of jDBC drivers to a sql server."  That's very close to the answer I was hoping for but I cannot visualize how , for example, Toad, accesses the data.

What happens? Is it that when you install Toad part of the installation requires you to recognize that SQL Server is there? How does Toad know that a SQL Server database is on the hard drive?  (I also can't visualize testing jDBC drivers but I'll do with an answer just for Toad.)  After all, my professor might get suspicious.

Just kidding!
0
 
LVL 37

Assisted Solution

by:ValentinoV
ValentinoV earned 100 total points
ID: 39797439
So you're looking for info on how applications connect to SQL Server, that might get complicated.  Let's assume we'll focus on the most common protocol used: TCP.  The SQL Server service listens for incoming connections on a certain port.  Well, it's actually even more complicated: the SQL Server Browser service listens for incoming connections.  The reason for this is because it's possible to install multiple SQL Server instances on the same machine.

More details: SQL Server Browser Service

Applications use a connection string to connect to SQL Server.  Here's what one looks like for Windows authentication:

Initial Catalog=MyDb;Data Source=MyServer;Integrated Security=SSPI;

Open in new window

PS: your question really sounds academical...
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 39797666
I still recommend Microsoft's SQL Server Management Studio as the first SQL tool you should have.  It performs both the admin functions and SQL queries for a server.  Also allows several connection methods and can be used with remote servers too.
0
 

Author Comment

by:Peter
ID: 39798611
Thanks to all.  In particular, thank you Mr. Horn for your informative - and humorous - comments.  I shall comply.
0
 
LVL 2

Assisted Solution

by:jaLouden
jaLouden earned 200 total points
ID: 39798613
Hey JonMarsh

Suggest you have a look at the following doco's

Outlines ODBC
http://support.microsoft.com/kb/110093
http://www.datadirect.com/resources/resource-library/odbc-developer-center/odbc-faqs/how-does-odbc-work

How ever, guessing on where your coming from the best place to start is Books Online. http://technet.microsoft.com/en-us/library/ms130214.aspx

Grab a eval version of SQL, or even the express edition go through the getting started guide in books online
0
 
LVL 51

Accepted Solution

by:
Mark Wills earned 100 total points
ID: 39798698
There are several ways in which an app can connect to a database.

The bottom line is always "you tell it how".

Having said that, sometimes it is not quite as obvious, or the App is smart enough to go look for a database. Or you are prompted / have a wizard to help...

For example, when you Install SQL Server, it will (can) install Sql Server Management Studio and because it is part of the installation pretty much knows the detail about the database system as it is being installed.

However, it is also possible to "connect" to another SQL server instance from SSMS. When you first fire up SSMS it shows a "connection" dialogue box and you have to tell it which instance to connect to.

Once connected to an instance of SQL Server, you have access to all the databases in that instance.

Now SSMS does that by checking what SQL Server instances are available on that server.

Sql server runs as a service, so pretty easy for apps to see what services are available.

Might like to read ValentinoV's post above for : SQL Server Browser Service


For other Apps, they sometimes install their own version of the database and can either add that database to an existing instance of SQL Server or add an extra instance of SQL Server.

Somewhere, the App will build a connection string to a specific database. Now, that connection string might be pre-configured (for example a web app accessing a database over the Internet).

That connection string can be stored as in a config / ini / file (etc) and usually includes the connection properties such as Server, Database, and the permissions to access (such as username and password or maybe windows authentication). It can also be "driver" dependant like ODBC or Native, and then with different "providers" like JDBC, Net .

With something like Excel, you can build the ODBC datasource and then you can connect via that datasource, or use the Wizard (http://office.microsoft.com/en-au/excel-help/connect-a-sql-server-database-to-your-workbook-HA103791059.aspx)

The bottom line is you actually tell the App how top connect to a database, albeit in some circumstances it can appear to be automated (or a wizard).

Might like a very general overview from wiki : http://en.wikipedia.org/wiki/Database_connection

Might like to read about connection strings : http://www.connectionstrings.com/sql-server/ you will note they are fairly similar, but it does depend on what your app is doing and how it has been programmed.

And yes, read up on those MS links above...

Check out the SSMS connection wizard below...

SSMS connection wizard
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question