node-oracle cant work on win7 #164

Open
forfuns opened this Issue Mar 24, 2014 · 2 comments

3 participants

@forfuns

I use on win7 development platform node-oracle, but nothing output and not error (is build ok,and I sure my oracle has data)
However, I use the same code on linux, I can read the data (my tbale is output)

var oracle = require("oracle");

var connectData = {
hostname: "192.168.0.147",
port: 1521,
database: "orcl", // System ID (SID)
user: "goaland",
password: "goaland"
}

oracle.connect(connectData, function(err, connection) {
if (err) { console.log("Error connecting to db:", err); return; }

connection.execute("SELECT * FROM RM_DEVICES", [], function(err, results) {

    if (err) { console.log("Error executing query:", err); return; }

    console.log(results);
    connection.close(); // call only when query is finished executing
});

});

@forfuns forfuns changed the title from node-oracle cant work to node-oracle cant work on win7 Mar 24, 2014
@cmunozjuste

The same thing happened to me today on Windows 7 64 bits, and the reason was that I had on the path more Oracle clients apart from the InstantClient I used to install (12.1 64 bits). After I left just that one on the path, it worked ok. Could that be the reason in your case, too?

@legalum

Thank you cmunozjuste,

it worked perfecly for me, i had the same issue on Windows 7 x64.
If you follow the install guide, it says to put that two path (in my own case) :

c:\instantclient_12_1\vc11;c:\instantclient_12_1

However i found that a bit weird and just put off the c:\instantclient_12_1\vc11.
And now it's work.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment