Without installing MSSQLSERVER can view MSSQL database

Question

Without installing MSSQLSERVER can view MSSQL database

ashok-831066

Right there with Babe

Points: 778
More actions
May 15, 2009 at 4:41 am

#132280

Dear friends,
I have one doubt.I use phpmyadmin for viewing MYSQL Database from my PC without
installing Mysql in my system. Like that somebody can view MSSQL Datbases from their PC
without installing MSSQLServer? Please its very urgent.Give me a suggestion.
Hopes ur reply.
Thanks
Ashok

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Samuel Vella SSCrazy Eights Points: 8055 More actions · Answer 1

You don't have to install the entire SQL Server to access a SQL Server database though, there is the option of just installing the client tools:

http://www.microsoft.com/downloads/details.aspx?amp;displaylang=en&familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

there are some third party tools which will give limited access

like foxy sql

http://rbytes.net/software/foxy-sql-free-review/

ashok-831066 Right there with Babe Points: 778 More actions · Answer 2

Hi,

Thanks for your's reply. Is any other options are available for this one??

Thanks

steveb. SSC-Forever Points: 46733 More actions · Answer 3

For the developers/dbas you can use Visual Studio to view the databases,

but unless your users are developers/dbas , then they should not be accessing the databases directly, you should setup a front-end system for them to view and edit the data.

Lowell SSC Guru Points: 323518 More actions · Answer 4

you can also establish a regualr ADODB connection and connect to the server, without having any SQL client tools installed. there are a lot sample apss that can do that for you.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Vinay Thankur SSCarpal Tunnel Points: 4178 More actions · Answer 5

You can use ODBC - DSN....

This si what i found when google.

http://www.webcheatsheet.com/ASP/database_connection_to_MSSQL.php

HTH.

Thanx.
Vinay

http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay