SQL state 37000 in SQLExecDirect
Posted: Sun Jan 16, 2011 4:56 am
Hi i am new to odbc so please help me to solve this problem. when i run the code i always get this error: SQL state 37000 in SQLExecDirect
Code: Select all
<html>
<head>
<title>Application</title>
</head>
<body>
<?php
$objConnect = odbc_connect("Coop","","") or die("Error Connect to Database");
$strSQL = "INSERT INTO Applicant ";
$strSQL .="(CustomerID,FirstName,LastName,Gender,DateOFBirth,Nationality,E-mailAddress,MobilePhone,Region,EmploymentStatus,AccountStatus,GrossAnnualIncome,LoanRequsted,TermRequsited,DateCreated) ";
$strSQL .="VALUES ";
$strSQL .="('".$_POST["txtCustomerID"]."','".$_POST["txtFirstName"]."','".$_POST["txtLastName"]."' ";
$strSQL .=",'".$_POST["txtGender"]."','".$_POST["txtDate"]."','".$_POST["txtNationality"]."' ";
$strSQL .=",'".$_POST["txtMail"]."','".$_POST["txtMobile"]."','".$_POST["txtRegion"]."' ";
$strSQL .=",'".$_POST["txtEmployementStatus"]."','".$_POST["txtAccountStatus"]."','".$_POST["txtIncome"]."' ";
$strSQL .=",'".$_POST["txtLoan"]."','".$_POST["txtTermRequested"]."','".$_POST["txtDateC"]."') ";
$objExec = odbc_exec($objConnect, $strSQL);
if($objExec)
{
echo "Your Application has been sent";
}
else
{
echo "Error Save [".$strSQL."]";
}
odbc_close($objConnect);
?>
</body>
</html>