How to pass Date as in parameter for stored proc

[Naresh_Surya]

I tried below code

// Adding a return parameter
SProc.Parameters.AddParameter()
SProc.Parameters.Items(0).name = "RETURN_VALUE"
SProc.Parameters.Items(0).DataType = adInteger
SProc.Parameters.Items(0).Direction = adParamReturnValue
SProc.Parameters.Items(0).Value = null

//Adding an in parameter
SProc.Parameters.AddParameter()
SProc.Parameters.Items(1).name = "@timeOfBuild"
SProc.Parameters.Items(1).DataType = adDBDateTime  // what should we pass here I tried adDBTime and adDBTimeStamp also
SProc.Parameters.Items(1).Value = "2020-05-19"
SProc.CommandTimeout = 120;
SProc.ExecProc();

Can someone please help me here? I am getting adDBDateTime is not defined. Thanks in advance

[Wamboo]

Hi,

Try to check this article

https://support.smartbear.com/viewarticle/65800/

maybe this will help You.

[Naresh_Surya]

Hi Thanks for that link. I have tried two TestComplete ADO constants for Date/DateTime mentioned but i am running into below issues

Tried adDate as Datatype but got into "application uses a value of the wrong type for the current operation" issue.

Tried adDBTimeStamp but got into "arguments are of the wrong type, are out of acceptable range, or are in conflict with one another"

Can you confirm if it's because I am passing date in String format? If so, how can we pass the same?

[Wamboo]

If I understand you correctly. You're trying to run a procedure that already exists in the database, right?

If so... You must pass a parameter with the correct dataType.

Connect to the database and check the type of value in the column you're looking for.

[Naresh_Surya]

@Wamboo , Thanks for your reply. Yes, I am trying to execute a Stored proc which is available in DB.

I checked the parameter DataType in DB and is "datetime"

As mentioned in below screenshot I tried those two TestComplete constants but I was getting the errors mentioned in my previous comment.

Am I missing anything here?

[Wamboo]

What database are You using?

[Naresh_Surya]

Microsoft SQL Server

[Wamboo · Accepted solution]

Try to run it with this peace of code:

  var sql = 
  `
  // sql or procedure
  `;
  
  var conn = ADO.CreateCommand();
  conn.ActiveConnection = connectionString;
  conn.CommandType = adCmdText;
  conn.CommandText = sql;
  conn.CommandTimeout = 6000;
  
  try {
    var exe = conn.Execute();
  } catch(exception) {
    Log.Message("FAIL");
  }

[Naresh_Surya]

Sorry, I am new to dealing with stored procs. 

I assigned  stored proc path to sql.

ActiveConnection = Connection String(includes catalog, username/password)

I didn't understand what to place at adCmdText. 

[Naresh_Surya]

I've seen we can execute stored proc using Query and tried executing SQL query 

EXEC <stored proc name> @date=N'date'; 

It returned query timedout wrror as my stored proc takes more than 30 secs (close to one minute to get executed). Is there any way to mention querytimeout as we do commandtimeout in stored proc?