DataBase Connection

[udham]

Hi
I am new to Iphone Development. I have to built Iphone Business application. I need to know how to connect SQL server database in my application. assist me.. you can send sample code to my mail id udham1985@gmail.com


Thanks
Udham

[magalhaes]

if you want to use sql server, you have to make an app to run in server and transfer data tables of iPhone for it, you have to use Sockets to send and receive data between SQLite and sqlServer, and so on....
read about sockets and try find SocketWrappers to know how to do it

[caveatashish]

Hi Udham,

Did you got the solution for this one and can you share the same with me ?

Thanks,
Ashish

[udham]

Hi.. I created php file in my server and send the request from iphone. The php file execute the query and generate xml file . after that i used XMLParser to parse the XML file.

Originally Posted by caveatashish

Hi Udham,

Did you got the solution for this one and can you share the same with me ?

Thanks,
Ashish

[gems]

Originally Posted by udham

Hi.. I created php file in my server and send the request from iphone. The php file execute the query and generate xml file . after that i used XMLParser to parse the XML file.

Sir,
I am dealing with what you have done. i want to send the data to PHP file present at server side. i am accepting the data in my App. Can you share the code for this or any help. thanks in advance
Mahesh Paymal

[udham]

I used the below steps to send the data to php file

NSString *urlstr = [[NSString alloc] initWithFormat:@"http://myserver.com/test.php?Username=%@&Password=%@&clientcode=%i", strUserName,strPassword,intCCode];
NSURL *url = [[NSURL alloc] initWithString:urlstr];
NSString *ans =[NSString stringWithContentsOfURL:url];

Want more details you can mail me , my id is udham1985@gmail.com



thanks