Throwing error on the DB table
Hi, Can someone suggest why testcomplete is throwing error on my table name statement (aCmd.CommandText = "account_name") as "Invalid object name".
It appears to connect to DB fine as aCon.State is returning as 1. Not sure why it isn't accepting the table name.
  aCon = ADO.CreateConnection();
  // Sets up the connection parameters
  aCon.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=XXXXXXX;Data Source=XXXX";
  // Opens the connection
  aCon.Open();
  Log.Message(aCon.State);
  // Creates a command and specifies its parameters
  aCmd = ADO.CreateCommand();
  aCmd.ActiveConnection = aCon; // Connection
  aCmd.CommandType = adCmdTable;
   // Command type
  aCmd.CommandText = "account_name"; // Table name
  // Opens a recordset
  aRecSet = aCmd.Execute();
  aRecSet.MoveFirst();
 }
Hi mcmprashanth -
It looks to me like you need to specify the table name when opening the table connection:
see example here:
https://support.smartbear.com/testcomplete/docs/reference/program-objects/ado/createadotable.html
Let me know if you have further questions.
Emma