title: Query Insert failed through VB 6 application
body: <p>I am working on a VB application which will insert data to  5 - 7 tables,out of which  two 
  tables have primary key constraints , while inserting data through my application , insert got failed on those two tables that has primary key , when i am trying to insert the same query using the query analyzer it is getting successfully inserted into those two tables , the username and password used through application and the query analyzer are same ,and i am using
  oledb connection string, rdo for executing the queries in the application.The error which i am getting when the query got failed is very generic and  shows </p>
  
  <pre><code>      "Reason -40002-01000: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated."
  </code></pre>
  
  <p>I got puzzled why i am not able to insert the data through my application.Whether i am missing something or need to have some permissions to access the tables</p>