Microsoft JET Database Engine (0x80040E14)

[KleberSP]

Microsoft JET Database Engine (0x80040E14)

Erro de sintaxe na instrução INSERT INTO.

/asp/intranet/clientedal.asp, line 11

a line 11 é objConexao.execute(sql_ins)

Dim sql_ins

sql_ins = "INSERT INTO ir (nome_cli, end_cli, cep_cli, cid_cli, est_cli, rg_cli, cpf_cli, telr_cli, telco_cli, telce_cli, data_cli, email_cli, indicacao, vara, proc, recla, dirpf, situacao_atual, prox_passo, concluido) VALUES ('"& Inome & "', '" & Iender & "', '" & Icep & "', '" & Icid & "', '" & Iest & "', '" & Irg & "', '" & Icpf & "', '" & Itelr & "', '" & Itelco & "', '" & Itelce & "', '" & Idata& "', '" & Iemail& "', '" & Iindi & "', '" & Ivara & "', '" & Iproc & "', '" & Irecl & "', '" & Idir & "', '" & Isit & "', '" & Iproxp & "', '" & Iconc & "')"

Call AbrirConexao()

objConexao.execute(sql_ins)

Call FecharConexao()

end Sub

agradeço desde já a atenção

[webdeveloper]

Faça isso:

Dim sql_ins
sql_ins = "INSERT INTO ir (nome_cli, end_cli, cep_cli, cid_cli, est_cli, rg_cli, cpf_cli, telr_cli, telco_cli, telce_cli, data_cli, email_cli, indicacao, vara, proc, recla, dirpf, situacao_atual, prox_passo, concluido) VALUES ('"& Inome & "', '" & Iender & "', '" & Icep & "', '" & Icid & "', '" & Iest & "', '" & Irg & "', '" & Icpf & "', '" & Itelr & "', '" & Itelco & "', '" & Itelce & "', '" & Idata& "', '" & Iemail& "', '" & Iindi & "', '" & Ivara & "', '" & Iproc & "', '" & Irecl & "', '" & Idir & "', '" & Isit & "', '" & Iproxp & "', '" & Iconc & "')"

Response.Write sql_ins
Response.End

Call AbrirConexao()
objConexao.execute(sql_ins)
Call FecharConexao()
end Sub

Veja a quey na tela, e verifique se tem algo errado.