Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM ODBC Driver » View Thread |
Messages 1 to 7 of 7 total |
DBISAM Engine Error # 11010 Table or backup file 'Article' does not exist |
Mon, Nov 20 2006 1:07 AM | Permanent Link |
Viet | 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() |
Mon, Nov 20 2006 3:08 AM | Permanent Link |
Chris Holland SEC Solutions Ltd. Team Elevate | 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() > > > |
Mon, Nov 20 2006 4:30 AM | Permanent Link |
Viet | 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 |
Mon, Nov 20 2006 4:37 AM | Permanent Link |
Viet | 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 |
Mon, Nov 20 2006 5:44 AM | Permanent Link |
Chris Holland SEC Solutions Ltd. Team Elevate | 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 > > |
Mon, Nov 20 2006 11:09 AM | Permanent Link |
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 > > |
Mon, Nov 20 2006 4:52 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Monday, April 29, 2024 at 05:23 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |