How to access the records of a three-tier structure database
Three-tiered (3-tier) structure, the database may be located in another computer, and the Web server IIS is a different computer.
So how to access the three-tier structure of the database records?
To access a database located in another computer, as long as the computer is installed on the network (Internet or intranet), the computers that will install the database are connected to the computer of the Web server IIS, and then on the computer of the Web server IIS, the ODBC (or OLE DB) driver.
For SQL Server databases, the ASP code for the database link is as follows:
Set Conn = Server.CreateObject ("ADODB. Connection ")
Conn. Open "Driver={sql Server};D atabase= database name; server=202.96.144.216.; Uid=sa; Pwd= "
server= in ASP code ... Set the IP address of the database computer.