Ms access and ASP

[anukagni]

Hi,

Using ASP with Ms access by DSN-less connection ..thats wat iam here from lotz of my cricle ..but the sad thing :(is iam not able to understand what they are saying please explain me wat is DSN connection and DSNless Connection..


anukagni

[sashi]

Hi,

Using ASP with Ms access by DSN-less connection ..thats wat iam here from lotz of my cricle ..but the sad thing :(is iam not able to understand what they are saying please explain me wat is DSN connection and DSNless Connection..


anukagni

Hi there,

Kindly refer to below attached link for further reading & understanding, hope it helps. Good luck & Take care.

DSN vs DSN less Database Connections

[subashini Thiyagarajan]

DSN -Data Source Name

It is very simple the Name DSN holds the database location (physical path ) and the driver name in the centralized location.u can call it with the name(DSN name) in your codings.

DSN-less means u need to mention the driver name and database path physically.


3 types of DSN there

user DSN system DSN and file DSN

control panel--administrative tool---datasouces (ODBC)---u can add your DSN

then



instead of this code (DSN)

connection.Open "DSN=DSNname"

u can write like below (DSN-less)

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

but all the experts prefer DSN-less connection only.because it is fast.
in DSN less object linking and embedding is making it fast.

in DSN ODBC(open database connectivity) involved it is slow to some extent.

Hope u got the view about it..

[anukagni]

Hi,

Thanks ..:)
Feels good enough for me ..
Thanks again

anukagni