sql express vs sql server

[NiKeFiDO]

Im majoring in MIS (management of info systems) and for the "capstone" class we need to design and implement a system into a real company..

anyway, ours will involve gathering information from Microsoft Outlook and dumping it into a database.

I was wondering if it would be easier to just use sqlexpress and vb.net -

We want to do a small VB application to get this done - can we use SQL express over a network or can it only be used locally?

I've looked at sql server 2005 (I have a license to it as a student here) and it looked very very complicated.

any suggestions?

 

[JackMDS]

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

 

[NiKeFiDO]

I've heard that we can only connect to sql express over a network if we do some tweaking with the TCP/IP settings

anyone have any experience with this?

 

[spyordie007]

Originally posted by: NiKeFiDO
I've heard that we can only connect to sql express over a network if we do some tweaking with the TCP/IP settings

anyone have any experience with this?

You might have to change the settings from a default install, but yes you can connect to SQL express over TCP/IP.