Connecting to Oracle DB with JavaScript

Question

I am using an Oracle 10g backend. I use the oracle TNS in JavaScript to connect with the Oracle DB. When I run the form on my local system then it displays fine, but when I run it on IIS on a client system it displays undefined. Please help me run this correctly on client machine in Google Chrome.

My Code is Below:

 var conObj = new ActiveXObject('ADODB.Connection');
    var conString = "Provider=OraOLEDB.Oracle; Data Source=(DESCRIPTION=(CID=GTU_APP)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=202.125.144.34)(PORT=1521)))(CONNECT_DATA=(SID=orcl)(SERVER=DEDICATED)));User Id=admin; Password=admin;"
    conObj.Open(conString);
    var rs =  new ActiveXObject("ADODB.Recordset");
    sql = "SELECT * from info"
    rs.open(sql,conString);
    var rsnum=rs.fields.count;
    alert(rsnum);
    rs.close;
    conObj.close;

I'd be very surprised if JavaScript running on a web site can start a ADODB connection with the default security settings. I hope that not even sites in the Intranet area can do this. — Joachim Sauer
– Joachim Sauer, Commented Oct 20, 2011 at 7:36
I never tried to do a DB connection in a client javascript, but you prolly don't have the the rights to do this action. Better do the connection and data stuff in a server sided page and deliver the results to the client which you can perform in your script then. — YvesR
– YvesR, Commented Oct 20, 2011 at 7:38

Matthew Watson · Accepted Answer · 2011-10-20 10:18:40Z

28

Please DONT do this, assuming it even works, its horribly dangerous, you are shipping your username and password to the client, giving them the ability to do anything they want ( assuming this is client side javascript, it could be server side I guess ).

Create a web service to provide the services you need and call that from JS.

edited Oct 20, 2011 at 10:18

answered Oct 20, 2011 at 7:41

Matthew Watson

14.3k9 gold badges65 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Adeel Aslam Over a year ago

Can u please give me an example to do this its urgent plz

Matthew Watson Over a year ago

That is a pretty big topic, and pretty much beyond the scope of stackoverflow. This isn't really the sort of thing I'd recommend doing urgently.

Nikita Ignatov Over a year ago

"giving them the ability to do anything they want" - But that's exactly what I want to do!

Tegiri Nenashi Over a year ago

-1: I'm just wading through REST, SOAP and other middleman nonsense, where JDBC-style direct connection to database would have been simple and clean solution. What you are saying, one machine (javascript in browser sandbox) running general purpose programming language can't connect to the other (RDBMS server), or this connection is fundamentally unreliable?

gouessej · Accepted Answer · 2022-07-31 12:50:54Z

0

As @Matthew suggested, it is a terrible idea, but it's possible using node-oracledb - a Node.js driver for Oracle Database.

Kindly find the link below : https://blogs.oracle.com/opal/post/introducing-node-oracledb-a-nodejs-driver-for-oracle-database

edited Jul 31, 2022 at 12:50

gouessej

4,2544 gold badges40 silver badges75 bronze badges

answered Aug 31, 2016 at 5:51

Anupam

5171 gold badge6 silver badges17 bronze badges

1 Comment

djangofan Over a year ago

I'd say that is problematic. Using the native driver for tests doesn't make them very portable. I agree with the sentiment of putting a 3rd party service in place to broker the test verifications.

Collectives™ on Stack Overflow

Connecting to Oracle DB with JavaScript

2 Answers 2

4 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related