How to connect to remote database with vb net?

qiux · May 4th, 2008, 11:19 PM

Hi

I am using win form application (VS 2005, VB NET and SQL SERVER 2000).
I want connect the application to remote database, how can i do this?
Client is only for user interface and business logic and
Server is for database only. (2 tier).
Can I do like that?

Thanks

planoie · May 5th, 2008, 08:03 AM

You certainly can.

What do you mean by "remote database"? How remote is it? On another server on your private network or on a non-private network?

-Peter
compiledthoughts.com

qiux · May 7th, 2008, 08:11 PM

Yeah..
It is still in our private network (LAN).

have we to change the connection strings?

planoie · May 8th, 2008, 05:37 PM

You need to set a connection string somewhere. It sounds like this is a very new topic for you. Do you have a book with some introductory information on connecting to databases?

-Peter
compiledthoughts.com

qiux · May 8th, 2008, 08:11 PM

Hmm.. I haven't connect to remote PC in LAN.
But I think that I have to set/put that remote PC's IP address in connection string so then I can connect to that.