Lazarus + Sqlite := 'SQLITE_NOTADB'

[Lathspell]

Hi everybody!
Following a guide posted by an user in theese days, I have installed the TSQLITE2DATASET component and create some tables with it, so I put this component and the TDATASOURCE on my main form.
Then I have linked the TDatasource to the Dataset with its "DataSet" property and put two TDBEdit in the form linking them to the TDataSource.
Then I try two ways:

1st: Set the "Active" property of the TSqlite3Dataset on TRUE
2nd: Use this code:

Code: [Select]


{ dbMain is the TSqlite3Dataset name }
dbMain.TableName := 'clienti';
dbMain.SQL := 'Select * from clienti';
dbMain.Open;


In both cases, lazarus return an error:

dbMain: Error returned by sqlite while retrieving data: SQLITE_NOTADB


What I have to do?
(I apologize for my awful english)

[LuizAmérico]

Do you set FileName to the datafile path?
How do you created the datafile?
The datafile is from sqlite2 or sqlite3 ?

The error means that sqlite does not recognizes the datafile (FileName) as a valid sqlite3 database.