Tenho uma tabela no access , um formulario e um arquivo asp para inclusão de dados, mas não estou conseguindo incluir nada. O que está errado? Arquivo ASP (cadastro.asp) <html>
<head>
<title>CADASTRO DE IMOVEL</title>
</head>
<body>
<%
'Declarando variaveis
Dim adoCon, strCon
Dim caminho_banco
Dim objRS
'Definindo o caminho do banco
caminho_banco = Server.MapPath("../databases/dwoigt.mdb")
'Definindo string de conexão
strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & caminho_banco
'Criando objeto
Set adoCon = Server.CreateObject("ADODB.Connection")
'Abrindo conexão
adoCon.Open strCon
'objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open "Select * FROM cadastro_imovel
objRS.AddNew
ObjRS("TIPO")=Request.Form("tipo_imovel")
ObjRS("CIDADE")=Request.Form("cidade_imovel")
ObjRS("ENDERECO")=Request.Form("endereco")
ObjRS("BAIRRO")=Request.Form("bairro")
ObjRS("AREA_CONSTRUIDA")=Request.Form("area_constr")
ObjRS("AREA_TOTAL")=Request.Form("area_total")
ObjRS("DORMITORIOS")=Request.Form("dormitorios")
ObjRS("VALOR")=Request.Form("valor_imovel")
ObjRS("CONTATO")=Request.Form("contato")
ObjRS("END_CONTATO")=Request.Form("endereco_ctt")
ObjRS("BAIRRO_CONTATO")=Request.Form("bairro_ctt")
ObjRS("CEP_CONTATO")=Request.Form("cep_ctt")
ObjRS("CIDADE_CONTATO")=Request.Form("cidade_ctt")
ObjRS("UF_CONTATO")=Request.Form("uf_ctt")
ObjRS("FONE_CONTATO")=Request.Form("telefone_ctt")
ObjRS("EMAIL_CONTATO")=Request.Form("email_ctt")
ObjRS.Update
Response.Write "<B>Registro salvo com sucesso!</B>"
ObjRS.Close
'Fechando concexao
adoCon.Close
Set adoCon = Nothing
%>
<BR><A HREF="cadastro_imovel.htm> retorna a pagina orginal </A>
</body>
</html>
O FORMULARIO
<form name="form1" method="post" action="script/cadastro.asp">
<table width="87%" border="0">
<tr>
<td width="23%" height="24"><font face="Arial, Helvetica, sans-serif" size="1">Cidade
do imóvel</font></td>
<td width="77%" height="20">
<input type="text" name="cidade_imovel" size="50">
</td>
</tr>
<tr>
<td width="23%"><font face="Arial, Helvetica, sans-serif" size="1">Tipo
de imóvel</font></td>
<td width="77%">
<select name="tipo_imovel">
<option>Casa térrea</option>
<option>Sobrado</option>
<option>Apartamento</option>
<option>Ponto Comercial</option>
<option>Galpão</option>
<option>Área</option>
<option>Terreno</option>
<option>Chácara</option>
<option>Sítio</option>
<option>Fazenda</option>
</select>
</td>
</tr>
<tr>
<td width="23%"><font face="Arial, Helvetica, sans-serif" size="1">Endereço</font></td>
<td width="77%">
<input type="text" name="endereco" size="50">
</td>
</tr>
<tr>
<td width="23%"><font face="Arial, Helvetica, sans-serif" size="1">Bairro</font></td>
<td width="77%">
<input type="text" name="bairro">
</td>
</tr>
<tr>
<td width="23%" height="19"><font face="Arial, Helvetica, sans-serif" size="1">Área
Construída </font></td>
<td width="77%" height="19">
<input type="text" name="area_const" size="15">
<font face="Arial, Helvetica, sans-serif" size="1">Área
Total
<input type="text" name="area_total" size="15">
</font></td>
</tr>
<tr>
<td width="23%"><font face="Arial, Helvetica, sans-serif" size="1">Nº
Dormitórios </font></td>
<td width="77%">
<input type="text" name="dormitorios" size="10">
<font face="Arial, Helvetica, sans-serif" size="1"> Valor
do Imóvel
<input type="text" name="valor_imovel">
</font> </td>
</tr>
<tr>
<td width="23%"><font face="Arial, Helvetica, sans-serif" size="1">Contato
(Nome) </font></td>
<td width="77%">
<input type="text" name="contato" size="50">
</td>
</tr>
<tr>
<td width="23%"><font face="Arial, Helvetica, sans-serif" size="1">Endereço
</font></td>
<td width="77%">
<input type="text" name="endereco_ctt" size="50">
</td>
</tr>
<tr>
<td width="23%"><font face="Arial, Helvetica, sans-serif" size="1">Bairro</font></td>
<td width="77%">
<input type="text" name="bairro_ctt">
<font face="Arial, Helvetica, sans-serif" size="1">CEP</font>
<input type="text" name="cep_ctt" size="15">
</td>
</tr>
<tr>
<td width="23%"><font face="Arial, Helvetica, sans-serif" size="1">Cidade</font></td>
<td width="77%">
<input type="text" name="cidade_ctt">
<font face="Arial, Helvetica, sans-serif" size="1">UF
<select name="uf_ctt">
<option>AC</option>
<option>AL</option>
<option>AM</option>
<option>AP</option>
<option>BA</option>
<option>CE</option>
<option>DF</option>
<option>ES</option>
<option>GO</option>
<option>MA</option>
<option>MG</option>
<option>MS</option>
<option>MT</option>
<option>PA</option>
<option>PB</option>
<option>PE</option>
<option>PI</option>
<option>PR</option>
<option>RJ</option>
<option>RO</option>
<option>RN</option>
<option>RR</option>
<option>RS</option>
<option>SC</option>
<option>SE</option>
<option>SP</option>
<option>TO</option>
</select>
</font> </td>
</tr>
<tr>
<td width="23%"><font face="Arial, Helvetica, sans-serif" size="1">Telefone</font></td>
<td width="77%">
<input type="text" name="telefone_ctt">
</td>
</tr>
<tr>
<td width="23%"><font face="Arial, Helvetica, sans-serif" size="1">E-mail</font></td>
<td width="77%">
<input type="text" name="email_ctt" size="45">
</td>
</tr>
<tr>
<td width="23%"><font face="Arial, Helvetica, sans-serif" size="1"></font></td>
<td width="77%"> </td>
</tr>
<tr>
<td width="23%"><font face="Arial, Helvetica, sans-serif" size="1"></font></td>
<td width="77%">
<input type="submit" name="Submit" value="CADASTRAR">
<input type="reset" name="Submit2" value="LIMPAR">
</td>
</tr>
</table>
</form> Utilize CODE para identificar seu código Desde já obrigado Paulo