外文翻譯---開(kāi)發(fā)基于sqlserver的cs數(shù)據(jù)庫(kù)應(yīng)用系統(tǒng)(參考版)
2025-05-17 09:45本頁(yè)面
【正文】 UID=t ssql=″select*from 工資情況 Set mrdors= 。 The user password is: 355。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。 The user name and the user password the fence and Password in the fence inputs which when Login ID lands SQL Server uses。 Inputs SQL in Server SERVER server, like hfserver。 In the database frame, chooses the database which the user must visit. (4) singleclicks ADD the button. Duplicates a time of password. 7. in SQL Server for database user establishment visit jurisdiction (1) certainly must for visit its user in SQL Server for the database user establishment visit jurisdiction regarding the newly opened database to provide the jurisdiction, otherwise this database is cannot visit. (2) starts Microsoft SQL Server EM, chooses the suitable server as well as the database. (3) chooses Object from the Object menu the Permission vegetable single item, again in springs in the dialog box listed has singleclicked By Us the label. (4) must want to award a user or the user group specific jurisdiction, so long as pulls the type from User/Group to tabulate designated the user or the user group, and singleclicks the corresponding jurisdiction the unit standard. (5) finally singleclicks Set the button, preserves the establishment. Moreover, SQL Server has also provided the function formidable backup for the system manager and restores the database function. But, wants to visit SQL Server from the work 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 carry on the establishment to customer end ODBC. ODBC (opening database connection) is Microsoft is one kind of strategy which the application procedure development personnel provides. It uses sole 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 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。 Logic Device is the database logic equipment name, Size is this logical equipment for the database assignment storage space (MB). Please does not want reelection Default the Device option. (6) according to Create the Now button, officially founds the database. 3. in the database which has founded the data sheet (1) procedure group to open SQL EM from Microsoft SQL Server in Utilties. (2) in Server in
畢業(yè)設(shè)計(jì)相關(guān)推薦
鄂ICP備17016276號(hào)-1