ERROR [42S02] [Elevate Software][DBISAM] DBISAM Engine Error # 11010 Table or backup file
'Article' does not exist
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 [42S02] [Elevate
Software][DBISAM] DBISAM Engine Error # 11010 Table or backup file 'Article' does not exist

Source Error:


Line 57:
Line 58:    MyCommand.CommandText := 'SELECT * FROM Article' ;
Line 59:    MyDataReader := MyCommand.ExecuteReader();
Line 60:    while MyDataReader.Read() do
Line 61:    begin


Source File: c:\inetpub\wwwroot\KGBWeb\WebForm1.pas    Line: 59

Stack Trace:


[OdbcException: ERROR [42S02] [Elevate Software][DBISAM] DBISAM Engine Error # 11010 Table
or backup file 'Article' does not exist]
  System.Data.Odbc.OdbcConnection.HandleError(HandleRef hrHandle, SQL_HANDLE hType,
RETCODE retcode)
  System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method)
  System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
  System.Data.Odbc.OdbcCommand.ExecuteReader()
  WebForm1.TWebForm1.Page_Load(Object sender, EventArgs e) in
c:\inetpub\wwwroot\KGBWeb\WebForm1.pas:59
  System.Web.UI.Control.OnLoad(EventArgs e)
  System.Web.UI.Control.LoadRecursive()
  System.Web.UI.Page.ProcessRequestMain()

Hi Viet,

What version of DBISAM?
What is your connection string?
I assume that the file 'Article' exists at the path specified.
Do you have user permissions to access this file (as a web user)?

Chris Holland


Viet wrote:
> ERROR [42S02] [Elevate Software][DBISAM] DBISAM Engine Error # 11010 Table or backup file
> 'Article' does not exist
> 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 [42S02] [Elevate
> Software][DBISAM] DBISAM Engine Error # 11010 Table or backup file 'Article' does not exist
>
> Source Error:
>
>
> Line 57:
> Line 58:    MyCommand.CommandText := 'SELECT * FROM Article' ;
> Line 59:    MyDataReader := MyCommand.ExecuteReader();
> Line 60:    while MyDataReader.Read() do
> Line 61:    begin
>  
>
> Source File: c:\inetpub\wwwroot\KGBWeb\WebForm1.pas    Line: 59
>
> Stack Trace:
>
>
> [OdbcException: ERROR [42S02] [Elevate Software][DBISAM] DBISAM Engine Error # 11010 Table
> or backup file 'Article' does not exist]
>    System.Data.Odbc.OdbcConnection.HandleError(HandleRef hrHandle, SQL_HANDLE hType,
> RETCODE retcode)
>    System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method)
>    System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
>    System.Data.Odbc.OdbcCommand.ExecuteReader()
>    WebForm1.TWebForm1.Page_Load(Object sender, EventArgs e) in
> c:\inetpub\wwwroot\KGBWeb\WebForm1.pas:59
>    System.Web.UI.Control.OnLoad(EventArgs e)
>    System.Web.UI.Control.LoadRecursive()
>    System.Web.UI.Page.ProcessRequestMain()
>
>  
>

Chris Holland <mail@chrisholland.me.uk> wrote:

Hi Chris Holland,
i used DBISAM 4.19
My connection string : 'DRIVER={DBISAM 4 ODBC
Driver};ConnectionType=Local;'CatalogName=DataTest; '
the file 'Article' exists at the path with DSN: DataTest.
I have user permissions to access this file

Chris Holland

Viet <luongsiviet@yahoo.com> wrote:

Hi Chris Holland,
i used DBISAM 4.19
My connection string : 'DRIVER={DBISAM 4 ODBC
Driver};ConnectionType=Local;'CatalogName=DataTest; '
the file 'Article' exists at the path with DSN: DataTest.
I have user permissions to access this file

Luong Si Viet

Hi,

The 'CatalogName=DataTest' is a direct path connection to a subdirectory called DataTest

To use a DSN connection us 'DSN=DataTest'
(assuming that you have configured the ODBC to contain a DSN called DataTest that points to the relevant path)

Hope this helps

Chris Holland


Viet wrote:
> Viet <luongsiviet@yahoo.com> wrote:
>
> Hi Chris Holland,
> i used DBISAM 4.19
> My connection string : 'DRIVER={DBISAM 4 ODBC
> Driver};ConnectionType=Local;'CatalogName=DataTest; '
> the file 'Article' exists at the path with DSN: DataTest.
> I have user permissions to access this file
>
> Luong Si Viet
>
>

hi,
Thanks a lot for this help, but i receive error because my table with encrypt password,
ERROR [HY000] [Elevate Software][DBISAM] DBISAM Engine Error # 10498 Insufficient rights
to the table 'Article', a password is required.
I create new table without encrypt password, it work fine.
Thanks
Luong SI Viet

Chris Holland <mail@chrisholland.me.uk> wrote:

Hi,

The 'CatalogName=DataTest' is a direct path connection to a subdirectory called DataTest

To use a DSN connection us 'DSN=DataTest'
(assuming that you have configured the ODBC to contain a DSN called DataTest that points
to the relevant path)

Hope this helps

Chris Holland


Viet wrote:
> Viet <luongsiviet@yahoo.com> wrote:
>
> Hi Chris Holland,
> i used DBISAM 4.19
> My connection string : 'DRIVER={DBISAM 4 ODBC
> Driver};ConnectionType=Local;'CatalogName=DataTest; '
> the file 'Article' exists at the path with DSN: DataTest.
> I have user permissions to access this file
>
> Luong Si Viet
>
>

Luong,

<< Thanks a lot for this help, but i receive error because my table with
encrypt password, ERROR [HY000] [Elevate Software][DBISAM] DBISAM Engine
Error # 10498 Insufficient rights to the table 'Article', a password is
required. I create new table without encrypt password, it work fine. >>

You can configure a table password(s) for a data source via the DBISAM ODBC
driver's data source configuration wizard in the ODBC administrator (Control
Panel/Administrative Tools/ODBC Data Sources).  It's the last tab in the
wizard.

--
Tim Young
Elevate Software
www.elevatesoft.com