C# and SQL Express

hi Y'All!

I've been having quite some fun doing C#, im doing an accounting system just for the fun of it. I find C# quite user friendly (though Im using the express edition). Its not really that cryptic. Though one must be able to grasp the concept of OOP. Well, enough praise about the language, I know i wont get any freebie anyway. Just some question though.

1. Im planning to use SQL Server express as backend, right now Im using firebird and plan to change backend. What are the limitations of SQL Express edition? like can I use it in providing for example a network of 10 users with an accounting application.

2. I plan later to create a C# program (windows application) that will access a database for example in the internet, the database (SQL) residing in a server in japan? how can this be done?, They say all you have to do is define the connection string, is there a sample for this?

3. If I use SQL server express can it handle my question No. 2?

Thanks to all of you, I have learned a lot in this forum. Some of the questions and answers I could not have learned in a year or so of studies on my own.

Y'all are great!

Omar

you need to enable remote connections in order for other computers around the network to connect to it:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=802873&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=687532&SiteID=1

http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

once configured, it should be ok for use!

|||

SQL Express does not support HTTP endpoints, you have to connect to it through a WAN/LAN. Other editions of SQL Server that support HTTP Endpoints can be connected through via the Internet.

Mike