Shulou(Shulou.com)06/02 Report--

This article mainly explains "What is ADO connection object". The explanation content in this article is simple and clear, easy to learn and understand. Please follow the idea of Xiaobian and go deep into it slowly to study and learn "What is ADO connection object" together!

The easiest way to create a DSN-less database connection to a database is to use a DSN-less connection. DSN-less connections can be used with any Microsoft Access database on your site. Assuming you have a database named "northwind.mdb" in the web directory "c:/webdata/," you can connect to this database using the following ASP code:

Note that in the example above, you must specify Microsoft's Access database driver (Provider) and the physical path of this database on your computer.

Create an ODBC database connection

With an ODBC connection, you can connect to any database on any computer in your network, as long as an ODBC connection is available.

ODBC connections to MS Access databases

Here's how to create a connection to an MS Access database:

Open the ODBC icon in the Control Panel Select the System ODBC tab Click the Add button in the ODBC tab Select Driver to Microsoft Access and click the Finish button Click the Select button in the next window to locate the database Give the database a Data Source Name (DSN) Click OK

Note: This configuration must be done on the computer on which your website resides. If you are running PWS or IIS on your own computer, this architecture works, but if your Web site is on a remote server, you must have physical access to that server or ask your web hosting provider to do this for you.

ADO Connection Objects are used to create open connections to a data source. This connection allows you to access and manipulate this database. View all methods and properties of this connection object.

Thank you for reading, the above is "ADO connection object is what" the content, after the study of this article, I believe we have a deeper understanding of ADO connection object is what this problem, the specific use of the situation also needs to be verified by practice. Here is, Xiaobian will push more articles related to knowledge points for everyone, welcome to pay attention!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.