[puntonet] Error al ejecutar metodo contra Sybase.

Fri, 07 Nov 2008 03:50:14 -0800 

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=utf-8">
<META content="MSHTML 6.00.6000.16587" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Gracias por la respuesta y el chiste. =
Pero la 
conexión es una sola en la manejo en una variable de =
session.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>¿Puede haber otra =
posibilidad?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>Saludos y gracias =
nuevamente.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>Javier.</FONT></DIV>
<BLOCKQUOTE 
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
  <DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
  <DIV 
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B> 
  <A [EMAIL PROTECTED] 
  href="mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</A> </DIV>
  <DIV style="FONT: 10pt arial"><B>To:</B> <A =
[EMAIL PROTECTED] 
  href="mailto:[email protected]";>[email protected]</A> </DIV>
  <DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, November 07, 2008 =
9:38 
  AM</DIV>
  <DIV style="FONT: 10pt arial"><B>Subject:</B> [puntonet] Error al =
ejecutar 
  metodo contra Sybase.</DIV>
  <DIV><BR></DIV>Javier,<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp; En primer =
lugar, te 
  sugerirìa que no ejecutes mètodos "en contra" de nadie =
esperando luego una 
  respuesta favorable.<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp; En segundo lugar, =
cerrà 
  las conexiones a la base de 
  datos.<BR><BR><BR><BR>C.S.<BR><BR><BR><BR><BR><BR>----- Original =
Message 
  -----<BR>From: "Javier Osvaldo =?iso-8859-1?Q?Chércoles?= =
(MUG)" &lt;<A 
  =
href="mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</=
A>&gt;<BR>To: 
  <A href="mailto:[email protected]";>[email protected]</A> &lt;<A 
  href="mailto:[email protected]";>[email protected]</A>&gt;; =
<BR>Subject: 
  RE: [puntonet] Error al ejecutar metodo contra Sybase.<BR>Sent: Fri, =
07 Nov 
  2008 09:26:52 -0300<BR><BR><BR><BR>Gente al&amp;nbsp;cargar una grilla =
se 
  ejecuta por cada paginado un metodo <BR>contra Sybase 10. Se ejecuta =
una, dos, 
  tres, cuatro y a la quinta vez, por <BR>ejemplo, tira el error =
Resource 
  governor for 'prepared <BR>statements' exceeded .<BR>Les paso el =
metodo como 
  para aclarar un poco ms:<BR>&amp;nbsp;<BR>Public <BR>Sub 
  <BR>GetCategorias()<BR><BR>Try<BR><BR><BR>Dim adpt <BR>As 
  <BR>OleDbDataAdapter<BR><BR>Dim<BR>&nbsp;comm As New 
  OleDbCommand<BR>TablaCategorias = New 
  dsSiMaPa.CategoriasDataTable<BR>If<BR>&nbsp;connSiMaPa.State = 
  ConnectionState.Closed 
  Then<BR><BR>connSiMaPa.Open()<BR>End<BR>&nbsp;If<BR>comm.Connection =
= 
  connSiMaPa<BR>comm.CommandType = =
CommandType.Text<BR>comm.CommandText = 
  "SELECT * FROM Categorias ORDER BY <BR>caDescripcion"<BR>adpt = =
<BR>New 
  OleDbDataAdapter(comm)<BR>adpt.Fill(Categorias)<BR>adpt = =
<BR>Nothing<BR>comm 
  = <BR>Nothing<BR><BR>Catch ex1 As 
  OleDbException<BR>Console.Write(ex1.Message)<BR><BR>Catch ex2 As 
  =
Exception<BR>Console.Write(ex2.Message)<BR>End<BR>&nbsp;Try<BR>End<BR>&nb=
sp;Sub<BR>&amp;nbsp;<BR>o 
  en su defecto en este.<BR>&amp;nbsp;<BR><BR>Public Function 
  GetCategoria(<BR>ByVal<BR>&nbsp;icaId As Integer) 
  As<BR>&nbsp;String<BR><BR><BR>Dim<BR>&nbsp;sNombre As 
  String<BR><BR>Dim<BR>&nbsp;comm As New 
  OleDbCommand<BR>Dim<BR>&nbsp;drCategoria As 
  OleDbDataReader<BR>If<BR>&nbsp;connSiMaPa.State = =
ConnectionState.Closed 
  =
Then<BR><BR><BR>connSiMaPa.Open()<BR>End<BR>&nbsp;If<BR>comm.Connection =
= 
  connSiMaPa<BR>comm.CommandType = =
CommandType.Text<BR>comm.CommandText = 
  "SELECT caDescripcion FROM Categorias WHERE caId = " <BR>&amp;amp; 
  icaId.ToString<BR>comm.Prepare()<BR>drCategoria = 
  comm.ExecuteReader<BR>drCategoria.Read()<BR>sNombre = 
  Trim(drCategoria.GetValue(0))<BR>drCategoria.Close()<BR>drCategoria =
= 
  Nothing<BR>comm = <BR>Nothing<BR><BR>Return 
  =
sNombre<BR>End<BR>&nbsp;Function<BR>&amp;nbsp;<BR><BR></BLOCKQUOTE></BODY=
></HTML>

Responder a