{"action":"created","issue":{"url":"https://api.github.com/repos/ibmdb/node-ibm_db/issues/33","labels_url":"https://api.github.com/repos/ibmdb/node-ibm_db/issues/33/labels{/name}","comments_url":"https://api.github.com/repos/ibmdb/node-ibm_db/issues/33/comments","events_url":"https://api.github.com/repos/ibmdb/node-ibm_db/issues/33/events","html_url":"https://github.com/ibmdb/node-ibm_db/issues/33","id":66094037,"number":33,"title":" The database alias name or database name \"\" could not be found.  SQLSTATE=42705 error","user":{"login":"rochal","id":1065287,"avatar_url":"https://avatars.githubusercontent.com/u/1065287?v=3","gravatar_id":"","url":"https://api.github.com/users/rochal","html_url":"https://github.com/rochal","followers_url":"https://api.github.com/users/rochal/followers","following_url":"https://api.github.com/users/rochal/following{/other_user}","gists_url":"https://api.github.com/users/rochal/gists{/gist_id}","starred_url":"https://api.github.com/users/rochal/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rochal/subscriptions","organizations_url":"https://api.github.com/users/rochal/orgs","repos_url":"https://api.github.com/users/rochal/repos","events_url":"https://api.github.com/users/rochal/events{/privacy}","received_events_url":"https://api.github.com/users/rochal/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-04-03T07:05:13Z","updated_at":"2015-04-07T08:36:28Z","closed_at":null,"body":"Hi, \r\n\r\nI'm trying to connect to Informix database and I'm getting following error:\r\n\r\n```\r\n{ [Error: [IBM][CLI Driver] SQL1013N  The database alias name or database name \"\" could not be found.  SQLSTATE=42705\r\n]\r\n  error: '[node-odbc] SQL_ERROR',\r\n  message: '[IBM][CLI Driver] SQL1013N  The database alias name or database name \"\" could not be found.  SQLSTATE=42705\\\r\nr\\n',\r\n  state: '08001' }\r\n```\r\n\r\nMy configuration is as follows:\r\n\r\n```\r\nibmdb.open(\"DRIVER={Informix};DATABASE=my_db_name;SERVER=my_db_server;HOST=127.0.0.1;UID=my_user;PWD=my_user_pwd;PORT=8000;PROTOCOL=onsoctcp;\", function (err,conn) {\r\nif (err) return console.log(err);\r\n// query goes here...\r\n});\r\n```\r\nNote the above meant to map to the following connection string: `jdbc:informix-sqli://127.0.0.1:8000/my_db-name:INFORMIXSERVER= my_db_server`.\r\n\r\nI can connect to the same instance of Informix using a GUI DBVisualizer tool using same credentials so it's not the problem with the instance itself.\r\n\r\nAny idea why the connection string in `ibmdb.open` does not correctly recognize my database name?\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/ibmdb/node-ibm_db/issues/comments/90463024","html_url":"https://github.com/ibmdb/node-ibm_db/issues/33#issuecomment-90463024","issue_url":"https://api.github.com/repos/ibmdb/node-ibm_db/issues/33","id":90463024,"user":{"login":"avikalar","id":9191712,"avatar_url":"https://avatars.githubusercontent.com/u/9191712?v=3","gravatar_id":"","url":"https://api.github.com/users/avikalar","html_url":"https://github.com/avikalar","followers_url":"https://api.github.com/users/avikalar/followers","following_url":"https://api.github.com/users/avikalar/following{/other_user}","gists_url":"https://api.github.com/users/avikalar/gists{/gist_id}","starred_url":"https://api.github.com/users/avikalar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/avikalar/subscriptions","organizations_url":"https://api.github.com/users/avikalar/orgs","repos_url":"https://api.github.com/users/avikalar/repos","events_url":"https://api.github.com/users/avikalar/events{/privacy}","received_events_url":"https://api.github.com/users/avikalar/received_events","type":"User","site_admin":false},"created_at":"2015-04-07T08:36:28Z","updated_at":"2015-04-07T08:36:28Z","body":"You need to use the TCPIP protocol. Can you please check if you are connecting to the correct PORT by finding an entry for DRDA protocol nettype in sqlhost file of Informix server. To check if DRDA is enabled please check entries in your sqlhost file by running 'echo $INFORMIXSQLHOSTS'. If it is empty or not set you can find sqlhost file under $INFORMIXDIR/etc/sqlhosts. If the sqlhost file has an entry with drsoctcp protocol , then use that port number in the connection string. If not found enable DRDA by adding a new entry into the sqlhost file. Then you can connect to the db using the following connection string with the port number taken from the sqlhost file entry for drsoctcp and protocol set to TCPIP."}}