外文翻譯---開(kāi)發(fā)基于sql server 的cs數(shù)據(jù)庫(kù)應(yīng)用系統(tǒng)

1、<p><b>　　中文：</b></p><p>　　開(kāi)發(fā)基于SQL Server 的C/S數(shù)據(jù)庫(kù)應(yīng)用系統(tǒng)</p><p>　　SQL Server 作為面向中小型企業(yè)的網(wǎng)絡(luò)數(shù)據(jù)庫(kù)服務(wù)系統(tǒng)，提供了 與眾多高級(jí)數(shù)據(jù)庫(kù)管理器相同的運(yùn)行性能，向傳統(tǒng)的數(shù)據(jù)庫(kù)廠商發(fā)起了強(qiáng)有力的挑戰(zhàn)。在程 序設(shè)計(jì)方面：SQL Server 采用了關(guān)鍵而新穎的對(duì)稱式結(jié)構(gòu)，從而簡(jiǎn)化了程

2、序設(shè)計(jì)，并且 Microsoft在它的Visual Basic可視化編程語(yǔ)言中為程序員提供了良好的控件；在數(shù)據(jù)庫(kù)管 理方面：SQL Server 以一種易于管理的方式處理多服務(wù)器事務(wù)管理，提供了一種把SQL Server系統(tǒng)擴(kuò)展而超出單個(gè)計(jì)算機(jī)能力的方法。 SQL Server 主要具有以下幾個(gè)功能：</p><p>　　全面的數(shù)據(jù)完整性保護(hù)，無(wú)論是復(fù)雜的事務(wù)支持和高級(jí)安全性，還是面向用戶的數(shù)據(jù)庫(kù)隱式 部分

3、，以及數(shù)據(jù)完整性保護(hù)都適用；</p><p>　　與Windows NT集成，允許在SMP（對(duì)稱多處理）系統(tǒng)中進(jìn)行徹底的多線程和對(duì)稱多處理，并且可集成到分布式管理環(huán)境中；</p><p>　　在低造價(jià)平臺(tái)上也具有突出性能；</p><p>　　為系統(tǒng)管理員提供一流的管理工具；</p><p>　　對(duì)多處理器“分布式”事務(wù)的內(nèi)在支持。

4、</p><p>　　以下介紹一種怎樣利用Microsoft SQL Server 在Windows NT Server上構(gòu)筑開(kāi)發(fā)環(huán)境， 完成一般的客戶/服務(wù)器應(yīng)用系統(tǒng)。</p><p>　　1. 在SQL SERVER 上創(chuàng)建一個(gè)數(shù)據(jù)設(shè)備(在創(chuàng)建數(shù)據(jù)庫(kù)之前必須為該 數(shù)據(jù)庫(kù)創(chuàng)建一個(gè)存儲(chǔ)設(shè)備)</p><p>　　(1) 從 Microsoft SQL Ser

5、ver Utilties 程序組內(nèi)打開(kāi) SQL EM。</p><p>　　(2) 在Server Manager 窗口里，選擇創(chuàng)建數(shù)據(jù)庫(kù)的服務(wù)器。如hfnm.。</p><p>　　(3) 選擇Manage菜單項(xiàng)，然后選擇Database Device選項(xiàng)。出現(xiàn)Manage Database Device窗口。</p><p>　　(4) 選擇New De

6、vice 按鈕（第一個(gè)）。出現(xiàn)New Database Device窗口。</p><p>　　(5) Name：為所要?jiǎng)?chuàng)建的設(shè)備名；Location：可以選擇創(chuàng)建設(shè)備的地點(diǎn)（如：c:＼databas e）；Size(MB)：用于設(shè)定此設(shè)備的大?。ㄒ话銥閿?shù)據(jù)庫(kù)的1.25倍）。</p><p>　　(6) 單擊 Create Now按鈕，創(chuàng)建此設(shè)備。</p><p&g

7、t;　　注意：請(qǐng)?jiān)趧?chuàng)建數(shù)據(jù)庫(kù)之前必須先創(chuàng)建兩個(gè)存儲(chǔ)設(shè)備，一個(gè)是數(shù)據(jù)庫(kù)的物理設(shè)備，另一個(gè)是數(shù)據(jù)庫(kù) 的邏輯設(shè)備。</p><p>　　2. 在SQL SERVER 上創(chuàng)建一個(gè)數(shù)據(jù)庫(kù)</p><p>　　(1) 從 Microsoft SQL Server Utilties 程序組內(nèi)打開(kāi) SQL EM。</p><p>　　(2) 在Server Manager

8、窗口里，選擇創(chuàng)建數(shù)據(jù)庫(kù)的服務(wù)器。如hfnm.。</p><p>　　(3) 選擇Manage菜單項(xiàng)，然后選擇Database 選項(xiàng)。出現(xiàn)Manage Database窗口。</p><p>　　(4) 選擇New Database 按鈕（第一個(gè)）。出現(xiàn)New Database窗口。</p><p>　　(5) Name項(xiàng)為數(shù)據(jù)庫(kù)名，Data Device 為數(shù)

9、據(jù)庫(kù)物理設(shè)備名稱，Size是該物理設(shè)備 為數(shù)據(jù)庫(kù)分配的存儲(chǔ)空間（MB）；Logic Device為數(shù)據(jù)庫(kù)邏輯設(shè)備名稱，Size是該邏輯設(shè)備 為數(shù)據(jù)庫(kù)分配的存儲(chǔ)空間（MB）。請(qǐng)不要復(fù)選Default Device選項(xiàng)。</p><p>　　(6) 按Create Now按鈕，正式創(chuàng)建數(shù)據(jù)庫(kù)。</p><p>　　3. 在已有的數(shù)據(jù)庫(kù)上創(chuàng)建數(shù)據(jù)表</p><p>

10、　　(1) 從 Microsoft SQL Server Utilties 程序組內(nèi)打開(kāi) SQL EM。</p><p>　　(2) 在Server Manager 窗口里，選擇服務(wù)器。單擊所要?jiǎng)?chuàng)建數(shù)據(jù)表的數(shù)據(jù)庫(kù)旁的加號(hào)。再 單擊數(shù)據(jù)庫(kù)的Group/Users以及Objects組件。</p><p>　　(3) 單擊Objects組件旁邊的加號(hào)。Server Manager 將展開(kāi)O

11、bjects 項(xiàng)目，并顯示出可操作 的所有數(shù)據(jù)庫(kù)對(duì)象。</p><p>　　(4) 選擇Table對(duì)象。然后單擊Manager 菜單項(xiàng)，并選擇Tables項(xiàng)目。將出現(xiàn)Manager Table (管理表格)窗口。</p><p>　　(5) 現(xiàn)在保持Table組合框?yàn)?lt;new>（如果在組合框選擇了其他表，那 么就可以修改它）。</p><p>　　C

12、olumn name:字段名Datatype:字段類型</p><p>　　Size:字段長(zhǎng)度Nulls:是否允許空值</p><p>　　Default:默認(rèn)值</p><p>　　(6) 按Save按鈕，保存表格。</p><p>　　4. 為數(shù)據(jù)表創(chuàng)建主關(guān)鍵字</p><p>　　(1) 啟動(dòng)Micro

13、soft SQL Server EM ,選擇適當(dāng)?shù)姆?wù)器以及數(shù)據(jù)庫(kù)。單擊數(shù)據(jù)庫(kù) 旁的加號(hào)，Server Manager會(huì)展開(kāi)數(shù)據(jù)庫(kù)，并列出所有組件。</p><p>　　(2) 單擊Objects項(xiàng)目旁邊的加號(hào)，Server Manager會(huì)列出可操作的數(shù)據(jù)庫(kù)對(duì)象。</p><p>　　(3) 單擊Tables文件夾旁邊的加號(hào)。用右鍵點(diǎn)擊相應(yīng)的數(shù)據(jù)表對(duì)象，然后從彈出式菜單里選 擇Ed

14、it命令。隨后屏幕上會(huì)出現(xiàn)Manage Tables窗口。</p><p>　　(4) 單擊工具欄上的Advanced Features (高級(jí)特性)按鈕。隨后會(huì)出現(xiàn)與表格有關(guān)的更詳細(xì) 的信息。</p><p>　　(5) 在第一張卡片（Primary Key/Identity）里，可設(shè)置主關(guān)鍵字。單擊Primary Key窗框 里的Column Names(列名)組合框。會(huì)顯示出未設(shè)

15、為Nulls的一系列列名。請(qǐng)選擇適當(dāng)?shù)牧校?使其成為主關(guān)鍵字。</p><p>　　(6) 對(duì)于主關(guān)鍵字來(lái)說(shuō)，索引類型應(yīng)定義為（non-clustered）。單擊Add按鈕，在表格里添 加主關(guān)鍵字信息。</p><p>　　注意：① 主關(guān)鍵字的定義對(duì)于一個(gè)數(shù)據(jù)表來(lái)說(shuō)是非常重要的，如果沒(méi)有主關(guān)鍵字，那么這個(gè)數(shù)據(jù) 表將是只讀的。</p><p>　　② 主關(guān)鍵字

16、的定義必須在數(shù)據(jù)表保存之前，因?yàn)閿?shù)據(jù)表在保存后，所增加的字段將不允許為非NULL型。</p><p>　　5. 為表格創(chuàng)建群集索引</p><p>　　(1) 啟動(dòng)SQL EM,選擇相應(yīng)的數(shù)據(jù)庫(kù)。</p><p>　　(2) 從Manage菜單里選擇Indexes選項(xiàng)。</p><p>　　(3) 在Table組合框里，選擇適當(dāng)?shù)臄?shù)據(jù)

17、表。在Index組合框里，選擇<new>，以便創(chuàng)建一個(gè) 新索引。在里面輸入新索引的名字。</p><p>　　(4) 在Available Columns In Table (表格內(nèi)的可用列)列表內(nèi)，選擇適當(dāng)?shù)牧胁聪翧dd按 鈕。這樣會(huì)將列名移至Columns In Index(Key)列表框。還可選擇多列。</p><p>　　(5) 在Index Attribute

18、(索引屬性)窗框內(nèi)，選擇Clustered (群集)復(fù)選框。</p><p>　　(6) 在Clustered旁邊的兩個(gè)單選鈕中，Allow duplicate rows 表示允許重復(fù)行。</p><p>　　(7) 按Build按鈕，開(kāi)始創(chuàng)建索引。</p><p>　　6. 在SQL Server中為數(shù)據(jù)庫(kù)開(kāi)用戶</p><p>　

19、　(1) 啟動(dòng)Microsoft SQL Server EM ,選擇適當(dāng)?shù)姆?wù)器。</p><p>　　(2) 選擇login目錄，單擊右鍵，選擇 New Login...，彈出 Manage Logins窗口。</p><p>　　(3) 在Login Name中輸入用戶名；在Password中輸入用戶密碼；在數(shù)據(jù)庫(kù)框中，選擇用戶所 要訪問(wèn)的數(shù)據(jù)庫(kù)。</p><

20、;p>　　(4) 單擊“ADD”按鈕。重復(fù)一次密碼。</p><p>　　7. 在SQL Server中為數(shù)據(jù)庫(kù)用戶設(shè)置訪問(wèn)權(quán)限</p><p>　　(1) 對(duì)于新開(kāi)的數(shù)據(jù)庫(kù)一定要為訪問(wèn)它的用戶提供權(quán)限，否則這個(gè)數(shù)據(jù)庫(kù)是不能被訪問(wèn)的。 </p><p>　　(2) 啟動(dòng)Microsoft SQL Server EM ,選擇適當(dāng)?shù)姆?wù)器以及數(shù)據(jù)庫(kù)。&l

21、t;/p><p>　　(3) 從Object菜單中選擇Object Permission菜單項(xiàng)，再在彈出的對(duì)話框中列出了單擊By Us er標(biāo)簽。</p><p>　　(4) 要想授予一個(gè)用戶或用戶組特定的權(quán)限，只要從User/Group下拉式列表中選定用戶或用 戶組，并單擊相應(yīng)權(quán)限的單元格。</p><p>　　(5) 最后單擊“Set”按鈕，保存設(shè)置。<

22、/p><p>　　另外，SQL Server 也為系統(tǒng)管理員提供了功能強(qiáng)大的備份和恢復(fù)數(shù)據(jù)庫(kù)功能。</p><p>　　但是，想從網(wǎng)絡(luò)客戶機(jī)訪問(wèn)SQL Server只設(shè)服務(wù)器方還不行。利用Visual Basic 對(duì)SQL Ser ver進(jìn)行編程還需要對(duì)客戶端的ODBC進(jìn)行設(shè)置。</p><p>　　ODBC（開(kāi)放數(shù)據(jù)庫(kù)連接）是Microsoft為應(yīng)用程序開(kāi)發(fā)人員提

23、供的一種策略。它采用 單一的API來(lái)輻射各種不同的數(shù)據(jù)庫(kù)引擎、關(guān)系和非關(guān)系的DBMS（數(shù)據(jù)庫(kù)管理系統(tǒng)）。它使 數(shù)據(jù)庫(kù)開(kāi)發(fā)人員在開(kāi)發(fā)數(shù)據(jù)庫(kù)應(yīng)用系統(tǒng)的時(shí)候，可以使用熟悉的ODBC SQL語(yǔ)法，而不用考慮 數(shù)據(jù)源是什么。</p><p>　　8. 以下是客戶端ODBC的設(shè)置和調(diào)試方法</p><p>　　(1) 對(duì)于USER DSN的設(shè)置</p><p>　　① 在

24、系統(tǒng)的“開(kāi)始”菜單上選擇“設(shè)置”，單擊其中的“控制面板”，彈出控制面板框。 </p><p>　?、?雙擊“32bit ODBC”圖標(biāo)，彈出“ODBC data source administrator”窗口，選擇“USE R DSN”頁(yè)，單擊“Add...”按鈕。</p><p>　?、?在“Create New Data Source”窗口中選擇“SQL SERVER”后，單擊“完

25、成”按鈕，彈 出“ODBC SQL SERVER Setup”窗口。</p><p>　?、?在 Data Source Name 中輸入數(shù)據(jù)源名，如“pms”；在 Description 中輸入描述信息 （可選）；在 Server 中輸入SQL SERVER 服務(wù)器名，如“hfserver”；單擊Option 按鈕， 在 Database Name 中輸入SQL SERVER 數(shù)據(jù)庫(kù)名，如“PMS98”，單擊

26、“OK”按鈕。</p><p>　　⑤ 單擊“確定”按鈕。</p><p>　　(2) 對(duì)于File DSN的調(diào)試</p><p>　　① 在系統(tǒng)的“開(kāi)始”菜單上選擇“設(shè)置”，單擊其中的“控制面板”，彈出控制面板框。 </p><p>　　② 雙擊“32bit ODBC”圖標(biāo)，彈出“ODBC data source administr

27、ator”窗口，選擇“Fil e DSN”頁(yè)，單擊“Add...”按鈕。</p><p>　?、?在“Create New Data Source”窗口中選擇“SQL SERVER”后，單擊“下一步”按鈕， 在彈出的輸入框中輸入數(shù)據(jù)源名，如“pms”， 單擊“下一步”按鈕，在彈出的信息框中單 擊“完成”按鈕。</p><p>　?、?在彈出的SQL Server Login對(duì)話框中：在

28、“Server”欄中輸入SQL Server服務(wù)器名；在 “Login ID”欄和“Password”欄中輸入登陸SQL Server時(shí)用的用戶名和用戶口令；然后單 擊“Options”按鈕，在Options框中的Database欄中選擇所想登陸的SQL Server數(shù)據(jù)庫(kù)名 。然后單擊“OK”按鈕。 Visual Basic 5.0 是Microsoft推出的一個(gè)功能強(qiáng)大的可視化編程工具。它憑借與ODBC良好 的接口和提供給用戶極

29、其完善的網(wǎng)絡(luò)數(shù)據(jù)庫(kù)訪問(wèn)控件，贏得國(guó)內(nèi)外眾多編程愛(ài)好者的青睞。 有了Visual Basic我們可以利用它的ODBC接口在幾分鐘內(nèi)編制一個(gè)基于SQL Server的客戶機(jī) /服務(wù)器數(shù)據(jù)庫(kù)應(yīng)用軟件。</p><p>　　9. 以下采用編程常用的DAO和RDO兩種方法，為大家介紹 一下怎樣使用Visual Basic 5.0訪問(wèn)遠(yuǎn)程SQL Server數(shù)據(jù)庫(kù)</p><p>　　(1)

30、用DAO方法打開(kāi)遠(yuǎn)程數(shù)據(jù)庫(kù)</p><p>　?、?在本地ODBC的FileDSN中設(shè)置與SQL SERVER連接的數(shù)據(jù)源。</p><p>　　需要設(shè)：Data Source Name:數(shù)據(jù)源名，Server:SQL服務(wù)器名，Login ID:用戶名，Password :用戶口令，Database Name:數(shù)據(jù)庫(kù)名。(這種設(shè)置不可在單機(jī)狀態(tài)下設(shè))</p><p

31、>　?、?添加data控件，以及一個(gè)DBGrid控件</p><p>　?、?在程序中添加如下代碼：假定數(shù)據(jù)源名為pms;用戶名為：test；用戶口令為：355；SQL Server數(shù)據(jù)表為：工資情況。</p><p>　　Dim ssql As String</p><p>　　Data1.Connect=″ODBC;DSN=pms;uid=test;

32、pwd=355″</p><p>　　ssql=″select*from 工資情況″</p><p>　　Data1.RecordSource=ssql</p><p>　　Data.Refresh</p><p>　?、?運(yùn)行程序即可。</p><p>　　(2) 用RDO方法打開(kāi)遠(yuǎn)程數(shù)據(jù)庫(kù)</p&

33、gt;<p>　　① 在本地ODBC的UserDSN中設(shè)置與SQL SERVER連接的數(shù)據(jù)源。</p><p>　　需要設(shè)：Data Source Name:數(shù)據(jù)源名，Descrption:描述，Server:SQL Server服務(wù)器名，D atabase Name:數(shù)據(jù)庫(kù)名。(這種設(shè)置可在單機(jī)狀態(tài)下設(shè))</p><p>　?、?在程序中添加：</p>

34、<p>　　Option Explicit</p><p>　　Private mrdoenv As rdoEnvironment</p><p>　　Private mrdoconn As rdoConnection</p><p>　　Private mrdors As rdoResultset</p><p>　　Pr

35、ivate Sub Command1Click()</p><p>　　Dim ssql As String</p><p>　　Set mrdoenv=rdoEnvironments(0)</p><p>　　Set mrdoconn=mrdoenv.OpenConnection(″pms″,rdDriverNoPrompt,False,″ODBC;UID=

36、te st;PWD=355″)</p><p>　　ssql=″select*from 工資情況″</p><p>　　Set mrdors=mrdoconn.OpenResultset(ssql,rdOpenKeyset,rdConcurRowVer,0)</p><p>　　出處：專家系統(tǒng)與應(yīng)用, 37卷, 9月份發(fā)行9到2010年,頁(yè)6482-6492&

37、lt;/p><p><b>　　英文原文：</b></p><p>　　Source:Expert Systems with Applications Volume 37. Issue 9. September 2010. Pages 6482-6492 </p><p>　　Development based on SQL SERVER C/S

38、database application system</p><p>　　SQL the Server achievement face the small and medium-sized enterprise the network database service system, has provided with the multitudinous high-level data bank admin

39、istration same performance characteristic, initiated the powerful challenge to the traditional database merchant. In programming aspect: SQL Server has used the key but the novel symmetrical expression structure, thus s

40、implified the programming, and Microsoft visible programming language provided good in its Visual in the Basic</p><p>　　SQL Server mainly has following several functions：</p><p>　　Comprehensive

41、 data integrity protection, regardless of is the complex business support and the high-level security, or hides the type face user's database to be partial, as well as the data integrity protection all is suitable;&l

42、t;/p><p>　　With Windows the NT integration, allows in SMP (symmetrical multiprocessing) in the system to carry on the thorough multithreading and the symmetrical multiprocessing, and may integrate in the distri

43、butional management environment;</p><p>　　Also has the prominent performance in the low construction cost platform;</p><p>　　Provides the first-class management tool for the system manager;</

44、p><p>　　To multi-processor "distributional" business intrinsic support.</p><p>　　Below introduced how one kind does use Microsoft SQL Server to construct the development environment on W

45、indows NT Server, completes the general customer/server application system.</p><p>　　on founds a data equipment in SQL SERVER (in front of foundation database must for this database found a storage device)&

46、lt;/p><p>　　procedure group opens SQL EM from Microsoft SQL Server in Utilties.</p><p>　　In Server in Manager window, choice foundation database server. If hfnm. .</p><p>　　Chooses th

47、e Manage vegetable single item, then chooses Database the Device option. Appears Manage Database the Device window.</p><p>　　Chooses New the Device button (first). Appears New Database the Device window.<

48、/p><p>　　Name: For equipment which must found; Location: May choose founds the equipment the place (for example: C: \ databas e); Size (MB): Uses in to establish this equipment the size (generally for database

49、1.25 times).</p><p>　　Single-clicks Create the Now button, founds this equipment.</p><p>　　Attention: Please in front of foundation database must first found two storage devices, is the database

50、 physical equipment, another is the database logical equipment.</p><p>　　2. on founds a database in SQL SERVER </p><p>　　(1) procedure group to open SQL EM from Microsoft SQL Server in Utiltie

51、s. </p><p>　　(2) in Server in Manager window, choice foundation database server. .</p><p>　　(3) chooses the Manage vegetable single item, then chooses the Database option. Appears Manage the Dat

52、abase window. </p><p>　　(4) chooses New the Database button (first). Appears New the Database window. </p><p>　　(5) the Name item for database, Data Device is the database physics equipment name

53、, Size is this physical equipment for the database assignment storage space (MB); Logic Device is the database logic equipment name, Size is this logical equipment for the database assignment storage space (MB). Please d

54、oes not want reelection Default the Device option. </p><p>　　(6) according to Create the Now button, officially founds the database.</p><p>　　3. in the database which has founded the data sheet

55、</p><p>　　(1) procedure group to open SQL EM from Microsoft SQL Server in Utilties. (2) in Server in the Manager window, chooses the server. Single-clicks must found the data sheet nearby the database plus

56、sign. Again single-clicks the database Group/Users as well as the Objects module. </p><p>　　(3) single-clicks nearby the Objects module the plus sign. Server Manager will launch the Objects project, and demo

57、nstrated might operate all databases object. </p><p>　　(4) chooses the Table object. Then single-clicks the Manager vegetable single item, and chooses the Tables project. Will appear Manager Table (managemen

58、t form) the window. </p><p>　　(5) the present maintains the Table combination frame for (if were combining frame to choose other tables, then was allowed to revise it). Column name: Field name Datatype: Fiel

59、d type □Size: Field length Nulls: Whether permits spatial value □Default: Tacitly approves the value </p><p>　　(6) according to the Save button, preserves the form. </p><p>　　4. founds the host

60、essential character for the data sheet </p><p>　　(1) to start Microsoft SQL Server EM, chooses the suitable server as well as the database. Single-clicks nearby the database the plus sign, Server Manager ca

61、n launch the database, juxtaposes all modules. </p><p>　　(2) single-clicks nearby the Objects project the plus sign, Server Manager can list the database object which may operate. </p><p>　　(3)

62、single-clicks nearby the Tables folder the plus sign. Clicks on the corresponding data sheet object with the right key, then from springs in the type menu to choose the Edit order. Afterwards on the screen can appear Man

63、age the Tables window. </p><p>　　(4) single-clicks on the tool fence Advanced Features (high-level characteristic) the button. Afterwards can appear with the form related more detailed information. </p>

64、;<p>　　(5) in the first card (Primary Key/Identity) in, may suppose the buyer essential character. Single-clicks in Primary Key window frame Column Names (a row name) to combine the frame. Can demonstrate has not

65、supposed is the Nulls a series of rows name. Please choose the suitable row, causes it to become primarily the essential character. </p><p>　　(6) said regarding the host essential character that, the index t

66、ype should define as (non-clustered). Single-clicks the Add button, increases the host essential character information in the form. □attention: </p><p>　　host essential character definition regarding a data

67、sheet said is count for much, if has not advocated the essential character, then this data sheet will be read-only. </p><p>　　b) host essential character definition must before the data sheet preservation, b

68、ecause the data sheet after the preservation, increases the field will not permit for non- NULL. </p><p>　　5. gathers in great number the index for the form foundation </p><p>　　(1) to start SQL

69、 EM, chooses the corresponding database. </p><p>　　(2) chooses the Indexes option from the Manage menu. </p><p>　　(3) in the Table combination frame, chooses the suitable data sheet. In Index co

70、mbination frame, choice, in order to founds a recent index. Inputs the recent index in inside the name. In </p><p>　　(4) (in form may use row) in Available Columns In Table to tabulate, chooses the suitable

71、row and presses down the Add button. This can arrange in order the name to move to Columns In Index (Key) tabulates the frame. Also may choose the multi- rows. </p><p>　　(5) in Index Attribute (index attribu

72、te) in the window frame, chooses Clustered (to gather in great number) the reelection frame. </p><p>　　(6) in Clustered two Shan Xuanniu, Allow duplicate rows expression permission repetition line. </p>

73、;<p>　　(7) according to the Build button, starts to found the index.</p><p>　　6. opens the user in SQL Server for the database </p><p>　　(1) to start Microsoft SQL Server EM, chooses the

74、 suitable server. </p><p>　　(2) chooses the login table of contents, single-clicks the right key, chooses New Login.. Springs Manage the Logins window. </p><p>　　(3) inputs user in Login Name; I

75、nputs the user password in Password; In the database frame, chooses the database which the user must visit. </p><p>　　(4) single-clicks "ADD" the button. Duplicates a time of password.</p>&

76、lt;p>　　7. in SQL Server for database user establishment visit jurisdiction</p><p>　　(1) certainly must for visit its user in SQL Server for the database user establishment visit jurisdiction regarding the

77、 newly opened database to provide the jurisdiction, otherwise this database is cannot visit. </p><p>　　(2) starts Microsoft SQL Server EM, chooses the suitable server as well as the database. </p>&l

78、t;p>　　(3) chooses Object from the Object menu the Permission vegetable single item, again in springs in the dialog box listed has single-clicked By Us the label. </p><p>　　(4) must want to award a user or

79、 the user group specific jurisdiction, so long as pulls the type from User/Group to tabulate designated the user or the user group, and single-clicks the corresponding jurisdiction the unit standard. </p><p>

80、;　　(5) finally single-clicks "Set" the button, preserves the establishment. </p><p>　　Moreover, SQL Server has also provided the function formidable backup for the system manager and restores the

81、database function.</p><p>　　But, wants to visit SQL Server from the network client only to suppose the server side not to be good. Carries on the programming using Visual Basic to SQL Ser ver also to need to

82、 carry on the establishment to customer end ODBC.</p><p>　　ODBC (opening database connection) is Microsoft is one kind of strategy which the application procedure development personnel provides. It uses sole

83、 API to radiate each kind of different database engine, relational and non- relational DBMS (database management system). It causes the database development personnel at development database application system time, may

84、use familiar ODBC the SQL grammar, but does not use the consideration data pool is any.</p><p>　　8. Below is the customer carries ODBC the establishment and the debugging method (1) regarding the USER DSN es

85、tablishment</p><p>　　1) "The start" in the menu chooses "the establishment" in the system, single-clicks "the control panel", springs the control panel frame. </p><p&

86、gt;　　2) double-clicks "32bit ODBC" the chart sign, springs "ODBC data source administrator" the window, the choice "USE R DSN" the page, single-clicks "Add..." Button. </p&g

87、t;<p>　　3) in the window chooses "SQL SERVER" after "Create New Data Source", single-clicks "completes" the button, springs "ODBC SQL SERVER Setup" the window. </p>

88、<p>　　4) inputs data source name in Data Source Name, like "pms"; Inputs the description information in Description (to be possible to elect); Inputs SQL in Server SERVER server, like "hfserver"

89、; Single-clicks the Option button, inputs SQL in Database Name SERVER database, if "PMS98", single-clicks "OK" the button. </p><p>　　5) single-clicks "determines" the button. &l

90、t;/p><p>　　(2) regarding File DSN debugging </p><p>　　1) "the start" in the menu chooses "the establishment" regarding the File DSN debugging in the system, single-clicks "

91、the control panel", springs the control panel frame. </p><p>　　2) double-clicks "32bit ODBC" the chart sign, springs "ODBC data source administrator" the window, the choice "Fil

92、e DSN" the page, single-clicks "Add..." Button. </p><p>　　3) in the window chooses "SQL SERVER" after "Create New Data Source", single-clicks "next step" the butt

93、on, in springs in the input frame inputs data source name, if "pms", single-clicks "next step" the button, in springs in the information frame single-clicks "completes" the button.</p>

94、<p>　　4) in SQL Server which springs in the Login dialog box: In the fence inputs SQL in "Server" Server server; The user name and the user password the fence and "Password" in the fence inputs

95、 which when "Login ID" lands SQL Server uses; Then single-clicks "Options" "the button, fence chooses SQL in Options in the frame Database which wants to land Server database. Then single-clicks

96、"OK" the button.</p><p>　　Isual Basic 5.0 is a function formidable visible programming tool which Microsoft promotes. It relies on with the ODBC good connection and provides to the user the extreme

97、ly perfect network database visit controls, wins domestic and foreign multitudinously programs amateur's favour. Had Visual Basic we to be allowed to use its ODBC connection to establish in several minutes based on t

98、he SQL Server client/server database application software.</p><p>　　9. Below uses programming commonly used DAO and the RDO two methods, for everybody introduced how uses Visual Basic 5.0 visits long-distanc

99、e SQL the Server database </p><p>　　(1) To open the long-distance database with the DAO method </p><p>　　1) In local ODBC FileDSN establishment and SQL SERVER connection data pool. □needs to s

100、uppose: Data Source Name: Data source name, Server:SQL server, Login ID: User, Password: User password, Database Name: Database. (This kind of establishment cannot suppose under single plane condition) </p><p&

101、gt;　　2) increases data to control, as well as DBGrid controls </p><p>　　3) to increase the following code in the procedure: Supposes data pool named pms; User named: Test; The user password is: 355; SQL the

102、Server data sheet is: Wages situation. </p><p>　　4) Operating procedure then. </p><p>　　(2) opens the long-distance database with the RDO method</p><p>　　1) In local ODBC UserDSN es

103、tablishment and SQL SERVER connection data pool.</p><p>　　Needs to suppose: Data Source Name: Data source name, Descrption: Description, Server:SQL Server server, D atabase Name: Database. (This kind of esta

104、blishment may suppose under single plane condition) .</p><p>　　2) increases in the procedure…</p><p>　　Option Explicit</p><p>　　Private mrdoenv As rdoEnvironment</p><p&

105、gt;　　Private mrdoconn As rdoConnection</p><p>　　Private mrdors As rdoResultset</p><p>　　Private Sub Command1Click()</p><p>　　Dim ssql As String</p><p>　　Set mrdoenv