外文翻譯---開(kāi)發(fā)基于sqlserver的cs數(shù)據(jù)庫(kù)應(yīng)用系統(tǒng)-資料下載頁(yè)
2025-05-12 09:45本頁(yè)面
【導(dǎo)讀】級(jí)數(shù)據(jù)庫(kù)管理器相同的運(yùn)行性能，向傳統(tǒng)的數(shù)據(jù)庫(kù)廠(chǎng)商發(fā)起了強(qiáng)有力的挑戰(zhàn)。器事務(wù)管理，提供了一種把SQLServer系統(tǒng)擴(kuò)展而超出單個(gè)計(jì)算機(jī)能力的方法。數(shù)據(jù)庫(kù)隱式部分，以及數(shù)據(jù)完整性保護(hù)都適用；和對(duì)稱(chēng)多處理，并且可集成到分布式管理環(huán)境中；在低造價(jià)平臺(tái)上也具有突出性能；對(duì)多處理器“分布式”事務(wù)的內(nèi)在支持。構(gòu)筑開(kāi)發(fā)環(huán)境，完成一般的客戶(hù)/服務(wù)器應(yīng)用系統(tǒng)。在ServerManager窗口里，選擇創(chuàng)建數(shù)據(jù)庫(kù)的服務(wù)器。選擇Manage菜單項(xiàng)，然后選擇DatabaseDevice選項(xiàng)。選擇NewDevice按鈕（第一個(gè)）。單擊CreateNow按鈕，創(chuàng)建此設(shè)備。稱(chēng)，Size是該邏輯設(shè)備為數(shù)據(jù)庫(kù)分配的存儲(chǔ)空間。目，并顯示出可操作的所有數(shù)據(jù)庫(kù)對(duì)象。就可以修改它）。按Save按鈕，保存表格。單擊數(shù)據(jù)庫(kù)旁的加號(hào)，ServerManager會(huì)展開(kāi)數(shù)據(jù)庫(kù)，并列出所有組件。隨后屏幕上會(huì)出現(xiàn)ManageTables窗口。會(huì)顯示出未設(shè)為Nulls的一。請(qǐng)選擇適當(dāng)?shù)牧校蛊涑蔀橹麝P(guān)鍵字。對(duì)于主關(guān)鍵字來(lái)說(shuō)，索引類(lèi)型應(yīng)定義為。增加的字段將不允許為非NULL型。啟動(dòng)SQLEM,選擇相應(yīng)的數(shù)據(jù)庫(kù)。庫(kù)是不能被訪(fǎng)問(wèn)的。
【正文】 elational DBMS (database management system). It causes the database development personnel at development database application system time, may use familiar ODBC the SQL grammar, but does not use the consideration data pool is any. 8. Below is the customer carries ODBC the establishment and the debugging method (1) regarding the USER DSN establishment 1) The start in the menu chooses the establishment in the system, singleclicks the control panel, springs the control panel frame. 2) doubleclicks 32bit ODBC the chart sign, springs ODBC data source administrator the window, the choice USE R DSN the page, singleclicks Add... Button. 3) in the window chooses SQL SERVER after Create New Data Source, singleclicks pletes the button, springs ODBC SQL SERVER Setup the window. 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。 Singleclicks the Option button, inputs SQL in Database Name SERVER database, if PMS98, singleclicks OK the button. 5) singleclicks determines the button. (2) regarding File DSN debugging 1) the start in the menu chooses the establishment regarding the File DSN debugging in the system, singleclicks the control panel, springs the control panel frame. 2) doubleclicks 32bit ODBC the chart sign, springs ODBC data source administrator the window, the choice File DSN the page, singleclicks Add... Button. 3) in the window chooses SQL SERVER after Create New Data Source, singleclicks next step the button, in springs in the input frame inputs data source name, if pms, singleclicks next step the button, in springs in the information frame singleclicks pletes the button. 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 which when Login ID lands SQL Server uses。 Then singleclicks Options the button, fence chooses SQL in Options in the frame Database which wants to land Server database. Then singleclicks OK the button. Isual Basic is a function formidable visible programming tool which Microsoft promotes. It relies on with the ODBC good connection and provides to the user the extremely perfect work database visit controls, wins domestic and foreign multitudinously programs amateur39。s favour. Had Visual Basic we to be allowed to use its ODBC connection to establish in several minutes based on the SQL Server client/server database application software. 9. Below uses programming monly used DAO and the RDO two methods, for everybody introduced how uses Visual Basic visits longdistance SQL the Server database (1) To open the longdistance database with the DAO method 1) In local ODBC FileDSN establishment and SQL SERVER connection data pool. □needs to suppose: 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) 2) increases data to control, as well as DBGrid controls 3) to increase the following code in the procedure: Supposes data pool named pms。 User named: Test。 The user password is: 355。 SQL the Server data sheet is: Wages situation. 4) Operating procedure then. (2) opens the longdistance database with the RDO method 1) In local ODBC UserDSN establishment and SQL SERVER connection data pool. Needs to suppose: Data Source Name: Data source name, Descrption: Description, Server:SQL Server server, D atabase Name: Database. (This kind of establishment may suppose under single plane condition) . 2) increases in the procedure… Pr Set mrdoconn=(″pms″,rdDriverNoPrompt,False,″ODBC。UID=t ssql=″select*from 工資情況 Set mrdors=
畢業(yè)設(shè)計(jì)相關(guān)推薦
鄂ICP備17016276號(hào)-1