?? 數(shù)據(jù)庫鏈接設置.htm
字號:
<html>
<head>
<meta http-equiv=Content-Type content="text/html; charset=gb2312">
<meta name=Generator content="Microsoft Word 11 (filtered)">
<title>數(shù)據(jù)庫鏈接設置</title>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:宋體;
panose-1:2 1 6 0 3 1 1 1 1 1;}
@font-face
{font-family:"\@宋體";
panose-1:2 1 6 0 3 1 1 1 1 1;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
text-align:justify;
text-justify:inter-ideograph;
font-size:10.5pt;
font-family:"Times New Roman";}
/* Page Definitions */
@page Section1
{size:595.3pt 841.9pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;
layout-grid:15.6pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=ZH-CN style='text-justify-trim:punctuation'>
<div class=Section1 style='layout-grid:15.6pt'>
<p class=MsoNormal><span style='font-family:宋體'>數(shù)據(jù)庫鏈接設置</span></p>
<p class=MsoNormal><span style='font-family:宋體'>鏈接數(shù)據(jù)庫字符串</span></p>
<p class=MsoNormal><span style='font-family:宋體'>方法一:使用基于</span><span
lang=EN-US>windows</span><span style='font-family:宋體'>身份驗證的權限問題</span></p>
<p class=MsoNormal><span style='font-family:宋體'>默認情況下,本書采用基于</span><span
lang=EN-US>windows</span><span style='font-family:宋體'>的身份驗證,由于</span><span
lang=EN-US>windows XP</span><span style='font-family:宋體'>系統(tǒng)增強了安全性能,所以在使用時,需要將</span><span
lang=EN-US>ASPNET</span><span style='font-family:宋體'>用戶鍵入</span><span
lang=EN-US>Administrator</span><span style='font-family:宋體'>組,步驟如下</span></p>
<p class=MsoNormal><span style='font-family:宋體'>(</span><span lang=EN-US>1</span><span
style='font-family:宋體'>)打開</span><span lang=EN-US>SQL</span><span
style='font-family:宋體'>數(shù)據(jù)庫,,在(</span><span lang=EN-US>local</span><span
style='font-family:宋體'>)上單擊選擇屬性。在“安全性”上選擇“</span><span lang=EN-US>SQL SERVER</span><span
style='font-family:宋體'>和</span><span lang=EN-US>windows</span><span
style='font-family:宋體'>”身份驗證</span></p>
<p class=MsoNormal><span lang=EN-US><img width=404 height=488
src="數(shù)據(jù)庫鏈接設置.files/image001.jpg"></span></p>
<p class=MsoNormal><span style='font-family:宋體'>(</span><span lang=EN-US>2</span><span
style='font-family:宋體'>)從運行里輸入“</span><span lang=EN-US>lusrmgr.msc</span><span
style='font-family:宋體'>”</span></p>
<p class=MsoNormal><span lang=EN-US><img width=347 height=175
src="數(shù)據(jù)庫鏈接設置.files/image002.jpg"></span></p>
<p class=MsoNormal><span style='font-family:宋體'>(</span><span lang=EN-US>3</span><span
style='font-family:宋體'>)在“用戶”里選擇“</span><span lang=EN-US>ASPNET</span><span
style='font-family:宋體'>”</span></p>
<p class=MsoNormal><span lang=EN-US><img width=553 height=395
src="數(shù)據(jù)庫鏈接設置.files/image003.jpg"></span></p>
<p class=MsoNormal><span lang=EN-US> </span></p>
<p class=MsoNormal><span style='font-family:宋體'>(</span><span lang=EN-US>4</span><span
style='font-family:宋體'>)雙擊“</span><span lang=EN-US>ASPNET</span><span
style='font-family:宋體'>”,選擇“隸屬于”</span></p>
<p class=MsoNormal><span lang=EN-US><img width=404 height=450
src="數(shù)據(jù)庫鏈接設置.files/image004.jpg"></span></p>
<p class=MsoNormal><span lang=EN-US> </span></p>
<p class=MsoNormal><span style='font-family:宋體'>如果沒有</span><span lang=EN-US>Administator</span><span
style='font-family:宋體'>則單擊添加,將</span><span lang=EN-US>ASPNET</span><span
style='font-family:宋體'>加入</span><span lang=EN-US>adminisrtator</span><span
style='font-family:宋體'>組。</span></p>
<p class=MsoNormal><span lang=EN-US><img width=521 height=586
src="數(shù)據(jù)庫鏈接設置.files/image005.jpg"></span></p>
<p class=MsoNormal><span lang=EN-US> </span></p>
<p class=MsoNormal><span lang=EN-US> </span></p>
<p class=MsoNormal><span style='font-family:宋體'>這樣就可以使用</span></p>
<p class=MsoNormal><span lang=EN-US>ConnectionString=”server=(local);database=”onnetbooksell”;Trusted_Connection=yes”;</span></p>
<p class=MsoNormal><span lang=EN-US> </span><span style='font-family:宋體'>進行鏈接。</span></p>
<p class=MsoNormal><span lang=EN-US> </span></p>
<p class=MsoNormal><span style='font-family:宋體'>方法二:使用基于</span><span
lang=EN-US>SQL</span><span style='font-family:宋體'>身份驗證的權限問題</span></p>
<p class=MsoNormal><span lang=EN-US> </span><span style='font-family:
宋體'>默認情況下,</span><span lang=EN-US>SQL Server</span><span style='font-family:
宋體'>使用的帳號為</span><span lang=EN-US>sa</span><span style='font-family:宋體'>,密碼為空,如果你使用該帳號,可以設置鏈接字符串為:</span></p>
<p class=MsoNormal><span lang=EN-US>ConnectionString=”server=(local);database=”onnetbooksell”;user=sa;pwd=’’”;</span></p>
<p class=MsoNormal><span lang=EN-US> </span></p>
</div>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -