visual forpro 与 SQL Server建立连接方法(国外英语资料).docVIP

visual forpro 与 SQL Server建立连接方法(国外英语资料) The visual forpro is connected to SQL Server, and TXT is just as long as I have, and youre going to have to go out there and Im just waiting for you. Listen to me, ask so much why, I be with you, you still walk wrong way! Follow me!!!!!!! Its my fault not to give you happiness, but who makes you unhappy, I TMD cut him off Create the ODBC data source (DSN) Abstract: this article focuses on the connection between VFP and SQL Server and the problem and the wrong solution Here refers to the connection relationship (connection) refers to when the VFP through interface card, SQL Server network architecture, transmission media, communication protocol and other complex operation after the combination and connection to the SQL Server process. Safety measure Believe everyone understand the data confidentiality and importance, so youd better take some safety measures to protect it from the method of access and sabotage. Better prepared than sorry. The security of setting and maintaining data is the responsibility of the system Administrator (Administrator). If your application is C/S structure, users of the program must be authenticated first to get access to information, that is, the user can use the SQL set in the user name and password, or directly with Windows NT directory username and password to access the SQL database in the database. (please contact the SQL system administrator). The general practice of entering user name and password If your program needs to enter a user name and password, the general approach is to display a dialog box on the screen for user input. A TEXTBox control in VFP is very fit for this job, it has a passchar attributes, allows developers to design for characters to blanking (usually *, a program about encryption and algorithm can refer to VFP programming skills) input from the users password. Establish the ODBC data source (DSN) The ODBC Data Source (Data Source Name: DSN) is the only identify the Name