Urgent code needed for connecting to a remote sql server

[gabrielvarun]

Hello everybody,
Thanks for everybody who tries to help me out. I need code for connecting to a remote database(Sql server2000) through the vb.net 2003. The sql server will be placed remotely outside the lan. Please help me.

Yours Faith fully,
Varun.
sd/-

[nmsreddi]

hello

what actually your problem you are saying remote server is out of lan what it indicates ,is there no physical connectionm existing

can you be more specific

[gabrielvarun]

I am going to do a project in which i have to connect to a remote database. Its not in a computer in my local area network. That system will be situated remotely in some places. We have to connect to the system and retrive data from the sql2000 database. So i want help to get connection to the system in which ever ways possible.

[NinethSense]

Inside LAN or outside LAN or outside WORLD!!!... connection string remains same.

"Data Source=ipaddress;Initial Catalog=db;User Id=username;Password=apassword;"

:)

But internet connectivity is a must.

[nmsreddi]

hello

Dont bother where ever the server may reside in your connection string you just change datasource(server) field


datasource=IP of the server if you are using internet

or

datasource=server name iof you are using local server

connection never changes but make sure that user id and password are correct

[radcaesar]

Use that particular DB Server Name or IP and Uname and Password. But You must have rights to connect to that DB. Don't had a thought of whether its inside your office or outside.

[gabrielvarun]

Thank you my Brothers,
For all the help u have done. I expect more from you please help me like this to get a bright career. Thanks again.