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 !