VBScript only supports the variant type(when dimensioning) and does not need or understand the 'As VariableType' syntax. Just drop off the "..as ADODB.Connection" and that part should be ok. MsgBox cannot/should not be implemented on the server, only client side.

best sites:
http://www.15seconds.com/
http://www.asptoday.com/
http://www.asp101.com/
http://www.learnasp.com/