title: inserting datetime in oledb through vb.net , query gives error
body: <p>My DBStructure is as follows:</p>
  
  <p><img src="https://i.stack.imgur.com/1Kqax.png" alt="enter image description here"></p>
  
  <p>I want to insert a record in it, so i am firing following query:</p>
  
  <pre><code>insert into LocalBarcode (PescaLocation,Barcode,TimeStamp,IsUpload)values('1','11','10/17/2013 
  
  6:08:57 PM') 
  </code></pre>
  
  <p>But its giving me syntax error: as </p>
  
  <p>Syntax Error in Insert into.</p>
  
  <p>For IsUpload, i have kept default value to 'N', hence i am not sending it from here.</p>
  
  <p>LBID is autoincreament.</p>
  
  <p>Please help.</p>
  
  <p><strong>VB.NET query:</strong></p>
  
  <pre><code>Dim sqlInsertBarcode = "insert into LocalBarcode 
  
  (PescaLocation,Barcode,TimeStamp,IsUpload)values('" &amp; pescaLocation &amp; "','" &amp; 
  
  txtBarcode.Text.Trim.Replace("'", "''") &amp; "','" &amp; Now() &amp; "') "
  </code></pre>