I have been using Oracle as Back-end to my VB Project..During a database insertion routine when I try to insert a VB date field into the Oracle Database I get the following error :

"Runtime Error '-2147467259(80004005)'

[Oracle][ODBC][Ora]ORA-00932:Inconsistent Datatypes


The SQL query string executed is given below :

strQry = "insert into TAS_EMPLOYEE values ('" & ecode & "','" & ename & "','" & des & "','" & gid & "','" & sex & "','" & dob & "' ,'" & doj & " ','" & email & "'," & phone & ")"

dob and doj are date fields...

can somebody help..

VR.