Cross-browser alternative needed for activexobject javascript

Question

0.00/5 (No votes)

See more:

// Execute SQL to fetch Account records
  var db = new ActiveXObject("ADODB.Connection");
  var rs = new ActiveXObject("ADODB.Recordset");
  var sum = 0;
  db.Open(DB_NAME);
  rs.Open(sql, db);

What I have tried:

This is a small app that retrieves data from MS Access database stored on my computer. The app only works in IE, I would like it to work with all major browsers

Posted 17-Apr-19 3:59am

Member 14289051

Updated 17-Apr-19 8:26am

Add a Solution

4 solutions

Solution 4

Thank you guys, I appreciate that. I have to rewrite the application.

Posted 17-Apr-19 8:26am

Member 14289051

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)

#realJSOP · Accepted Answer · 2019-04-17T04:03:00

Solution 1

DO NOT USE ACTIVEX. (Commonly referred to as "Active-Xcrement")

Only Microsoft browsers support it, and anyone with have a brain avoids using it because it's insecure.

There are too many examples of writing ADO code for an Asp.Net web site to have to use ActiveX.

Posted 17-Apr-19 4:03am

#realJSOP

Updated 17-Apr-19 4:04am

v2

Dave Kreskowiak · Accepted Answer · 2019-04-17T05:23:00

You don't have an alternative.

Accessing data from somewhere on the client machine is not going to work anywhere. It's a security risk (and why nobody supports ActiveX any more!) and is not allowed by any browser.

All record handling should be done by the server, not the client. The client is just used to display records and edit them. Once the record modifications are complete, the changed records should be sent back to the server to be written to the database or other backing storage.

Patrice T · Accepted Answer · 2019-04-17T08:11:00

Solution 3

Quote:
Cross-browser alternative needed for activexobject javascript

There is none, Activex have only been supported by MSIE. Activex is a major security risk.

You need to rethink moving ActiveX functionality to server side. Only this is cross-platform.

Posted 17-Apr-19 8:11am

Patrice T