Hi I am trying to connect to ibm_db. But getting the error database name not found at the remote node.

[Janani sridhar]

1. 1. Installed nodejs
2. 2. Installed ibm_db
3. 3. Downloaded the nodedb2test.js file  and modified it according to my requirements.
4. 4. Changed the database details as per my DB2 database
5. 5. Ran this file. 

ibmdb.open("DATABASE=xyz;HOSTNAME=156.40.45.34;UID=fsfsdfsdf;PWD=sdfsfsdf;PORT=5634;PROTOCOL=TCPIP", function(err, conn)

{

        if(err) {

       console.error("error: ", err.message);

        } else {

conn.query("select name from sdfsd.dfgdfg;", function(err, moreResultSets) {

                        console.log("FirstName \t\t LastName");

console.log("----------\t\t---------");

console.log("-----------------------");

conn.close(function(){

console.log("Connection Closed");

});

});

}

});

1. Got the error

[IBM][CLI Driver] SQL30061N The database alias or database name "xyz            " was not found at the remote node. SQLSTATE=08004.

Kindly help me resolve this issue.

[bimaljha]

Can you confirm you have a database named "xyz" created on server? You can run the command "db2 list db directory" on server and share the output.

Also, use XYZ in connection string instead of "xyz". I suspect you have a database XYZ on server and not xyz.

Thanks,

Bimal Jha

[Rohit Pandey]

Hi @Janani sridhar  any updates about the issue?