Remote SQL
 

Hey does anyone know how to use vb 2005 express to connect to a remote sql server. I can get a local sql but i want to make a game to connect to an sql server to make it like a mmo

In your connection string change "Data Source" or "Server" to the IP or domain name of the SQL server.

better make sure your priveledges are set up right also or you're in for some headaches while you try to figure out where you went wrong in your code while the answer lies on your server.

If you look at the Visual Studio feature comparison table you will find that VB.net 2005 Express only has tools to work with local databases. Of course that does not mean you cant work with a remote sql server, but its just not as easy as it would be in the standard and pro versions.

http://msdn.microsoft.com/vstudio/products/compare/

I suggest you do some research in the msdn docs on how to connet to a remote server in your code. Its not that hard. If you want to do well at programming you will have to get used to searching documentation to get what you want. If you get problems when connecting then post a question here with some code. Then you will get a better response from people. Your question is far too general so no one will be motivated to give a good answer.