With DSN vs DSN Less Database Connections

**Adrina_g** · 15-02-2010

Hello, I am learning java programming language. And while learning it, I have been confused about the two different types of connections available in java as With DSN and DSN Less Database Connection. If anyone know it in detail, then please provide some information about it, in java. I will be thankful to you for that. I have search same on internet, but I am not able to get the details about it, so please reply me with some information about it.

**Zecho** · 15-02-2010

Hello, if you are making use of the DNS less connection then you must need to make use of the code below and create a connection :

Code:

 DataConn.Open "DBQ=" &  Server.Mappath("../_database/database.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};"

And for that you can simply make use of the code below if you are making use of the OLE connection with the Access 97:

Code:

DataConn.Open "Data Source=" & Server.Mappath("../_database/database.mdb") & ";Provider=Microsoft.Jet.OLEDB.3.51;"

**Reegan** · 15-02-2010

If you are created the DSN ie. the Data Source Name then you can make use of the code below for creating the connection :

Code:

<%
	Dim connection 
		Set connection  = Server.CreateObject("ADODB.Connection")

	connection .Open "DSN=mydsn"

	' Database connection is successful
	' Add your code here
	'You will need to close the connection if you have done your work, so close it. 

	connection .Close
	Set connection  = Nothing
%>

**opaper** · 15-02-2010

If you want to know the details about the With DSN vs DSN Less Database Connections, then you must need to first consider the need of both of this technique:
Need of DSN Connections:

It will help you with the Data Source Name.
It will be helpful to you when the you need to hold the collection of Data sources with a central repository you can make use of it.

Use of the DSN less Connections:

It is helpful to you when you are unable to register your own dsn.
As it uses the native OLE DB providers it provides the faster response to the database use.

**MindSpace** · 15-02-2010

Hello, if you want to create a connection with the database without the use of the DSN then you can simply able to make use of the code below:

Code:

<%
	Dim connection 
		Set connection  = Server.CreateObject("ADODB.Connection")

	connection .Open "Provider=Microsoft.Jet.OLEDB.4.0; Data" & _
		"Source=c:\path\to\database.mdb"

	' You are connected with the open database.
	' Add you all of the code here
	'If you compete your coding then just close the connection 

	connection .Close
	Set connection  = Nothing
%>

**Modifier** · 15-02-2010

Hello, if you are making use of the DSN-less connections while making the database connection then you will able to work more faster than the use of the DSN connection while making the connection with the database. Though it is a similar in use, but the dsnless connection is not having any type of access to the registry during the connection process. Many times mostly the OLEDB connections are used over both of these connections. As the OLEDB connection will provide you more faster access to the database than these database connection.