{"action":"opened","issue":{"url":"https://api.github.com/repos/agstudy/rsqlserver/issues/21","labels_url":"https://api.github.com/repos/agstudy/rsqlserver/issues/21/labels{/name}","comments_url":"https://api.github.com/repos/agstudy/rsqlserver/issues/21/comments","events_url":"https://api.github.com/repos/agstudy/rsqlserver/issues/21/events","html_url":"https://github.com/agstudy/rsqlserver/issues/21","id":95588344,"number":21,"title":"can't use the package at all","user":{"login":"shrektan","id":8368933,"avatar_url":"https://avatars.githubusercontent.com/u/8368933?v=3","gravatar_id":"","url":"https://api.github.com/users/shrektan","html_url":"https://github.com/shrektan","followers_url":"https://api.github.com/users/shrektan/followers","following_url":"https://api.github.com/users/shrektan/following{/other_user}","gists_url":"https://api.github.com/users/shrektan/gists{/gist_id}","starred_url":"https://api.github.com/users/shrektan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shrektan/subscriptions","organizations_url":"https://api.github.com/users/shrektan/orgs","repos_url":"https://api.github.com/users/shrektan/repos","events_url":"https://api.github.com/users/shrektan/events{/privacy}","received_events_url":"https://api.github.com/users/shrektan/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-07-17T05:17:15Z","updated_at":"2015-07-17T05:17:15Z","closed_at":null,"body":"I tried several hours and failed to figure out the reason that I can't use your package. The `dbGetInfo(conn)$State` is 1, but I just can't execute any SQL. As long as I tried to execute any sql, the error occurs:\r\n\r\n```\r\nError in sqlServerExecStatement(conn, statement, ...) : NA\r\n```\r\n\r\n### my code\r\n\r\n```r\r\nlibrary(DBI)\r\nlibrary(rsqlserver)\r\nurl <- \"Server=xx.xx.xx.xx;Database=abc;User Id=abc;Password=abc;\"\r\nconn <- dbConnect(\"SqlServer\", url = url)\r\n\r\ndbListFields(conn, \"tablename\")\r\nError in sqlServerExecStatement(conn, statement, ...) : NA\r\n```\r\n\r\n### I can successfully do this `dbGetInfo(conn)`\r\n\r\n```r\r\n$ClientConnectionId\r\n[1] \"85666cab-6210-4bc8-9cd3-e0530127941c\"\r\n\r\n$ConnectionString\r\n[1] \"Server=xxx.xxx.xxx.xx;Database=abc;User Id=abc;\"\r\n\r\n$ConnectionTimeout\r\n[1] \"15\"\r\n\r\n$Database\r\n[1] \"abc\"\r\n\r\n$DataSource\r\n[1] \"xx.xxx.xxx.xx\"\r\n\r\n$FireInfoMessageEventOnUserErrors\r\n[1] \"FALSE\"\r\n\r\n$PacketSize\r\n[1] \"8000\"\r\n\r\n$ServerVersion\r\n[1] \"12.00.2000\"\r\n\r\n$State\r\n[1] \"1\"\r\n\r\n$StatisticsEnabled\r\n[1] \"FALSE\"\r\n\r\n$WorkstationId\r\n[1] \"abcdefg\"\r\n\r\n```\r\n\r\n### my session info\r\n\r\n```\r\nR version 3.2.1 (2015-06-18)\r\nPlatform: i386-w64-mingw32/i386 (32-bit)\r\nRunning under: Windows 7 x64 (build 7601) Service Pack 1\r\n\r\nlocale:\r\n[1] LC_COLLATE=Chinese (Simplified)_People's Republic of China.936 \r\n[2] LC_CTYPE=Chinese (Simplified)_People's Republic of China.936   \r\n[3] LC_MONETARY=Chinese (Simplified)_People's Republic of China.936\r\n[4] LC_NUMERIC=C                                                   \r\n[5] LC_TIME=Chinese (Simplified)_People's Republic of China.936    \r\n\r\nattached base packages:\r\n[1] stats     graphics  grDevices utils     datasets  methods  \r\n[7] base     \r\n\r\nother attached packages:\r\n[1] rsqlserver_1.0 rClr_0.7-2    \r\n\r\nloaded via a namespace (and not attached):\r\n [1] Rcpp_0.11.6     digest_0.6.8    R6_2.1.0        DBI_0.3.1.9008 \r\n [5] git2r_0.10.1    magrittr_1.5    httr_1.0.0      stringi_0.5-2  \r\n [9] curl_0.9        xml2_0.1.1      devtools_1.8.0  tools_3.2.1    \r\n[13] stringr_1.0.0   rversions_1.0.1 memoise_0.2.1   knitr_1.10.5  \r\n```\r\n\r\nCan you please help me figure it out? thanks."}}