Solved

Is There a Query Browser for SQL Server?

Posted on 2006-07-17
23
373 Views
Last Modified: 2010-08-05
I'm moderately experienced developing ASP applications with a MySQL database, and I use the MySQL Query Browser application to examine the schema, try out SQL statements, etc.

I'm taking on a new project that uses SQL Server for the backend db server.  I'm fairly certain I cannot use MySQL Query Browser with a SQL Server system.

My question for you is: what tools are available to me that would deliver the functionality of MySQL Query Browser in a SQL Server environment?  

I don't have rights to administer this database -- in fact, I can't even log in to the machine running SQL Server.  I'm particularly interested in robust open-source tools I can use for examining schema, trying out SQL queries, and the like.

Thanks.
0
Comment
Question by:JohnAtkinson
  • 10
  • 8
  • 4
  • +1
23 Comments
 
LVL 26

Expert Comment

by:DireOrbAnt
ID: 17125362
It's called "Query Analyzer".
0
 

Author Comment

by:JohnAtkinson
ID: 17125371
How do I get my hands on it?  Is it open source?
0
 
LVL 26

Expert Comment

by:DireOrbAnt
ID: 17125373
Ah, you don't have any DB to connect to? Try this:
http://www.microsoft.com/sql/editions/express/default.mspx
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 26

Expert Comment

by:DireOrbAnt
ID: 17125379
It's free.
0
 

Author Comment

by:JohnAtkinson
ID: 17125403
Isn't this an entire SQL Server product?  I just need the query tool.
0
 
LVL 25

Expert Comment

by:jrb1
ID: 17125440
Query Analyzer is the interactive tool to connect to SQL Server.
0
 

Author Comment

by:JohnAtkinson
ID: 17125503
How do I get Query Analyzer?
0
 
LVL 26

Expert Comment

by:DireOrbAnt
ID: 17125509
JohnAtkinson, so you do have a remote DB you can query? If so, you'll need Query Analyzer and such. The tools are free for any licensed DB (I think), so if you get your hands on a SQL CD, you can legally install Tools-Only.

SQL 2005 calls it "SQL Server Management Studio Query Editor".

I suppose you could also get the 180 days trial of SQL 2005 and install only the tools.
0
 

Author Comment

by:JohnAtkinson
ID: 17125560
Yes, my client has a live SQL Server-based web application already.  He doesn't own the servers his website or database reside on -- those belong to the web hosting company.  Therefore, I don't know how to get my hands on the tools I need to begin to study the application's schema.
0
 
LVL 25

Expert Comment

by:jrb1
ID: 17125610
If you can ODBC to the database, won't MySQL Query Browser work with that?
0
 
LVL 26

Accepted Solution

by:
DireOrbAnt earned 500 total points
ID: 17125649
At this point, I would go there:
http://www.microsoft.com/sql/downloads/trial-software.mspx

And get my hand on the trial, not the express. Big download I guess, but I would then only install he tools.

Anybody knows what the licensing is for Tools only?

With all of MSFT tools, you'll be able to play with profilers and such, you might need to do some of that in your contract.
0
 

Author Comment

by:JohnAtkinson
ID: 17125757
jrb1, I don't know how I'd go about ODBCing to the database.  I've got the connection information from the ASP source code.  Where (on which system)  does the ODBC connection get created?
0
 
LVL 26

Expert Comment

by:DireOrbAnt
ID: 17125958
On your side. What does the connection looks like in ASP? Remove the password of course :)
0
 

Author Comment

by:JohnAtkinson
ID: 17126211
With fake values, it looks like this:

Dim webServer1, webDB, webLogin, webPass
webServer1="SERVERNAME.COM"
webDB="MyOwnDatabase"
webLogin="MyLoginString"
webPass="MyPassword"

ConnStr = "Provider=sqloledb; Server=" & webServer1 & "; Initial Catalog=" & webDB & "; UID=" & webLogin & "; PWD=" & webPass
0
 
LVL 25

Expert Comment

by:jrb1
ID: 17126337
OK, you should be able to add an ODBC connection to SQL Server.  The server is your webServ1.  The database is webDB. Userid and password are obvious. That should be enough to get an ODBC connection.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 17126462
Are we talking about SQL Server 2000 or 2005?
0
 

Author Comment

by:JohnAtkinson
ID: 17126763
I'm afraid I don't know which version of SQL Server this web host is using.
0
 

Author Comment

by:JohnAtkinson
ID: 17126849
jrb1, I was able to configure a User DSN ODBC connection.  (Is User DSN the right kind?)

I tested the connection and the ODBC configuration wizard said it could connect, and it was able to get the default database name, which is encouraging.

What I don't know how to do now is configure the MySQL Query Browser to use the ODBC connection I just made.

Query Browser asks for the following:

Stored Connection: [I tried entering my User DSN here]

Server host: [I tried entering the real webServer1 value from above, which I successfully used to make the ODBC User DSN)

Port: it's sitting at 3306 right now, and I have no idea whether that's appropriate.

Username and password: [these aren't ambiguous -- I used the values I used during ODBC configuration]

Default Schema: [I tried the webDB value from above]

Any advice on how I can use my ODBC connection with the MySQL Query Browser?
0
 
LVL 25

Expert Comment

by:jrb1
ID: 17127593
You should be able to select ODBC on the default connection screen.  If port 3306 doesn't work, you could try the default port of 1433.
0
 

Author Comment

by:JohnAtkinson
ID: 17177155
I installed SQL Server 2005 Express, but I've been unable to locate Query Analyzer.  I didn't want to leave this question open any longer.  Thanks, everyone, for trying to help.  It looks like Query Analyzer is available only to people who buy The Big Boat, and there's no way to get the MySQL Query Browser reach the SQL Server database.

0
 
LVL 26

Expert Comment

by:DireOrbAnt
ID: 17177444
Go back here:
http://msdn.microsoft.com/vstudio/express/sql/download/

And get SQL Server Management Studio Express.

It's also packaged (with other stuff) into: SQL Server 2005 Express Edition with Advanced Services SP1

0
 

Author Comment

by:JohnAtkinson
ID: 17178262
Thanks, again, DireOrbAnt.  I now have what I need!
0
 
LVL 26

Expert Comment

by:DireOrbAnt
ID: 17178654
Cool!
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Addition to SQL for dynamic fields 6 37
SQL Server 2012 r2 - Varible Table 3 23
Find SQL query used by application 3 17
sql server service accounts 4 20
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

785 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