Connect to SQL Server with VB .NET Express

[joefox]

I try to use my data source and setup a new connection, but i see it wont let me.

Is this another features they left out of 2010 express edtions?

I just want to setup a connection to sql server with vb.net express 2010

[motil]

you really should provide more details. what is the error you get ?

[techgnome]

Yes... it even tells you this when you first try to create the datasource - VBExpress can/will only connect to local databases (like Access) or local SQL Express instances.

You can still use SQL Server but you just can't connect to it using the datasource tool. There's two ways to work around this: 1) Create a local version of the database on your machine.... then you can use that for development, just be sure to change the connectionstring in the config file when you deploy. 2) Skip the datasource explorer all together and code the connections and averything else yourself directly.

-tg