Question

Refer back to the database you created in W1 Assignment 3 for ACSCars, Inc., a car manufacturing firm. As mentioned previously, ACSCars, Inc. intends to launch a web-based database application for its vendors and dealers and they want to develop the application by using MySQL as the database.

In this assignment, complete the following tasks:

Using ADO.NET and naming the database as ACSCars, write the code for establishing a connection with the ACSCars database, first using a DSN and then a DSN-less connection, assuming MySQL as the database. Use the following information:

Parameters

Connection Name: conAK

Database: ACSCars

User Name: Mathew

Password: Mathew

Explain the different types of connection statements associated with the parameters used in the above connection.

Enhance the above connection by changing the connection time-out to two minutes and the security to mixed mode.

Answer 1

Here is the simple method to establish a DSN-less connection to the database..

A DSN-less connection can be used against any Microsoft Access database on your web site

For your database called "ACSCars.mdb" located in a web directory like "c:/webdata/", you can connect to the database with the following ASP code:

<---
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/ACSCars.mdb"
--->

Note:::

For the above condition to satisfy , that you have to specify the Microsoft Access database driver (Provider) and the physical path to the database on your computer.

Connection using DSN::

Create an ODBC Database Connection

You have the ODBC database called "ACSCars" you can connect to the database with the following ASP code:

<---
set conn=Server.CreateObject("ADODB.Connection")
conn.Open "ACSCars"
--->

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

Creating An ODBC Connection to an MYSQ Database

Here is how to create a connection to a MS Access Database:

1. Open the ODBC icon in your Control Panel.
2. Choose the System DSN tab.
3. Click on Add in the System DSN tab.
4. Select the Microsoft Access Driver. Click Finish.
5. In the next screen, click Select to locate the database.
6. Give the database a Data Source Name (DSN).
7. Click OK

Here is the pictorial representation ->>>

You can manually add the following details:::

Connection Name: conAK

Database: ACSCars

User Name: Mathew

Password: Mathew

Changing Security Mode ::

You can use SQL Management Studio or use the following

ALTER LOGIN sa ENABLE ;  
GO  
ALTER LOGIN sa WITH PASSWORD = '<enterStrongPasswordHere>' ;  
GO 

Types of connection statements associated:::

Attributes :: Sets or returns the attributes of a Connection object

CommandTimeout ::: Sets or returns the number of seconds to wait while attempting to execute a command

ConnectionTimeout:::   Sets or returns the number of seconds to wait for a connection to open

DefaultDatabase:::   Sets or returns the default database name

Changing the connection time-out::

<---
set conn=Server.CreateObject("ADODB.Connection")
conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0"
conn.ConnectionTimeout=30
conn.open server.mappath("database.mdb")

conn.close
--->

This is the detailed answer for the question you have given.

As the infromation is not sufficient and quiet confusing I am confined to this answer.

Any Queries Hit the comment box