How to connect with database

[sulabh120881]

Hi to all,
I am using series-60 2nd ed fp2 and i want to connect my symbian application to my server machine after connecting this i want to access its database that is on sql server.
I got that i can connect with server via HTTP socket connection but what should do for sql server.
Please tell me the solution,

Thanks

[skumar_rao]

Hi to all,
I am using series-60 2nd ed fp2 and i want to connect my symbian application to my server machine after connecting this i want to access its database that is on sql server.
I got that i can connect with server via HTTP socket connection but what should do for sql server.
Please tell me the solution,

Thanks

You have to write a server that takes the req. from client , uses that req. to query in the data base and send the result to client in a format that client can understand.

[S.S.Sudhakar]

Hi sulabh,

You need to write a servlet or ASP and from there you can access database.

Regards,
Sudhakar

[sulabh120881]

Thanks Rao and Sudhakar for your favorable reply.
I want to write our application in symbian c++. Is there any way to write servlet type application in symbian c++.
And to open a particular url what should i do .

Thanks a lot

[S.S.Sudhakar]

Hi,

You need to write server application either using servlets in J2EE or using ASP in .net and host in server. There are plenty of source codes available in net and you need to just google for it.

To open particular URL you can use HTTP GET either using socket or RHTTPSession .There are couple of posts given in this forum.

All the best.

Regards,
Sudhakar

[skumar_rao]

Thanks Rao and Sudhakar for your favorable reply.
I want to write our application in symbian c++. Is there any way to write servlet type application in symbian c++.
And to open a particular url what should i do .

Thanks a lot

You can Find a Client Symbian Code in SDK exmaple
\Examples\appprots\exampleclient

[sulabh120881]

Thanks to both of u, I am trying this with your reference and get back if any problem persist

Thanks again

[sulabh120881]

Hi to All,
Finally i have developed a symbian client and a web based servlet and i can connect my client to servlet via RSocket Connection but have another issue. I need to send a string from my client to servlet and I dont know how to send this. this time i m using
_LIT8(KDataToWrite,"GET /TimeProject/trylogin HTTP/1.0\xD\xA\xD\xA");
sockfd.Write(KDataToWrite,iStatus);
To connect with my servlet but if i want to send a string on this servlet like "myname" what should i do .
Please tell me how can i do this

Thanks in advance.

[S.S.Sudhakar]

hi,

You can append as a parameter to URL u r calling.

for ex.

_LIT8(KDataToWrite,"GET /TimeProject/trylogin?yourname=sulabh HTTP/1.0\xD\xA\xD\xA");

-Sudhakar

[sulabh120881]

hi
I have a servlet that reads all value and print this on screen so i m sending a value and try to print this in my servlet side like...
_LIT8(KDataToWrite,"GET /TimeProject/trylogin?success HTTP/1.0\xD\xA\xD\xA");

but it is not working

[S.S.Sudhakar]

hi,

Values should be as a pair of parameter name and its corresponding value(....?parmname=Value)

Regards,
sudhakar

[sulabh120881]

hi,

Values should be as a pair of parameter name and its corresponding value(....?parmname=Value)

Regards,
sudhakar

m not getting
if i want to send a message like "hello" only then what should i do ??

[sulabh120881]

still waiting for reply please help me to resolve this out

[S.S.Sudhakar]

Hi,

Can you specify the problem clearly. i.e., what u wnat to communicate with server.
Regards,
Sudhakar

[sulabh120881]

Hi,

Can you specify the problem clearly. i.e., what u wnat to communicate with server.
Regards,
Sudhakar

1: I just want to send a string to my servlet
you told me that i should try
_LIT8(KDataToWrite,"GET /TimeProject/trylogin?yourname=sulabh HTTP/1.0\xD\xA\xD\xA");
this calls my servlet properly but not send "sulabh ".
here what is "yourname"
means where it should be declared.

2: I want to recieve a string from servlet also.