Groups > DB2 > DB2 on AS400 server > Re: SQL066 with .NET Provider




SQL066 with .NET Provider

SQL066 with .NET Provider
Wed, 30 Jan 2008 16:24:43 EST
I want to call a stored procedure, but always send me this message when I try to
execute.<br />
<p />
<br />
iConn.ConnectionString = "Data
Source=name_server;UserID=user;Password=pwd;DataCompression=True;ConnectionTimeo
ut= 800;"<br />
<p />
            iConn.Open()<br />
            Dim iCmd As iDB2Command = New iDB2Command(sp, iConn)<br />
            iCmd.CommandType = CommandType.StoredProcedure<br />
            Dim parm As iDB2Parameter<br />
<br />
            parm = iCmd.Parameters.Add("@C_PERIOD",
iDB2DbType.iDB2Integer)<br />
            iCmd.Parameters("@C_PERIOD").Direction =
ParameterDirection.Input<br />
            iCmd.Parameters("@C_PERIOD").Value = 10<br />
<br />
            parm = iCmd.Parameters.Add("@C_YEAR",
iDB2DbType.iDB2Integer)<br />
            iCmd.Parameters("@C_YEAR").Direction =
ParameterDirection.Input<br />
            iCmd.Parameters("@C_YEAR").Value = 2007<br />
<br />
            parm = iCmd.Parameters.Add("@C_OPC",
iDB2DbType.iDB2Integer)<br />
            iCmd.Parameters("@C_OPC").Direction =
ParameterDirection.Input<br />
            iCmd.Parameters("@C_OPC").Value = 0<br />
<br />
            iCmd.ExecuteNonQuery()<br />
<br />
Post Reply
Re: SQL066 with .NET Provider
Thu, 31 Jan 2008 10:23:36 EST
Post Reply
Re: SQL066 with .NET Provider
Thu, 31 Jan 2008 13:12:44 EST
I specified de timeout in the string connection, I increse until 3000 but I got
the same error.<br />
<br />
I   increse the storage limit of my user with XCHGUSRPRF with property MAXSTG
*NOMAX. But it doesn't work.<br />
<br />
I don't know what can I do.<br />
<br />
Post Reply
Re: SQL066 with .NET Provider
Thu, 31 Jan 2008 13:50:30 EST
Set the COMMAND timeout, not the CONNECTION timeout:<br />
<br />
Post Reply
Re: SQL066 with .NET Provider
Thu, 31 Jan 2008 19:28:11 EST
Thanks a lot, I was undersrtood other thing.<br />
<br />
Post Reply
about | contact