my android application is using ultraliteJ. I am trying to configure mobilink server in such a way that it can communicate with my application.
1) I activate mobilink server using the following command: mlsrv12 -vcrs -zu+ -c "dsn=;uid=;pwd=**" -x http(port=80)
I got such an error: E. 2011-09-08 15:29:45. <main> [-10002] Consolidated database server or ODBC error: ODBC: [Sybase][ODBC Driver][SQL Anywhere]Specified database is invalid (ODBC State = 08001, Native error code = -84)
Do you have any idea on how can I fix it?
Thanks in advance.
After creating a consolidated SQL Anywhere database for MobiLink with dbinit, you must also run the the syncsa.sql file in the %SQLANY12%mobilinksetup directory as described in the documentation :
For example : dbisql -c "dsn=MyTestEG;uid=dba;pwd=sql" read "%SQLANY12%mobilinksetupsyncsa.sql"
Another suggestion : When you define the DSN and specify the name of the database file, specify the full path to the database file. That way, you will be able to use the DSN even if the current directory is not the directory where the database file exists.
For example : dbdsn.exe -v -w MyTestEG -y -c "uid=dba;pwd=sql;dbf=c:\db\manutenzione_q_remote.db"
As the MobiLink server is just another ODBC client application, you might have to check the connection string (as @Reg has suggested). If you're using an ODBC DSN, you could also use the ODBC administrator to test the DSN.
This might tell you that the database is not running or not able to start...
More helpful hints from the docs - the link leads to more infos on server startup problems and connection problems:
answered 08 Sep '11, 11:25