[thelist] DSN x DSN-less

[Mike Hardaker]

Absolutely - DSN-less is the way to go unless you're using some obscure database
that doesn't have an OLEDB provider.

My own informal benchmarking suggests that it's a lot faster, and there's the
added benefit that many hosting companies charge you extra for each DSN, while
offering limitless DSN-less connections :-)

Mike

---------------------------
Mike Hardaker
Founder & Publisher - AngloINFO
http://www.angloinfo.com

> -----Original Message-----
> From: thelist-admin at lists.evolt.org
> [mailto:thelist-admin at lists.evolt.org]On Behalf Of David at softv.net
> Sent: Monday, October 29, 2001 5:11 PM
> To: thelist at lists.evolt.org
> Subject: RE: [thelist] DSN x DSN-less
>
>
> 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.