connexion to databases server with symbian mobile

[biri1983]

Please

can i know the possibliy to make a direct connexion to a database server with symbian s60 mobile phone ?

please help me now if you can .

thanks.

[dougcn]

hi,

Read this wiki, and you will find the answer:
http://wiki.forum.nokia.com/index.php/DBMS

[biri1983]

thanks Dougcn,

but i forget to specify that the database is implimented on a distant machine and the SGBD is Sql server ?

thanks to help me now.

[biri1983]

Please can you help me,

I have a big probleme and i dont know if it is possible to make a distant connection to a databases server with a symbian S60 mobile!!!!

Please help me now if you can?

thanks all.

[dougcn]

hi,

AFAIK, it's not supported because no suitable drivers are available to do so.

You can create a web application which connects a back-end database server, and interacts with the web application via HTTP or socket directly in S60 application. Below is an example given by Nokia Forum.

Symbian OS: End-to-End HTTP API Example v1.3
http://www.forum.nokia.com/info/sw.n..._3_en.zip.html

[biri1983]

Thanks dougcn,it's very clear that you say but can you help me in an other solution ? :

i would use the TCP/IP to transfer files which contain query to the DB server where it excutes it and make the result in a XML file to be send after that to the mobile where it can be parsed and used.

it is possible to do that ?

thank you and also i hope that you help me now.

[biri1983]

Please,

I would use the TCP/IP to transfer files which contain query to the DB server where it excutes it and make the result in a XML file to be send after that to the mobile where it can be parsed and used.

it is possible to do that ?

thank you.
I hope that you help me soon.

[wizard_hu_]

Yes, if the DB server is prepared to receive queries on a TCP connection, and send back results in XML format (or you create such proxy/interface for the server), it is possible. Symbian supports TCP, and it also supports XML.
You can also use HTTP for transport.

[biri1983]

Thank you very much wizard_hu_,

Please can you help me with any informations or documentation that can be useful for me because i have a "END STUDY PROJECT" (developpemnt of symbian software on S60 platform that is used to manage distant databases and i will use the technologie that i had explain in my last thread.

thank you again and i hope you answer soon.

[wizard_hu_]

It really depends on your needs and the capabilities of the database server you want to access. Symbian C++ documentation and examples are available on www.forum.nokia.com, and Documentation / Symbian C++ on the left. The SDK-s also come with example projects, in case of S60 3rd edition, S60Ex\AddressBook and Chat might be useful perhaps.
If you are just learning Symbian C++, you should also check HelloWorldBasic.