Shortcut Navigation:

ASP ADO Quiz

Database connectivity with ADO has 3 main objects:

What is the sequential procedure in working with databases?

ActiveX Data Objects (ADO) comes installed with ASP and allows your pages to easily connect to databases. Which two ADO objects are used to open a connection and interact with the database?

What is a connection object?

What is a connection string?

There are two methods of connecting to an Access database. Which are they?

Which connection method requires a connection object?

Which connection method requires a connection string?

What information can a connection string contain about the database you are trying to connect to?

What must your ASP code have if you are using the DSN method of connecting?

What must your ASP code have if you are using the DSN-less method of connecting?

Which connection method is this code using?...Dim dbConn Set dbConn = Server.CreateObject("ADOBD.Connection") dbConn.Connectionstring = "DSN=Quiz; uid=login; pwd=password" dbConn.Open

Which connection method is this code using?.. Dim dbConn Set dbConn = Server.CreateObject("ADODB.Connection") dbConn.Connectionstring = "DSN=Quiz; uid=login; pwd=password" dbConn.Open

Which connection method is this code using?..Dim dbConn Set dbConn = Server.CreateObject("ADODB.Connection") dbConn.ConnectionString = "Driver={Microsoft Access Driver (*.mdb)};" & _ "DBQ=C:\wwwroot\username\database.mdb" dbConn.open

Which connection method is this code using?..Dim dbConn Set dbConn = Server.CreateObject("ADODB.Connection") dbConn.ConnectionString = "Driver={Microsoft Access Driver (*.mdb)};" & _ "DBQ=C:\wwwroot\username\database.mdd" dbConn.Open

While it is important to properly open the connection to the database, it is equally important to close the connection. Leaving a connection open is the same as leaving your house with the door open...Dim dbConn Set dbConn = Server.CreateObject("ADODB.Con

It is okay to have connections open to multiple Access databases

Tagged as: dbconn server createobject, dbconn server createobject, connect method, dbconn server createobject, dbconn server createobject, connect method, connect
Home | About | Create | Register | Privacy | Terms | Sitemap | [Facebook] [Twitter] [Google+]