Home arrow JavaScript arrow Combining North Pole with South Pole: JavaScript with SQL Server 2000
JAVASCRIPT

Combining North Pole with South Pole: JavaScript with SQL Server 2000


Every DBA/database developer would certainly be shocked to think about a relationship between client-side JavaScript and SQL Server 2000. It's real. Not every programmer knows that we can connect and break into SQL Server 2000 simply by using client-side JavaScript. This article covers the positive aspects of connecting to a SQL Server 2000 database lying on the client computer (or the browser computer).

Author Info:
By: Jagadish Chaterjee
Rating: 5 stars5 stars5 stars5 stars5 stars / 21
May 16, 2006
TABLE OF CONTENTS:
  1. · Combining North Pole with South Pole: JavaScript with SQL Server 2000
  2. · How to get a list of all table names available in a SQL Server 2000 database using JavaScript
  3. · How to get a list of all columns along with their table names available in a SQL Server 2000 database using JavaScript
  4. · How to get a list of all views available in a SQL Server 2000 database using JavaScript
  5. · How to get the source code (or SELECT statement) of a single view available in a SQL Server 2000 database using JavaScript
  6. · How to get a list of all stored procedures (along with their source code) available in a SQL Server 2000 database using JavaScript

print this article
SEARCH DEVARTICLES

Combining North Pole with South Pole: JavaScript with SQL Server 2000
(Page 1 of 6 )

If you are new to working with the types of examples in this article, I suggest you go through my series "Advanced JavaScript with Internet Explorer" on this web site.  You can directly copy and paste all of the code samples present in this article into a file with the extension ".htm" and open in Internet Explorer 5.5+.

To successfully connect to the database, the database must be installed with WMI extensions of SQL Server 2000.  First of all, you need to install "WMI SQL Server Administration Provider" on an existing instance of SQL Server 2000 (if it is not already installed). This is not part of the default or custom installation.  You need to install it separately from SQL server installations.  You can find the "WMI SQL Server Administration Provider" installation files at the "x86otherwmi" path of your SQL Server 2000 installation CD. To be frank, I really didn't check this on SQL Server 7.0.  So, my focus will always be on SQL Server 2000 in this article.

How to get a list of all database names existing in a SQL Server 2000 instance using JavaScript

Now, let us try to develop a simple script (JavaScript) which shows the technique for retrieving all database names available in an SQL Server 2000 instance.  The entire code for the sample is as follows:

<!DOCTYPE  HTML  PUBLIC  "-//W3C//DTD HTML 4.0 Transitional//EN">
<html> 
      <head> 
            <title></title> 
            <meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1">
            <meta name="vs_targetSchema" content="http://schemas.microsoft.com/
intellisense/ie5">
 
            <script id="clientEventHandlersJS" language="javascript">
<!--

functionButton1_onclick() { 
      var locator = new ActiveXObject ("WbemScripting.SWbemLocator"); 
      var service = locator.ConnectServer(".","rootMicrosoftSQLServer"); 
      var properties = service.ExecQuery("SELECT Name FROM MSSQL_Database"); 
      var e = new Enumerator (properties); 
      document.write("<table border=1>"); 
      dispHeading(); 
      for (;!e.atEnd();e.moveNext ()) 
      { 
            var p = e.item (); 
            document.write("<tr>"); 
            document.write("<td>" + p.Name + "</td>"); 
            document.write("<td>" + p.SQLServerName + "</td>"); 
            document.write("</tr>"); 
      } 
      document.write("</table>");
}

function
dispHeading()
{ 
      document.write("<thead>"); 
      document.write("<td>Name</td>"); 
      document.write("<td>SQLServerName</td>"); 
      document.write("</thead>");
}

//--> 
            </script> 
      </head> 
      <body>             <INPUT id="Button1" type="button" value="Button" name="Button1"
 language="javascript" onclick="return Button1_onclick()">
      </body>
</html>

In the above code the "meta" tags are not necessary. They have been automatically added by Visual Studio. The above code will automatically list all database names available in the SQL Server 2000 instance belonging to the client.  It mainly lists the names of databases along with the SQL Server Name (in this case we are connecting only to the default instance).

To retrieve this information, I used a built-in class, "MSSQL_Database," available in the "rootMicrosoftSQLServer" namespace. The "for" loop I used in the above code iterates for every database present in the SQL Server instance and finally retrieves only the properties of that database.


blog comments powered by Disqus
JAVASCRIPT ARTICLES

- Project Nashorn to Make Java, JavaScript Wor...
- JavaScript Virus Attacks Tumblr Blogs
- Google Releases Stable Dart Version, JavaScr...
- Khan Academy Unveils New JavaScript Learning...
- Accessing Nitro? There`s an App for That
- JQuery 2.0 Leaving Older IE Versions Behind
- Fastest JavaScript Engine Might Surprise You
- Microsoft Adjusting Chakra for IE 10
- Brendan Eich: We Don`t Need Google Native Cl...
- An Overview of JavaScript Statements
- An Overview of JavaScript Operators
- Overview of JavaScript Variables
- More of the Top jQuery Social Plugins
- The Top jQuery Social Plugins
- More of the Top jQuery Slider Plugins

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 
Support 

Developer Shed Affiliates

 




© 2003-2018 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials