469,903 Members | 1,991 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,903 developers. It's quick & easy.

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
Dec 18 '06 #1
3 1481
sashi
1,754 Expert 1GB
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
Dec 18 '06 #2
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)

Expand|Select|Wrap|Line Numbers
  1. connection.Open "DSN=DSNname"
u can write like below (DSN-less)



Expand|Select|Wrap|Line Numbers
  1. connection.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data" & _
  2.         "Source=c:\inetpub\......\database.mdb"
  3.  
  4.  


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..
Dec 19 '06 #3
Hi,

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

anukagni
Dec 19 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

63 posts views Thread by Jerome | last post: by
13 posts views Thread by Simon Bailey | last post: by
reply views Thread by Frederick Noronha \(FN\) | last post: by
64 posts views Thread by John | last post: by
17 posts views Thread by Mell via AccessMonster.com | last post: by
37 posts views Thread by jasmith | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.