60 pts.
 for AS/400 V5R2
HI THIS IS BHAVESH I AM GETTING ERROR WHILE EXECUTING RDO PREPARED STATEMENT THROUGH VB6 ODBC CONECTIVITY ON AS/400 SERVER PL. NOTE THAT IT IS WHEN I HAVE CHANGED MY SERVER BOX FROM V4R5 TO V5R2 MODEL STRING FOR PREPARED STATEMENT I AM USING AS FOLLOWS Public SosRdoEnv As rdoEnvironment Public SosRdoCon As rdoConnection Public SosPrpStmt1 As rdoPreparedStatement Public SosResultset1 As rdoResultset Public MjobNo As String Public MjobName As String Set SosRdoEnv = rdoEngine.rdoCreateEnvironment("", "", "") SQuery = "DSN=TIMRDO;UID=ASHIMA;PWD=ASHIMA;" On Error GoTo ErrorHandler Set SosRdoCon = SosRdoEnv.OpenConnection("", rdDriverNoPrompt, False, SQuery) SosRdoCon.QueryTimeout = 3600 SQuery = "CALL REPLIB.REPSTOR(?,?)" Set SosPrpStmt1 = SosRdoCon.CreatePreparedStatement("", SQuery) SosPrpStmt1(0).Value = "" SosPrpStmt1(1).Value = "" SosPrpStmt1(0).Direction = rdParamInputOutput SosPrpStmt1(1).Direction = rdParamInputOutput SosPrpStmt1.Execute MjobNo = SosPrpStmt1(0).Value MjobName = SosPrpStmt1(1).Value ERROR IS INTERNAL DRIVER ERROR

Software/Hardware used:
ASKED: January 18, 2008  11:42 AM
UPDATED: October 30, 2009  1:02 AM

Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

Any chance you could tell us what driver was being used?

Tom

 107,695 pts.