 problem opening connection with sql anywhere 10 (palmos) -
08-26-2008
, 03:38 AM
hi
i am completely stuck, maybe someone will be able to tell me what's wrong
i wanted to try my application which currently uses asa9 with sqla10. i created
new version of reference database, from it i created ultralite database for
palm. but when i try to open connection to this database on palm device i always
get error -78 (dynamic memory problem). created palm database works with sybase
central
or is it really so that ultralite10 has much bigger memory requirements then
ultralite9? note that just before i try to open database MemHeapFreeBytes
reported 844kb free which was more then enough for asa9 version. to confirm this
i tried to start application on simulator which had ~5MB of free dynamic heap
(T|x) and result was the same. Then i tried with simulator which had ~7mb offree
dynamic heap (centro) and suddenly database started without any error. such
memory requirements look to me too extreme to believe
for developing i use metrowerks codewarrior 9.3
sql anywhere version is 10.0.1.3706
reference database was created by unloading 9.0.2 database (only structure) to
sql, this sql was edited to remove some ml_add_property lines, all java related
lines and some options which clearly didn't existed in 10.0.1 (reloading failed
on them) and this was reloadedto freshly created 10.0.1 database
ultralite database was created with
"%SQLANY10%\win32\ulinit" -a %DATABASE% -c "dbf=hamsfadb.pdb" -n HamiltonPub -p
HmLA -s HamiltonPub
and to start database on palm i do:
db_sqlca=new ULSqlca();
if(db_sqlca)
{
db_sqlca->Initialize();
ULEnablePalmRecordDB(db_sqlca->GetCA());
db_dbstring="dbf=hamsfadb;CON=asa9con;CACHE_SIZE=1 m;pwd=sql;uid=dba"
// i tried to remove cache because i thought it is causing -78
// but it didn't helped so i left it there
db_db=ULInitDatabaseManager(*(db_sqlca));
if(db_db)
{
db_conn=db_db->OpenConnection(*(db_sqlca),db_dbstring);
//db_conn is always returned NULL
code=db_sqlca->GetSQLCode();
//code is always returned -78
}
}
any idea?
 |
Linear Mode
