c++连接sql（The c++ connection SQL）.docVIP

c++连接sql（The c++ connection SQL） C++ connect SQL database step by step We were in the C++ SQL database connection operation, first should be the corresponding system configurations, and then initializes the C++ and SQL connection, and then the data connection operation, and then the application of SQL language to perform specific operations. C++ connect to the SQL database; the first step is system configuration 1. set the SQLSERVER server for the SQL login mode, and the system security SA users to set the login function is enabled, and there must be a password. 2. data source configuration in the ODBC data source, choose SQL SERVER, SQL SERVER login verification using user login ID and password, and fill in the login name and password (SA), note that the password can not be empty, which means you sa users you must have a password. Otherwise, you cannot pass the security policy of the system itself. The tests were completed and the configuration was completed. C++ connects to the SQL database, and the second step C++ initializes the SQL connection 1. introduce ADO into the stdafx.h header file in the C++ project you created The specific code is as follows #import c:\Program Files\Common Files\System\ado\msado15.dll no_namespace rename (EOF, adoEOF) rename (BOF, adoBOF) 2. definition of _ConnectionPtr Connection objects after calling the Open method to establish a connection with the server. The data type _ConnectionPtr is actually a concrete instance class obtained by the class template _com_ptr_t. The _ConnectionPtr class encapsulates the Idispatch interface pointer of the Connection object and some of the necessary operations. You can manipulate the Connection object with this pointer. For example, to connect to the SQLServer database, the code is as follows: Connect to the MS SQL Server / / / / initialize the pointer _ConnectionPtr pMyConnect = NULL; HRESULT HR = pMyConnect.CreateInstance (__uuidof (Connection)); If (FAILED (HR)) Return; / / initialize link param