hi
i download the last version of aspmap 4.8.3, every thing goes ok,but suddenly i face this problem ora-01000:maximun open cursors exceeded at this line:
Layer layer = map.addLayer(oracleLayer);
i increase the open_cursor of oracle database,but also i face same problem.
how can i solve this problem,because i plan to update my current aspmap version to aspmap 4.8.3.
thanks
maher
Please let us know the type of Oracle provider you are using (.NET built-in or the provider for Oracle) and send us the code of your project(.aspx.cs/vb) as a support ticket at http://vdstech.com/ccp.aspx
i ma using provider for Oracle
Oracle Data Access Components (ODAC) for Windows
using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using AspMap; using AspMap.Web; using AspMap.Data; using System.Drawing; using Oracle.DataAccess.Client; using Microsoft.ApplicationBlocks.Data; using System.Data.OleDb; using System.Drawing.Imaging; using System.IO; using ExifLib; using System.Drawing;
protected void getLayers() {
String connectionString = OraHelper.DbConnectionStatic(); String tableName = "ALL_PLACES"; String providerName = "Oracle.DataAccess.Client";
OracleLayer oracleLayer ;
tableName = "ALL_PLACES";
oracleLayer = new OracleLayer(providerName, connectionString, tableName, "GEOM"); oracleLayer.FieldList = "PLACE_NAME, PLACE_NO, LAYER_CODE";
Layer layer = map.AddLayer(oracleLayer);
// layer.EnablePassthroughQuery = true; layer.Name = "POINTS"; layer.LabelField = "PLACE_NAME";
}