Tag: ado

Questions Related to ado

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

  1. Connection object

  2. Connection string

  3. Both

Show answer
Correct Option: C

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
asp ado

  1. DSN

  2. DSN-less

  3. Neither - the code is wrong

Show answer
Correct Option: C

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
asp ado

  1. DSN

  2. DSN-less

  3. Neither - the code is wrong

Show answer
Correct Option: A

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
asp ado

  1. DSN

  2. DSN-less

  3. Both A and B

  4. Neither - the code is wrong

Show answer
Correct Option: D

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
asp ado

  1. DSN

  2. DSN-less

  3. Neither - the code is wrong

Show answer
Correct Option: C

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
asp ado

  1. True

  2. False

Show answer
Correct Option: B

It is okay to have connections open to multiple Access databases
asp ado

  1. True

  2. False

Show answer
Correct Option: A

What is the sequential procedure in working with databases?
asp ado

  1. Connection string, connection object, close connection string, close connection object

  2. Connection object, connection string, close connection string, close connection object

  3. Connection object, connection string, close connection object, close connection string

Show answer
Correct Option: B