Posted on: 12/9/2014 5:22:38 PM | Views : 455

I have code:
            iSQL = "insert into session  (date,start_time,end_time,fid,cid,location,notes) values ('"             iSQL = iSQL & txBoxDate.Text & "','" & txBoxStartTime.Text & "','" & txBoxEndTime.Text & "'," & txBoxFid.Text & "," & _                     txBoxCid.Text & ",'" & txBoxLocation.Text & "','" & notes & "')"

data type for date is date, start_time is time(7) for both sql express and sql server.  It runs fine with sqlexpress, but sql server gives error "Conversion failed when converting date and/or time from character string.&q ...

Go to the complete details ...