I Open a New Graphical Project

Project Directory : /home/allanb/Documents/Gambas/Test_db

I set Components
     gb.db2
     gb.db2.form
     gb.dbs.sqlite3
     gb.settings (will use later)

I copy a file Test.sqlite to Project Directory

I Place a DataSource1 Component on FMain.form

I create New Connection under Connections under Project
I accept Name: Connection1
I set Type: SQLite
I set Path: /home/allanb/Documents/Gambas/Test_db (clicked on …  navigated to )
I click on Database ::
    It finds my test.sq lite file I select it

I click on Display metadata and Remember database structure

Click on Ok
Establishes connection I can see 2 tables with data
I connect DataSourse1 Connection to: Connection 1
Screen Print at this stage

(Click to enlarge)

I Click on Run Button

New Screen Print

(Click to enlarge)

If i copy test.sqlite file to: /home/allanb

All works

ANY IDEAS ???