False File.exists; flex cannot open SQLite.db file

i have program uses sqlite database. instead of creating , importing database, sqlite databse exists, data.

 

i trying open , read information (select* table - example); nothing seems work.

the error getting is: 'error #3125: unable open database file.', details:'connection closed.', operation:'open', detailid:'1001'. have checked path repeatedly, file exists. run flash builder administrator (win7).

code:

i have moved database file around. in final version of program, database stored in seperate drive on network (z:/database.db, example) need use absolute path; although have tried others (application storage directory, etc)

 

var dbfile:file = new file("c:\users\public\documents\graduates.db");

trace('exists:' + dbfile.exists);

//above being important bit.

dbstatement = new sqlstatement();

dbstatement.itemclass = grad;

aludb = new sqlconnection();

dbstatement.sqlconnection = aludb;

aludb.addeventlistener(sqlevent.open, ondatabaseopen);

aludb.addeventlistener(sqlerrorevent.error, errorhandler);

aludb.open(dbfile);//error occurs here, of course.

 

can me figure out why error occuring? or different method of opening file?

More discussions in Flex (Read Only)

adobe