Search
 
SCRIPT & CODE EXAMPLE
 

JAVASCRIPT

Connect MSSQL With JavaScript

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;
Comment

PREVIOUS NEXT
Code Example
Javascript :: how to use if condition in jquery validation 
Javascript :: to higher case js 
Javascript :: comentário jsx 
Javascript :: Mongoose and multiple database in single node.js project 
Javascript :: jQ - on image load 
Javascript :: sequelize get all data 
Javascript :: array from string js 
Javascript :: JavaScript BLOCK ENTER 
Javascript :: delete element from array js 
Javascript :: how to check electron verion 
Javascript :: animejs reduce the speed 
Javascript :: attributes in same line prettier 
Javascript :: javascript create form element 
Javascript :: cypress visible 
Javascript :: base64 to pdf in replace nodejs 
Javascript :: get size of array in bytes javascript 
Javascript :: assign random colors react chartjs 
Javascript :: how to display date in javascript 
Javascript :: ckeditor config 
Javascript :: javascript remove required attribute 
Javascript :: javascript ascii character 
Javascript :: how to deobfuscate javascript 
Javascript :: send multipart form data axios with node js 
Javascript :: Using vuejs-datepicker with Nuxt JS 
Javascript :: defer parsing of javascript avada 
Javascript :: jquery moment js 
Javascript :: javascript how to remove first element of array 
Javascript :: remove a value to an array of javascript 
Javascript :: json comment 
Javascript :: mongodb date format dd/mm/yyyy 
ADD CONTENT
Topic
Content
Source link
Name
1+2 =