I can't connect to the DB... The error seems to be with this line: adoCon.Execute(newSQL), as I tried commenting it out and then Response.Write(newSQL) printed out the statement to the browser.

Can someone help me please.....really want to get beyond this,
Thanks *


Code:
<body>
<!-- #INCLUDE FILE="Connect2DB.asp" -->

<%
Dim newSQL, rst

Dim varTitle, varFirstName, varMInitial, varSurname, varAddress1, varAddress2, varTownCity, varCounty
Dim varEmail, varHCode, varHNo, varWCode, varWNo, varMCode, varMNo, varConNo, varMobNotify, dobDay 
Dim dobMonth, dobYear, marStat, varPwd, DOB

varTitle = request.form("Title1") 
varFirstName = request.form("txtFirstName")
varMInitial = request.form("txtMInitial") 
varSurname = request.form("txtSurname") 
varAddress1 = request.form("txtAddress1")
varAddress2 = request.form("txtAddress2")
varTownCity = request.form("txtTownCity")
varCounty = request.form("sltCounty") 
varEmail = request.form("txtEmail") 
varHCode = request.form("txtHomeCode") 
varHNo = request.form("txtHomeNumber")
varWCode = request.Form("txtWorkCode")
varWNo = request.Form("txtWorkNumber")
varMCode= Request.Form("sltMobileCode")  
varMNo= Request.Form("txtMobileNumber")
varConNo = Request.Form("sltContactNo")  
varMobNotify= True
dobDay = Request.Form("sltDay")
dobMonth = Request.Form("sltMonth")
dobYear = Request.Form("sltYear")
marStat = Request.Form("sltMarStatus") 
varPwd = request.form("txtPwd")
DOB = dobDay & "/" & dobMonth & "/" & dobYear


newSQL = "INSERT INTO MEMBER (TITLE, FIRST_NAME, M_INITIAL, SURNAME, ADDRESS1, ADDRESS2, TOWNCITY, COUNTY, EMAIL_ADDRESS, HOME_AREA_CODE, HOME_NUMBER, WORK_AREA_CODE, WORK_NUMBER, MOBILE_CODE, MOBILE_NUMBER, PREFERRED_CONTACT_NUMBER, MOBILE_NOTIFICATION, DATE_OF_BIRTH, MARITAL_STATUS, PASSWORD) VALUES ('" & varTitle & "' , '"  & varFirstName & "' , '"  & varMInitial & "' ,'"  & varSurname & "', '"  & varAddress1 & "', '"  & varAddress2 & "', '"  & varTownCity & "', '"  & varCounty & "', '"  & varEmail & "', '"  & varHCode & "', '"  & varHNo & "', '"  & varWCode & "', '"  & varWNo & "', '"  & varMCode & "', '"  & varMNo & "', '"  & varConNo & "', '"  & varMobNotify & "',  '" & DOB & "', '"  & marStat & "', '"  & varPwd & "')"


adoCon.Execute(newSQL)

adoCon.Close
 %>
</body>