2.2.1.2 create a database connection file

2.2.1.2 create a database connection file

After the database is created, perform Step 2 "connect to Database". To connect to the database, you have to talk about ADO. ADO is the abbreviation of ActiveX Data Object. It is a database access component developed by Microsoft. It provides real-time database access capabilities for Web developers. The connection code is as follows.

Knowledge: connection: used to provide database connection services. For example, you can use the connection object to open a connection with Microsoft Access. Before performing operations on a database, you must first establish a connection with the database to perform operations such as query and update.

<%

Set conn = Server. CreateObject ("ADODB. Connection ")

Conn. open "Provider = Microsoft. Jet. OLEDB.4.0; Data Source =" & Server. Mappath ("test. mdb ")

%>

Just a few words of code, although simple, there is a lot of knowledge in it.

Let's take a look at the first sentence. The first sentence is used to create a connection object. set is used to assign an object reference to a variable, in this way, we can use variables to call the connection object. Server. CreateObject is used to create Server component instances. The statement Set conn = Server. CreateObject ("ADODB. Connection") is used to create a connection object to the conn variable, so that we can call conn to connect to the database and perform other operations. In the second sentence, open is the method of the connection object to open the connection to the data source. The subsequent string is the connection method of the connection object. connection has different connection methods for different databases. Here we use the connection method to connect to the Microsoft access database. Other methods are as follows:

Database Type	Connection Method
Access ODBC	"Driver = {Microsoft Access Driver (*. mdb)}; dbq = *. mdb; uid = admin; pwd = pass ;"
Access OLEDB	"Provider = Microsoft. jet. oledb.5.0; data soures = ds; user id = admin; password = pass"
MSSql ODBC	"Driver = {SQL server}; server = servername; database = dbname; uid = sa; pwd = pass"
MSSql OLEDB	"Provider = SQLOLEDB; data source = ds; initial catalog = db; userid = sa; password = pas ;"
Index Service	"Provider = MSIDXS; Data source = catalog_name"
ODBC Data Source