How to connect to SQL Server database from JavaScript in the browser?

by

You shouldn´t use client javascript to access databases for several reasons (bad practice, security issues, etc) but if you really want to do this, here is an example:

var connection = new ActiveXObject("ADODB.Connection") ;

var connectionstring="Data Source=<server>;Initial Catalog=<catalog>;User ID=<user>;Password=<password>;Provider=SQLOLEDB";

connection.Open(connectionstring);
var rs = new ActiveXObject("ADODB.Recordset");

rs.Open("SELECT * FROM table", connection);
rs.MoveFirst
while(!rs.eof)
{
   document.write(rs.fields(1));
   rs.movenext;
}

rs.close;
connection.close;

A better way to connect to a sql server would be to use some server side language like PHP, Java, .NET, among others. Client javascript should be used only for the interfaces.

And there are rumors of an ancient legend about the existence of server javascript, but this is another story. 😉

More Related Contents:

  1. Export table from database to csv file
  2. How to convert image to byte array using javascript only to store image on sql server?
  3. Custom/Modified 'Fibonacci' Number sequence
  4. Equivalent of and in JavaScript?
  5. jQuery .animate function not responding properly
  6. Why the timer setTimeout returns the first value “2”
  7. HTML5 form required attribute. Set custom validation message?
  8. Javascript object Vs JSON
  9. React won’t load local images
  10. Prevent redirection of Xmlhttprequest
  11. Concatenating variables and strings in React
  12. Check if Point Is Inside A Polygon
  13. Inject a script tag with remote src and wait for it to execute
  14. Is it possible to access an SQLite database from JavaScript?
  15. Merge two arrays with alternating values
  16. Dynamically create and submit form
  17. AJAX request to local file system not working in Chrome? [duplicate]
  18. Detecting combination keypresses (Control, Alt, Shift)?
  19. Merge Array of Objects by Property using Lodash
  20. JSON.stringify output to div in pretty print way
  21. pack / unpack functions for node.js [closed]
  22. Remove JSON element
  23. Country boundries using Google Map API v3
  24. How to set the loudness of HTML5 audio?
  25. How to make a button execute a php script?
  26. Draw radius around a point in Google map
  27. React Router BrowserRouter leads to “404 Not Found – nginx ” error when going to subpage directly without through a home-page click
  28. How to disable Browser back button in Angular 2
  29. Running javascript after page is fully rendered
  30. JQuery Modal Boxes and Iframe

Leave a Comment