Unable to retrieve/access tables

Etznab · Post by **Etznab** » 18.03.2008, 01:25

Hi,

First thx for this wonderfull componentset.

I am having problems accessing a sqlite 3 db that has been created with sqlite administrator.

Actions i have done:
-Copied all sqlite dll to system32 folder
-Created sqlite 3 db and created some tables
-Started delphi 11 project
-Put zconnection & ztable on the form
-set the location+table name in zconnection.database
-set connected to true in zconnection
-set ztable.connection to zconnection

After all this is done and i try to access the table list in ztable i receive the following error:

Access violation at address 13BF2C18 in module 'ZComponentDesign110.bpl'. Read of address 00000000.

Code: Select all

[13BF2C18]{ZComponentDesign110.bpl} Zpropertyeditor.TZTableNamePropertyEditor.GetValueList + $184 
[13C79D24]{ZDbc110.bpl } Zdbcsqliteutils.CheckSQLiteError + $F8 
[13C7B9AF]{ZDbc110.bpl } Zdbcsqlitestatement.TZSQLiteStatement.ExecuteQuery + $77 
[13C7EF4B]{ZDbc110.bpl } Zdbcsqlite.TZSQLiteConnection.CreateRegularStatement + $47 
[13C7CE50]{ZDbc110.bpl } Zdbcsqlitemetadata.TZSQLiteDatabaseMetadata.GetTables + $14C 
[13BF2BD9]{ZComponentDesign110.bpl} Zpropertyeditor.TZTableNamePropertyEditor.GetValueList + $145 
[13BF2936]{ZComponentDesign110.bpl} Zpropertyeditor.TZStringProperty.GetValues + $42 
[20E1098B]{vclide100.bpl} IDEInspListBox.TInspListBox.ListDropDown (Line 1626, "ideinsplistbox.pas" + 9) + $12 
[20E0C080]{vclide100.bpl} IDEListBtns.TListButton.DropDown (Line 670, "IDEListBtns.pas" + 5) + $A 
[20E0BAF2]{vclide100.bpl} IDEListBtns.TListButton.DefaultHandler (Line 491, "IDEListBtns.pas" + 13) + $4 
[20E0BB86]{vclide100.bpl} IDEListBtns.TListButton.WMLButtonDown (Line 524, "IDEListBtns.pas" + 7) + $2 
[20006A3F]{rtl100.bpl  } System.TObject.Dispatch (Line 9284, "sys\system.pas" + 8) + $0 
[2013C527]{vcl100.bpl  } Controls.TControl.WndProc (Line 5146, "Controls.pas" + 83) + $6 
[20140158]{vcl100.bpl  } Controls.TWinControl.IsControlMouseMsg (Line 7176, "Controls.pas" + 9) + $25 
[201406A7]{vcl100.bpl  } Controls.TWinControl.WndProc (Line 7304, "Controls.pas" + 111) + $6 
[2013FDD0]{vcl100.bpl  } Controls.TWinControl.MainWndProc (Line 7073, "Controls.pas" + 3) + $6 
[20040E4C]{rtl100.bpl  } Classes.StdWndProc (Line 11583, "common\Classes.pas" + 8) + $0 
[20163691]{vcl100.bpl  } Forms.TApplication.StopHintTimer (Line 8673, "Forms.pas" + 3) + $6 
[201625E8]{vcl100.bpl  } Forms.TApplication.ProcessMessage (Line 8103, "Forms.pas" + 21) + $1 
[2016262A]{vcl100.bpl  } Forms.TApplication.HandleMessage (Line 8124, "Forms.pas" + 1) + $4 
[2016291F]{vcl100.bpl  } Forms.TApplication.Run (Line 8223, "Forms.pas" + 20) + $3 
[0042297A]{bds.exe     } bds.bds (Line 195, "" + 7) + $7

Using:
Delphi 2007 Update3 + December 2007 Update
ZeosLib svn rev 348.

Note:
At installing zeoslib i get plenty of warnings, however i have no problems connection with mysql.

Is this a bug i should report or some stupid error from my side?
Any help is welcome.

Edit: forgot to ad a polite hi

Post by **mdaems** » 22.03.2008, 12:33

Hi Etznab,

This kind of errors usually means a wrong dll is loaded. Check using the microsoft Filemon program (or something similar) which dll is loaded by Delphi when you are doing the actions you describe above.

Mark

Etznab · Post by **Etznab** » 26.03.2008, 14:33

thx for the response.

Had some other problems that took priority and now returned to this problem.

Filemon shows the correct sqlite3/sqlite.dll is loaded (only 3 present on system, in system32, in zeoslib svn, in sqliteadmin folder).

Also tried the following:
-Placing the sqliteadmin supplied dll's in system32 folder
-Dowloaded sqlitedll-3_5_7 and placed dll in system32 folder

Tried making and connecting to sqlite 2 and 3 db's all with similar result;
-ZConnection will connect.
-Other Zeoslib are unable to retrieve any data from connection resulting in previous Access Viloation.

Are there other actions i can should take to tackle this problem?
For example:
I Could post the project and a filemon log (include bsd.exe only).

Etznab.

Note: i am a novice at advanced debugging so i hope i tracked the correct dll with filemon.
Also found that sqlitedll-3_5_7 depends on MSVCRT.DLL. After a system search i found multiple version of MSVCRT.DLL. Maybe that is the source of the problem although i did not notice it being loaded in filemon.

Edit:

A reply from any1 who has no problem using sqlite + delphi11 is appreciated, then i at least know the problem is somewhere on my system.

Etznab · Post by **Etznab** » 05.04.2008, 11:32

Fixed (problem located),

Problem:
Databases(sqlite 2 & 3) created with SQLite Administrator (0.8.3.2) are only accessible with the use of SQLite Administrator (0.8.3.2).

Recieved errors:
*Zeoslib Errors;
-Access violation at address 13BF2C18 in module 'ZComponentDesign110.bpl'. Read of address 00000000.
-SQL Error : file is encrypted or is not a database
*SQLite Database Browser;
-An Error occored: File is not a SQLite 3 Database

Created new db(sqlite 3) with SQLite Database Browser this database is readable and editable with:
-SQLite Database Browser
-SQLite Administrator (0.8.3.2)
-ZeosLib

Will post a bug report at SQLite Administrator section

Etznab