This is also the only directory with write access available. Please be aware that Connect will not provide support for structuring SQL queries in customers scripts. If you are having problems with syntax, we suggest you reference the sample scripts, or look online for help. There are many online resources for clients to use. For information on what the error codes that appear in your browser mean, Always try the Microsoft Knowledge base first.
Many people have trouble understanding the concept of how the server.mappath command works.
DSN Connections are stored in the registry of the web server machine. This results in the connections being somewhat slower. DSN-less connections are portable. DSN-less connections can be modified at ANY time by the webmaster, without needing assistance from the server administrator. In the case of a catastrophic failure on behalf of the web cluster, we cannot guarantee that a DSN would be restored at time of rebuild.