Page 1 of 1

SQL state 37000 in SQLExecDirect

Posted: Sun Jan 16, 2011 4:56 am
by Asbali
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>