Any database that provides ODBC drivers can become a Web database. After installing Access, your computer will contain the ODBC driver for the Access (. mdb) database: if your Nr has installed the Read L Server database, then the ODBC driver for SQL Server will also be installed; if you install VB5.0, your computer will have Access, Edge [Server, Oracle, dbase (. dbf), Text (. txt), Excel (. xls), Foxpr (. dbf) and Paradox (. db) And other databases. Let's briefly introduce common Web databases.
1、 SQLServer
SQLServer is a large and medium-sized database management and development software launched by Microsoft Website construction It has a very wide range of applications in the background database. It has many advantages: easy to use and good scalability. From portable computers to symmetric multiprocessor (SNIP) systems, it provides the data warehouse function, which is now only available in Oracle and other more expensive DBMS. Microsoft has bundled OLAPServer with SQLServer to create a comprehensive method of data warehouse processing. The goal of OLAPServer is to make it easier to generate data warehouse and data supermarket solutions using the new technology of Microsoft and the existing technology of other data warehouse system software companies. This is exactly what the website background database needs most.
The principle for setting SQLServetODBC parameters is: Driver={SQL Server}; Server=SQL Server name: Database=database name; Uid=user name: Pwd=password.
2、 Access
Access database is a file database. Ac~has poor performance and low security. It is usually not used in large websites. It is widely used on some personal websites because of its low requirements for the system, simple maintenance and low cost. In addition, compared with other databases, the Access ODBC driver supports the most complete SQL instructions.
The AccessODBC parameter settings are: driver; {Microsoft Access Driver (*. mdb) I; dbq=Full path name of the database.
