{"action":"created","issue":{"url":"https://api.github.com/repos/Hyurl/modelar-ibmdb-adapter/issues/1","repository_url":"https://api.github.com/repos/Hyurl/modelar-ibmdb-adapter","labels_url":"https://api.github.com/repos/Hyurl/modelar-ibmdb-adapter/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/Hyurl/modelar-ibmdb-adapter/issues/1/comments","events_url":"https://api.github.com/repos/Hyurl/modelar-ibmdb-adapter/issues/1/events","html_url":"https://github.com/Hyurl/modelar-ibmdb-adapter/issues/1","id":309868262,"number":1,"title":"Connect as400","user":{"login":"akilinomendez","id":3064088,"avatar_url":"https://avatars2.githubusercontent.com/u/3064088?v=4","gravatar_id":"","url":"https://api.github.com/users/akilinomendez","html_url":"https://github.com/akilinomendez","followers_url":"https://api.github.com/users/akilinomendez/followers","following_url":"https://api.github.com/users/akilinomendez/following{/other_user}","gists_url":"https://api.github.com/users/akilinomendez/gists{/gist_id}","starred_url":"https://api.github.com/users/akilinomendez/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/akilinomendez/subscriptions","organizations_url":"https://api.github.com/users/akilinomendez/orgs","repos_url":"https://api.github.com/users/akilinomendez/repos","events_url":"https://api.github.com/users/akilinomendez/events{/privacy}","received_events_url":"https://api.github.com/users/akilinomendez/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-03-29T19:03:10Z","updated_at":"2018-03-30T11:38:35Z","closed_at":null,"author_association":"NONE","body":"Hello, I need to connect to as400 with db 9.7, but when executing a select one, I receive this error:\r\n{ Error: [IBM][CLI Driver] SQL30081N  A communication error has been detected. Communication protocol being used: \"TCP/IP\".  Communication API being used: \"SOCKETS\".  Location where the error was detected: \"*******\".  Communication function detecting the error: \"recv\".  Protocol specific error code(s): \"*\", \"*\", \"0\".  SQLSTATE=08001\r\n\r\nChanging from port to 446 I received this:\r\n{ Error: [IBM][CLI Driver] SQL1598N  An attempt to connect to the database server failed because of a licensing problem.  SQLSTATE=42968\r\n\r\n  errors: [],\r\n  error: '[node-odbc] SQL_ERROR',\r\n  message: '[IBM][CLI Driver] SQL1598N  An attempt to connect to the database server failed because of a licensing problem.  SQLSTATE=42968\\n',\r\n  state: '42968' }\r\n\r\nI do not have a license for db2cli, but the odbc connection is active because I can use isql to select.\r\n\r\n\r\nCan this package use the unixodbc driver?\r\n\r\nNow I'm using the node-odbc package from wankdanker, but I have a lot of problems with the connections and the characters, but the database is in the westers eu code\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/Hyurl/modelar-ibmdb-adapter/issues/comments/377507189","html_url":"https://github.com/Hyurl/modelar-ibmdb-adapter/issues/1#issuecomment-377507189","issue_url":"https://api.github.com/repos/Hyurl/modelar-ibmdb-adapter/issues/1","id":377507189,"user":{"login":"Hyurl","id":16103955,"avatar_url":"https://avatars1.githubusercontent.com/u/16103955?v=4","gravatar_id":"","url":"https://api.github.com/users/Hyurl","html_url":"https://github.com/Hyurl","followers_url":"https://api.github.com/users/Hyurl/followers","following_url":"https://api.github.com/users/Hyurl/following{/other_user}","gists_url":"https://api.github.com/users/Hyurl/gists{/gist_id}","starred_url":"https://api.github.com/users/Hyurl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Hyurl/subscriptions","organizations_url":"https://api.github.com/users/Hyurl/orgs","repos_url":"https://api.github.com/users/Hyurl/repos","events_url":"https://api.github.com/users/Hyurl/events{/privacy}","received_events_url":"https://api.github.com/users/Hyurl/received_events","type":"User","site_admin":false},"created_at":"2018-03-30T11:38:35Z","updated_at":"2018-03-30T11:38:35Z","author_association":"OWNER","body":"I'm not familiar with jt400, and node-jt400 doesn't provide enough details about the package, it may be able to connect and run queries, but many other features such as max connection size, timeout checking are not guaranteed. I can only implement those functions I've known, if you can provide details about jt400, it would be the best."}}
{"actor":{"display_login":"Hyurl"}}