hmm try this code i added on my script and worked and be sure that u put thedb.db at script file.
addEventHandler ( "onResourceStart", resourceRoot,
function ( resource )
handler = dbConnect ( "sqlite", "thedb.db" )
if ( handler ) then
outputDebugString ( getResourceName ( resource ) ..": Successfully connected to SQLite database." )
dbExec ( handler, "CREATE TABLE IF NOT EXISTS 'housing' ( id INTEGER PRIMARY KEY, houseName TEXT, houseOwner TEXT, housePrice bigint(255), houseOriginalPrice bigint(255), houseForSale TEXT, housePosition TEXT, houseInterior INT, houseInteriorState TEXT, buyDate TEXT, streamURL TEXT )" )
