Hello...

I have an error "Specified cast not valid" when I try updating a database using SQL line.

the SQL line is:
"UPDATE tblTableName SET fldFieldName='" & String & "' WHERE fldID=" & Integer

it looks like something is killing the connection because with error traping once the error occurs, it never works since.

please help me find the source for the problem.