[thelist] DSN x DSN-less

[David at softv.net]

DSN-less will be faster if you plan on using the native OLEDB provider
(if there is one for your particular DB) for connection. DSNs use
ODBC, which is an extra layer of acces to get thru to the database,
where as OLEDB provides a direct layer to the database engine. 
There should be no security risks involved using DSN-less because you
will have secured your db at the database level instead of relying on
your ODBC layer to check for permissions.

<%
David Mitchell
Web Developer
david at sofTV.net
sofTV.net
www.sofTV.net
613.729.6400 x268
%>
www.IceRadio.ca
"Canada's Best Music on the Web"


-----Original Message-----
From: Faye Tarzwell(FayeC) [mailto:fayec at canada.com]
Sent: Monday, October 29, 2001 10:47 AM
To: Evolt
Subject: [thelist] DSN x DSN-less


Hi,

I am looking for opinions from the gurus on the list about the pros
and
cons of DSN and DSN-less connections...
Sometime ago I read someone's posting saying a DSN-less connection was
faster but then wouldn't security be more important in this case?
My teacher says we should never put a db online without a DSN
connection
because the database is too vulnerable....
I would love to hear what you guys have to say about it.
Thank you for all your comments and tips.

-- 
Flavia Tarzwell (FayeC)
Web Designer/Developer
http://www.fayec.com

<tip>
If you have DW and DWU installed on your computer DWU will be the
default when installing extensions.
To be able to use those extensions on DW as well you will need to
import
them into DW. You can do that on the Extension manager. Just go back
to
the DW extensions and go to File/import select DWU and then select the
extensions you want to import from it. 
</tip>


---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !