linxis

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

__________________
Get programming and game creation tutorials and discuss apon you peers at
http://s14.invisionfree.com/tsoft
We also accept custom software requests and new mods will be needed soon

BlazingWolf

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

__________________
_______________________________
BlazingWolf

melbolt

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.

__________________
I have never let my schooling interfere with my education. -Mark Twain-

Xbox live gamertag: melbolt

Random Spirit

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.