|
| 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
|
|
|
|
|
|
|
|
|
|