{"id":485,"date":"2017-01-09T23:31:26","date_gmt":"2017-01-09T14:31:26","guid":{"rendered":"http:\/\/www.onepage.co.kr\/wordpress\/?p=485"},"modified":"2017-01-09T23:33:35","modified_gmt":"2017-01-09T14:33:35","slug":"connection-pooling-test","status":"publish","type":"post","link":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/2017\/01\/09\/connection-pooling-test\/","title":{"rendered":"connection pooling test"},"content":{"rendered":"

Sample ASP page:
\n<%@ LANGUAGE=”VBSCRIPT” %><\/p>\n

<HTML>
\n<BODY>
\n>%
\ndim cn(10)
\ndim cmd(10)<\/p>\n

For x = 0 to 10
\nSet cn(x) = Server.CreateObject(“ADODB.Connection”)
\ncn(x).Open “DRIVER={SQL Server};SERVER=Ovteam;DATABASE=Pubs;UID=<username>;PWD=<strong password>”
\nSet cmd(x) = Server.CreateObject(“ADODB.Command”)
\ncmd(x).activeconnection = cn(x)
\ncmd(x).commandtext = “SELECT * FROM Authors”<\/p>\n

cmd(x).execute<\/p>\n

Response.Write “Command executed: ” & x & “<BR>”<\/p>\n

Set cmd(x) = Nothing
\ncn(x).close ‘comment this line out to recreate the problem
\nSet cn(x) = Nothing
\nNext
\n%>
\n<\/BODY>
\n<HTML><\/p>\n

    \n
  1. SQL Server \uc131\ub2a5 \ubaa8\ub2c8\ud130<\/span>\ub97c \uc5f4\uace0: \uc2dc\uc791 <\/span>\uba54\ub274\uc5d0\uc11c \ud504\ub85c\uadf8\ub7a8<\/span>, \uad00\ub9ac \ub3c4\uad6c<\/span> (\uacf5\ud1b5) \ubc0f \uc131\ub2a5 \ubaa8\ub2c8\ud130<\/span>\ub97c \uc120\ud0dd \ud569\ub2c8\ub2e4.<\/li>\n
  2. +<\/span> \ub97c \ud074\ub9ad \ud558 \uc5ec \uce74\uc6b4\ud130\ub97c \ucd94\uac00 \ud569\ub2c8\ub2e4.<\/li>\n
  3. SQL Server \uac1c\uccb4\ub97c \ubcc0\uacbd \ud569\ub2c8\ub2e4.<\/li>\n
  4. \uc0ac\uc6a9\uc790 \uc5f0\uacb0<\/span> \uce74\uc6b4\ud130\ub97c \uc120\ud0dd \ud558 \uace0 \ucd94\uac00<\/span>\ud074\ub9ad \ud569\ub2c8\ub2e4.<\/li>\n
  5. \uc644\ub8cc<\/span>\ub97c \ud074\ub9ad \ud569\ub2c8\ub2e4.<\/li>\n
  6. ASP \ud398\uc774\uc9c0\ub97c \uc2e4\ud589 \ud569\ub2c8\ub2e4.<\/li>\n
  7. \uc0ac\uc6a9\uc790 \uc5f0\uacb0 \uce74\uc6b4\ud130\ub97c \ubd05\ub2c8\ub2e4. <\/span>\uc5f0\uacb0\uc774 \ud480\uc73c\ub85c \ubc18\ud658 \ub418 \uace0 \ub2e4\uc2dc \uc0ac\uc6a9 \ub429\ub2c8\ub2e4\ub9cc \uc544\uc8fc \uacbd\uc6b0 \uc2dc\uc791 \uc9c0\uc810\uc5d0\uc11c \uce74\uc6b4\ud130 \ud558\ub098\ub97c \ub450 \uac1c\uc758 \uc5f0\uacb0\uc744 \ud1b5\ud574 \uc774\ub3d9 \ud569\ub2c8\ub2e4. <\/span>\uc5f0\uacb0\uc744 \uc99d\uac00 \uc2dc\uc791 \ud558\ub294 \uacbd\uc6b0 \ub2e4\uc74c\uc740 \ubc18\ud658 \ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4 \ub418 \uace0 \uc5f0\uacb0 \ud480\uc744 \ub2e4\uc2dc \uc0ac\uc6a9\ud560 \uc218 \ubc0f \uac01 ADO \uac1c\uccb4\uc5d0 \ub300 \ud55c \uc0c8 \uc5f0\uacb0\uc744 \ub9cc\ub4dc\ub294 \uc911. <\/span><\/li>\n<\/ol>\n

    from https:\/\/support.microsoft.com\/ko-kr\/kb\/191572<\/p>\n","protected":false},"excerpt":{"rendered":"

    Sample ASP page: <%@ LANGUAGE=”VBSCRIPT” %> <HTML> <BODY> >% dim cn(10) dim cmd(10) For x = 0 to 10 Set cn(x) = Server.CreateObject(“ADODB.Connection”) cn(x).Open “DRIVER={SQL Server};SERVER=Ovteam;DATABASE=Pubs;UID=<username>;PWD=<strong password>” Set cmd(x) = Server.CreateObject(“ADODB.Command”) cmd(x).activeconnection = cn(x) cmd(x).commandtext = “SELECT * FROM Authors” cmd(x).execute Response.Write “Command executed: ” & x & “<BR>” Set cmd(x) = Nothing cn(x).close ‘comment […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-485","post","type-post","status-publish","format-standard","hentry","category-about-linux"],"_links":{"self":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/485","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/comments?post=485"}],"version-history":[{"count":3,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/485\/revisions"}],"predecessor-version":[{"id":492,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/485\/revisions\/492"}],"wp:attachment":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=485"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/categories?post=485"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/tags?post=485"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}