Please use DSN-less, using a DNS not only adds a 20% or so increase in load times, but also has an additional point of failure and problems in the ODBC layer,and then in the application pool
Also, please do not use the ODBC driver. Use a DSN-less JET OLEDB connection. Access ODBC is problem ridden and is no longer supported by MS
[QUOTE=Yash]
Also, please do not use the ODBC driver. Use a DSN-less JET OLEDB connection. Access ODBC is problem ridden and is no longer supported by MS
[/QUOTE]
Is this something specific to Access, or across the board? Inquiring minds want to know.
Directly using JET is always best, but SQL has other methods like a built in library for accessing SQL, so basically, just Access+ASP.
Read this for more: http://support.jodohost.com/showthread.php?t=3146