Stored Procedure call problem 
Author Message
 Stored Procedure call problem

Hi,
I am trying to execute a SQL  stored procedure with  a
C++ client application that uses ADO to communicate with the database,
specify the procedure name and creating (binding) its related
parameters.

Everything works fine, except  when the stored procedure parameter
data type is TIMESTAMP, the parameter binding is not done and hence the
procedure SQLExecute fails!
It could be a time-formatting error, an ADO or an ODBC/driver error?

The documentation says that the DB2 TIMESTAMP corresponds to the ADO
adDBTimestamp,
but unfortunately NO example is provided in the SQLLIB\samples\ADO\VC.
Does anybody have experience, knowledge or can provide  a C++ example of
ADO  CreateParameter
with parameter type adDBTimestamp and assigning its relative value?

  pParam1 = pCommand->CreateParameter((LPCTSTR) "param_timestamp",
adDBTimestamp, adParamInput, param_length, param_variantValue);

Thank you in advance for any HELP!
Ciao!

Stefania
----------------------------------------------------------------
Stefania Errore
IBM-ROME Tivoli LAB



Sun, 09 May 2004 19:30:47 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. SQL Stored Procedure Call Problem

2. ODBC SQLServer stored procedure call problem

3. Stored Procedure Call Problem

4. Calling Stored Procedure that calls Stored Procedure in ASP

5. Problem with stored procedure that calls other stored procedures

6. Problem compiling stored procedure that calls another stored procedure

7. Calling a Java Stored Procedure from another Java Stored Stored Procedure

8. Called and Calling store procedure problem !!

9. who can help? ODBC stored procedure call problem, Thanks

10. Problem in calling stored procedure stored in UTF-2 codeset DB

11. Stored Procedure calling Stored Procedure

12. Call a stored procedure from another stored procedure


 
Powered by phpBB® Forum Software