how to retrieve data from sql database from javascript

Question

1.00/5 (1 vote)

See more:

JavaScript

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

    var connectionstring = "Data Source=elabsqldb2.db.11460868.hostedresource.com;Initial Catalog=elabsqldb2;User ID=elabsqldb2;password=elab17TRACK#14";
    connection.Open(connectionstring);
    var rs = new ActiveXObject("ADODB.Recordset");

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

    rs.close;
    connection.close;

}

Am not able to read a output .

Posted 5-Jan-16 20:31pm

Member 12119075

Updated 20-Oct-21 9:10am

dan!sh

v2

Add a Solution

Comments

Member 12119075 6-Jan-16 2:33am

Kornfeld Eliyahu Peter 6-Jan-16 2:41am

It is very bad idea to use ActiveX...Why it is so important to you to directly access the database from the client and not to put a layer on the server between the two?

Member 12119075 6-Jan-16 2:51am

i refered this link to achieve and my lead also asking me to follow this model

http://stackoverflow.com/questions/857670/how-to-connect-to-sql-server-database-from-javascript-in-the-browser

Kornfeld Eliyahu Peter 6-Jan-16 2:56am

It is a discussion from 2009! World changed since and ActiveX became an ancient, not supported technology...
I would advise you too look further...
1. It works only on older IE (no Chrome or Firefox or IE11 (9-10 too has its problem)
2. It is very dependent on the permissions the local user have
3. It is extremely non-flexibile

Member 12119075 6-Jan-16 3:01am

thank u very much , how do i pass data from server side to Clint side script ? give me a suggestion

Kornfeld Eliyahu Peter 6-Jan-16 3:04am

There are lot of ways...
As it seems you want the data in JavaScript (and not in HTML) you should learn of AJAX/Page methods/WEB API

Kornfeld Eliyahu Peter 6-Jan-16 2:41am

OT. Do not post your questions twice! Please remove the other instance!

Member 12119075 6-Jan-16 2:49am

Am fresher for code project .what u meaning of question posted twice ,i think i posted once . if am wrong teach me

Kornfeld Eliyahu Peter 6-Jan-16 2:50am

http://www.codeproject.com/script/Answers/MemberPosts.aspx?tab=questions&mid=12119075

[no name] 6-Jan-16 5:46am

Do not use this kind concept to connect Database from javascript. Logically, if javascript does everything then Microsoft doesn't discover ASP.NET(server side) to connect database. If that is your requirement then it is completely wrong.

Secondly you are providing connection javascript file which will be viewable to user. That creates downgrades security policy.

[no name] 28-Jun-16 3:56am

ActiveX is dead... You need a dinosaur browser to do that. Use the actual technology. ASP.NET. Example: http://www.codeproject.com/Articles/14249/How-to-populate-DataGridView-GridView-with-SQL-sta

Daniel Jones 29-Jun-16 0:59am

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/2b5c7b9c-1126-47f6-90b2-2dd9030b06c0/how-can-i-access-and-get-sql-server-data-from-javascript-webapp?forum=sqldataaccess

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

AyolaJ · Answer 1 · 2016-06-27T19:32:00

Using nodejs and mysql you can achieve it.

C#

var mysql      = require('mysql');
var connection = mysql.createConnection({
  host     : 'localhost',
  user     : '< MySQL username >',
  password : '< MySQL password >',
  database : '<your database name>'
});

connection.connect();

connection.query('SELECT * from < table name >', function(err, rows, fields) {
  if (!err)
    console.log('The solution is: ', rows);
  else
    console.log('Error while performing Query.');
});

connection.end();