Hi,
My problem is simple to see but I dont know
why I cant solve it (with others' help obviously !)
 till his moment. One reason
may be that I could not be able to make others
understand what exactly the problem was.
Anyway I'm trying to do that once again for u.
Pl help me. & pl forgive me if this question comes out
to be a silly one because I'm a hobbyist - who is
trying to be a programer & quite a new-bee
in this line !!!  ^_^.
ThnksAlot(for patiently reading this...) :)
love all -
Probal Roy (from India)
probroy1@h...
ICQ: 37075206
-------------------------------------------
 Q:>  We know that, to access *.mdb (MS
Access ) database from a program's context
it is required to 'set' system DSN . Now when
ASP is used as 'Front End' interface it is always
NOT required to do that. & that is called
DSN-LESS connection.
I came to know 'bout this from a page at the
following website:-
www.powerasp.com
Now let me quote a few words from this page :

======================================
"ACCESS DATABASES
( DSN vs DSN-LESS )

If you are using an ACCESS Database try
to avoid using a system DSN. They are
very slow because they go through ODBC
which then uses the Jet Drivers to access
the database.

When you use a DSN-LESS connection
with ASP theJet Drivers are accessed
directly and the performance increase
can be dramatic especially with the
newer versions of MDAC installed on
the server  which are especially slow
with Access System DSN's.
.......

If you hang out in the newsgroups  you
will hear this.

Don't use DSN-LESS connections

My theory is all those people have
used System DSN's so long that they
just tell people to use them and don't
really have a good reason or explanation
why.
........


Basic DNS-LESS connection example:
DataConn.Open "DBQ=" & Server.Mappath("../_database/database.mdb") &
";Driver={Microsoft Access Driver (*.mdb)};"

This is the other way to do it that should be even better in theory. In my
testing I notice a little performance difference (very little). BTW...

Accessing the Jet Driver directly connection example for Access 97:

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

Here is an example with Access 2000

DataConn.Open "Data Source=" & Server.Mappath("../_database/database.mdb") &
";Provider=Microsoft.Jet.OLEDB.4.0;"
===========================
Info 'bout DSN-LESS connection
can be found in the following site also:-
www.4guysfromrolla.com

 Now my actual Question is ( s are ) :-
1. Is it possible to make use of DSN-LESS
    connection in JSP ?
2. If 'yes' then how ?
3. & WHY we are NOT interested to make use
    of it ?

& that's all ...