\u6700\u7c21\u55ae\u7684\u9023\u7dda\u5b57\u4e32\uff0c\u662f\u4ee5\u4fe1\u4efb\u9023\u7dda\u7684\u65b9\u5f0f\u9023\u63a5 SQL Server \u8cc7\u6599\u5eab\uff0c\u5b57\u4e32\u5982\u4e0b\uff1a<\/p>\n
Server=ServerAddress;Database=DataBaseName;Trusted_Connection=True;<\/p>\n
ServerAddress\u662f\u8cc7\u6599\u5eab\u4f3a\u670d\u5668\u7684\u540d\u7a31\uff0cDataBaseName\u5247\u662f\u6240\u8981\u9023\u63a5\u7684\u8cc7\u6599\u5eab\u540d\u7a31\uff0cTrusted_Connection\u8a2d\u70baTrue\uff0c\u8868\u793a\u76f4\u63a5\u900f\u904e\u4fe1\u4efb\u9023\u7dda\u9023\u63a5\uff0c\u56e0\u6b64\u4e0d\u9700\u8981\u6307\u5b9a\u5e33\u865f\u5bc6\u78bc\u8cc7\u6599\u3002<\/p>\n
\u7121\u8ad6\u4f7f\u7528C#\u6216\u662fVB.NET\uff0c\u7576\u4f60\u8981\u900f\u904eADO.NET\u9023\u63a5SQL Server\u8cc7\u6599\u5eab\u7684\u6642\u5019\uff0c\u5fc5\u9808\u6307\u5b9a\u9023\u63a5\u5b57\u4e32\uff0c\u9019\u7bc7\u6587\u7ae0\uff0c\u6211\u5011\u4f86\u770b\u4e00\u4e0b\u76f8\u95dc\u9023\u7dda\u5b57\u4e32\u7684\u5f59\u7e3d\u3002<\/p>\n
\u6700\u7c21\u55ae\u7684\u9023\u7dda\u5b57\u4e32\uff0c\u662f\u4ee5\u4fe1\u4efb\u9023\u7dda\u7684\u65b9\u5f0f\u9023\u63a5 SQL Server \u8cc7\u6599\u5eab\uff0c\u5b57\u4e32\u5982\u4e0b\uff1a<\/p>\n
Server=ServerAddress;Database=DataBaseName;Trusted_Connection=True;<\/p>\n
ServerAddress\u662f\u8cc7\u6599\u5eab\u4f3a\u670d\u5668\u7684\u540d\u7a31\uff0cDataBaseName\u5247\u662f\u6240\u8981\u9023\u63a5\u7684\u8cc7\u6599\u5eab\u540d\u7a31\uff0cTrusted_Connection\u8a2d\u70baTrue\uff0c\u8868\u793a\u76f4\u63a5\u900f\u904e\u4fe1\u4efb\u9023\u7dda\u9023\u63a5\uff0c\u56e0\u6b64\u4e0d\u9700\u8981\u6307\u5b9a\u5e33\u865f\u5bc6\u78bc\u8cc7\u6599\u3002<\/p>\n
\u5e95\u4e0b\u662f\u975e\u4fe1\u4efb\u9023\u7dda\u7684\u72c0\u6cc1\uff0c\u5176\u4e2d\u7684Trusted_Connection\u8a2d\u5b9a\u70baflase\uff0c\u56e0\u6b64\u5fc5\u9808\u518d\u6307\u5b9aID\u8207Password\u5169\u500b\u5c6c\u6027\u503c\u7d66\u4ed6\uff0c\u9019\u5169\u500b\u503c\u5206\u5225\u4ee3\u8868\u958b\u555f\u8cc7\u6599\u5eab\u6240\u9700\u7684\u5e33\u865f\u8207\u5bc6\u78bc\uff1a<\/p>\n
Server=ServerAddress;Database=DataBaseName;User ID=Username;Password=Password;Trusted_Connection=False;<\/p>\n
\u9664\u4e86\u4e0a\u8ff0\u7684\u8a9e\u6cd5\uff0c\u4f60\u4e5f\u53ef\u4ee5\u5229\u7528\u4ee5\u4e0b\u7684\u66ff\u4ee3\u8a9e\u6cd5\uff1a<\/p>\n
Data Source=ServerAddress;Initial Catalog=DataBaseName;Integrated Security=SSPI;
\nData Source=ServerAddress;Initial Catalog=DataBaseName;User Id=myUsername;Password=myPassword;<\/p>\n
\u300cIntegrated Security=SSPI\u300d\u7684\u610f\u7fa9\u8207\u300cTrusted_Connection=True\u300d\u7684\u76f8\u540c\uff0c\u5176\u4ed6\u7684\u5e7e\u500b\u9805\u76ee\u5247\u5c0d\u61c9\u81f3\u76f8\u540c\u7684\u5c6c\u6027\u3002<\/p>\n
\u53e6\u5916\uff0c\u4f60\u4e5f\u53ef\u4ee5\u900f\u904e\u6307\u5b9a IP Address \u7684\u65b9\u5f0f\uff0c\u9023\u63a5\u903a\u7aef\u8cc7\u6599\u5eab\uff0c\u5b57\u4e32\u5982\u4e0b\uff0c\u8981\u7279\u5225\u6ce8\u610f\u7684\u662f\uff0c\u5176\u4e2d\u7684Data Source\u9664\u4e86IP\u4f4d\u5740\uff0c\u6700\u5f8c\u4e00\u500b\u6578\u5b57\u300c1433\u300d\uff0c\u662fSQL Server\u7684\u9810\u8a2d\u9023\u63a5\u57e0\uff1a<\/p>\n
Data Source=192.168.100.100,1433;Network Library=DBMSSOCN;
\nInitial Catalog=DataBaseName;User ID=Username;Password=PasswordName;<\/p>\n
\u5982\u679c\u4f60\u4f7f\u7528\u7684\u662fSQL Server Express\u7248\u672c\uff0c\u5247\u9023\u7dda\u5b57\u4e32\u662f\u76f8\u540c\u7684\uff0c\u5dee\u5225\u53ea\u5728\u65bcServer\u540d\u7a31\u5fc5\u9808\u52a0\u4e0a\u4e00\u500bSQLEXPRESS \uff0c\u5982\u4e0b\u5f0f\uff1a<\/p>\n
Server=ServerAddress\\SQLEXPRESS ;Database=DataBaseName;Trusted_Connection=True;<\/p>\n
\u7531\u65bc.NET 2.0\u6240\u91cb\u51fa\u7684SQL Server Express\u7248\u672c\uff0c\u5141\u8a31\u958b\u767c\u4eba\u54e1\u76f4\u63a5\u4ee5\u8cc7\u6599\u5eab\u6a94\u6848\u7684\u578b\u5f0f\uff0c\u9032\u884c\u8cc7\u6599\u5eab\u5b58\u53d6\u7dad\u8b77\uff0c\u5c31\u5982\u540cAccess\u8cc7\u6599\u5eab\uff0c\u5c0d\u65bc\u9019\u7a2e\u985e\u578b\u7684\u8cc7\u6599\u9023\u7dda\u5b57\u4e32\u53c8\u8207\u4e0a\u8ff0\u7684\u4e0d\u540c\uff0c\u8acb\u53c3\u8003\u300cSQL Server Express \u8cc7\u6599\u5eab\u6a94\u6848\u7684\u9023\u7dda\u5b57\u4e32\u300d\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u6700\u7c21\u55ae\u7684\u9023\u7dda\u5b57\u4e32\uff0c\u662f\u4ee5\u4fe1\u4efb\u9023\u7dda\u7684\u65b9\u5f0f\u9023\u63a5 SQL Server \u8cc7\u6599\u5eab\uff0c\u5b57\u4e32\u5982\u4e0b\uff1a Server=Server … \u95b1\u8b80\u5168\u6587 .NET \u900f\u904e SqlConnection \u9023\u63a5 SQL Server \u7684\u9023\u7dda\u5b57\u4e32<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-391","post","type-post","status-publish","format-standard","hentry","category-5","no-featured-image"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts\/391","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/comments?post=391"}],"version-history":[{"count":0,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts\/391\/revisions"}],"wp:attachment":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/media?parent=391"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/categories?post=391"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/tags?post=391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}