<p>I have a couple of questions regarding VBScript and ASP Classic:</p>

<ol>
<li><p>What is the preferred way to access an MS SQL Server database in VBScript/ASP?</p></li>
<li><p>What are best practices in regards to separating model from view from controller?</p></li>
<li><p>Any other things I should know about either VBScript or ASP?</p></li>
</ol>

<p>If you haven't noticed, I'm new at VBScript coding.  I realize numbers 2 &amp; 3 are kind of giant "black hole" questions that are overly general, so don't think that I'm expecting to learn everything there is to know about those two questions from here.</p>

ADO is an excellent way to access a database in VBScript/Classic ASP.
```
```
Dim db: Set db = Server.CreateObject("ADODB.Connection")
db.Open "yourconnectionstring -> see connectionstrings.com"
Dim rs: Set rs = db.Execute("SELECT firstName from Employees")
While Not rs.EOF
    Response.Write rs("firstName")
    rs.MoveNext
Wend
rs.Close
```
```
More info here:
http://www.technowledgebase.com/2007/06/12/vbscript-how-to-create-an-ado-connection-and-run-a-query/
One caveat is that if you are returning a MEMO field in a recordset, be sure you only select ONE MEMO field at a time, and make sure it is the LAST column in your query.  Otherwise you will run into problems.
(Reference:
http://lists.evolt.org/archive/Week-of-Mon-20040329/157305.html
)