I can fetch data from DBISAm dtabse but coudn''t update. Please kindly solve this issue


Server Error in '/SentinelCS/UI' Application.
--------------------------------------------------------------------------------

ERROR [HY000] [Elevate Software][DBISAM Database System] DBISAM Engine Error # 11013 Access denied to table 'test'
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in
the code.

Exception Details: System.Data.Odbc.OdbcException: ERROR [HY000] [Elevate Software][DBISAM Database System] DBISAM Engine Error # 11013 Access denied to table 'test'

Source Error:


Line 43:         strCommandText = "insert into test ('name') values ('hai')" '@ 'select distinct * from sysFieldGroups join sysFieldDefs on sysFieldGroups.'Field Group Ref'=sysFieldDefs.'Field
Group' where 'Field Type Ref'=" & CType(lstItem.Text, Integer) & " and 'Field Type'=" & CType(lstItem.Text, Integer) & " and 'Can Enter'=True and sysFieldGroups.Active=True and
sysFieldDefs.Active=True order by 'Order' ,'Field Order'  "
Line 44:         objOdbcCommand.CommandText = strCommandText
Line 45:         Dim i As Integer = objOdbcCommand.ExecuteNonQuery()
Line 46:
Line 47:     End Sub


Source File: c:\inetpub\wwwroot\SentinelCS\UI\Forms\WebForm2.aspx.vb    Line: 45

Stack Trace:


[OdbcException: ERROR [HY000] [Elevate Software][DBISAM Database System] DBISAM Engine Error # 11013 Access denied to table 'test']
  System.Data.Odbc.OdbcConnection.HandleError(HandleRef hrHandle, SQL_HANDLE hType, RETCODE retcode) +32
  System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method) +1189
  System.Data.Odbc.OdbcCommand.ExecuteNonQuery() +152
  UI.WebForm2.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\SentinelCS\UI\Forms\WebForm2.aspx.vb:45
  System.Web.UI.Control.OnLoad(EventArgs e) +67
  System.Web.UI.Control.LoadRecursive() +35
  System.Web.UI.Page.ProcessRequestMain() +731




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573

Hi Suman,

Are you sure that you have write permission to the table (and its directory).


Chris Holland


Suman Sundar wrote:
> I can fetch data from DBISAm dtabse but coudn''t update. Please kindly solve this issue
>
>
> Server Error in '/SentinelCS/UI' Application.
> --------------------------------------------------------------------------------
>
> ERROR [HY000] [Elevate Software][DBISAM Database System] DBISAM Engine Error # 11013 Access denied to table 'test'
> Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in
> the code.
>
> Exception Details: System.Data.Odbc.OdbcException: ERROR [HY000] [Elevate Software][DBISAM Database System] DBISAM Engine Error # 11013 Access denied to table 'test'
>
> Source Error:
>
>
> Line 43:         strCommandText = "insert into test ('name') values ('hai')" '@ 'select distinct * from sysFieldGroups join sysFieldDefs on sysFieldGroups.'Field Group Ref'=sysFieldDefs.'Field
> Group' where 'Field Type Ref'=" & CType(lstItem.Text, Integer) & " and 'Field Type'=" & CType(lstItem.Text, Integer) & " and 'Can Enter'=True and sysFieldGroups.Active=True and
> sysFieldDefs.Active=True order by 'Order' ,'Field Order'  "
> Line 44:         objOdbcCommand.CommandText = strCommandText
> Line 45:         Dim i As Integer = objOdbcCommand.ExecuteNonQuery()
> Line 46:
> Line 47:     End Sub
>  
>
> Source File: c:\inetpub\wwwroot\SentinelCS\UI\Forms\WebForm2.aspx.vb    Line: 45
>
> Stack Trace:
>
>
> [OdbcException: ERROR [HY000] [Elevate Software][DBISAM Database System] DBISAM Engine Error # 11013 Access denied to table 'test']
>    System.Data.Odbc.OdbcConnection.HandleError(HandleRef hrHandle, SQL_HANDLE hType, RETCODE retcode) +32
>    System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method) +1189
>    System.Data.Odbc.OdbcCommand.ExecuteNonQuery() +152
>    UI.WebForm2.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\SentinelCS\UI\Forms\WebForm2.aspx.vb:45
>    System.Web.UI.Control.OnLoad(EventArgs e) +67
>    System.Web.UI.Control.LoadRecursive() +35
>    System.Web.UI.Page.ProcessRequestMain() +731
>
>  
>
>
> --------------------------------------------------------------------------------
> Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
>