How to connect SQL Server From Pocket PC Device

Dear members

I want to connect SQL Server database from pocket pc device

but it gives an error than "Either the sql database does not exist or access denied

My Code is

SqlConnection conn=new SqlConnection("Data Source=OurServer;initial catalog=Resident;user id = sa;password = sa);

conn.Open();

If anybody knows the problem please send some information

Regards

Bijaya

The error suggests that connectivity doesn't exist between the pocket pc device and SQL or that the server isn't running/listening on the desired protocol.

Does the same code run successfully on a desktop PC? If so try verifing that the pocket pc has network connectivity and access to the SQL machine.

Hope this helps.

|||

Thanks for reply

Now the above code can connect SQL Server 2003 installed in Windows 2000 professional machine.But it can not connect to the SQL Server installed in Windows XP machine.

what is the problem behind it.Please give some information

Regards Bijaya

|||

This blog is a great source for connection troubleshooting tips:
http://blogs.msdn.com/sql_protocols

In this case if SQL Server 2005 is running on Windows XP SP2 then you may need to add an exception to the Windows firewall for the service. The blog goes into detail on exactly how to accomplish this.

Hope this helps.