{"id":994,"date":"2021-04-26T09:01:54","date_gmt":"2021-04-26T01:01:54","guid":{"rendered":"https:\/\/www.dxQerp.cn\/?p=994"},"modified":"2021-04-26T09:16:39","modified_gmt":"2021-04-26T01:16:39","slug":"microsoftsqlserverodbcdriverconnectionstrings","status":"publish","type":"post","link":"http:\/\/www.dxQerp.cn\/?p=994","title":{"rendered":"ODBC \u7684 SQL Server connectionstrings \u5b57\u7b26\u4e32\u7684\u5199\u6cd5"},"content":{"rendered":"

ADO\u63a7\u4ef6\u9002\u7528<\/p>\n

\u6807\u51c6\uff1a<\/p>\n

Driver<\/span>={SQL Server};<\/span><\/span>Server<\/span>=\u670d\u52a1\u5668\u5730\u5740;<\/span><\/span>Database<\/span>=\u6570\u636e\u5e93\u540d;<\/span><\/span>Uid<\/span>=\u767b\u5f55\u540d;<\/span><\/span>Pwd<\/span>=\u5bc6\u7801;<\/span><\/span><\/span><\/p>\n

\u4fe1\u4efb\u8fde\u63a5\uff1a<\/p>\n

Driver<\/span>={SQL Server};<\/span><\/span>Server<\/span>=\u670d\u52a1\u5668\u5730\u5740<\/span>;<\/span><\/span>Database<\/span>=\u6570\u636e\u5e93\u540d;<\/span><\/span>Trusted_Connection<\/span>=Yes;<\/span><\/span><\/span><\/p>\n

\u6307\u5b9a\u7aef\u53e3\uff1a<\/p>\n

Driver<\/span>={SQL Server};<\/span><\/span>Server<\/span>=\u670d\u52a1\u5668\u5730\u5740<\/span>,\u7aef\u53e3;<\/span><\/span>Database<\/span>=\u6570\u636e\u5e93\u540d;<\/span><\/span>Uid<\/span>=\u767b\u5f55\u540d;<\/span><\/span>Pwd<\/span>=\u5bc6\u7801;<\/span><\/span><\/span><\/p>\n

\u4e0a\u8ff0\u5b57\u7b26\u4e32\u4e2d\uff0c \u4e2d\u6587\u90e8\u5206\u6309\u5b9e\u9645\u60c5\u51b5\u4ee3\u66ff\u5373\u53ef\u4f7f\u7528\u3002\u5982\uff1a<\/p>\n

Driver<\/span>={SQL Server};<\/span><\/span>Server<\/span>=192.168.1.2<\/span>,8898<\/span>;<\/span><\/span>Database<\/span>=DxQERPDB;<\/span><\/span>Uid<\/span>=sa;<\/span><\/span>Pwd<\/span>=889898;<\/span><\/span><\/span><\/p>\n

\u6307\u5b9a\u7aef\u53e3\u7684\u90e8\u5206\uff0c\u4f7f\u7528\u7684\u662f\u3010\u9017\u53f7\u3011\u3010\u9017\u53f7\u3011\u3010\u9017\u53f7\u3011(\u91cd\u8981\u7684\u8bdd\u8bf4\u4e09\u904d)\uff01\uff01\uff01<\/p>\n

===============================<\/p>\n

\u66f4\u8be6\u7ec6\u7684 connectionstrings\u00a0 \u8d44\u6599\uff0c\u8bf7\u5230 https:\/\/www.connectionstrings.com\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

ADO\u63a7\u4ef6\u9002\u7528 \u6807\u51c6\uff1a Driver={SQL Server};Server=\u670d\u52a1\u5668\u5730\u5740;Database=\u6570 […]<\/p>\n","protected":false},"author":2,"featured_media":973,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[17,25],"tags":[28,32,29,30,26,27],"jetpack_featured_media_url":"http:\/\/www.dxQerp.cn\/wp-content\/uploads\/2021\/04\/dBase2019_adds_new_and_updated_features_to_Ado.png","_links":{"self":[{"href":"http:\/\/www.dxQerp.cn\/index.php?rest_route=\/wp\/v2\/posts\/994"}],"collection":[{"href":"http:\/\/www.dxQerp.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.dxQerp.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.dxQerp.cn\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.dxQerp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=994"}],"version-history":[{"count":3,"href":"http:\/\/www.dxQerp.cn\/index.php?rest_route=\/wp\/v2\/posts\/994\/revisions"}],"predecessor-version":[{"id":999,"href":"http:\/\/www.dxQerp.cn\/index.php?rest_route=\/wp\/v2\/posts\/994\/revisions\/999"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.dxQerp.cn\/index.php?rest_route=\/wp\/v2\/media\/973"}],"wp:attachment":[{"href":"http:\/\/www.dxQerp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=994"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.dxQerp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=994"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.dxQerp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=994"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}