Problem - Using Visual Studio to connect to remote SQL server

[Skye]

Hi,

I am a newbie at all this, but here's what I want to do: We have a
very large database sitting on a SQL server that is on a remote
computer. I can access it through remote desktop and browse the
Enterprise Manager and the DB.

What I am trying to do is create a Visual Studio .Net program that
accesses the DB. Can I use a data adapter to connect to the DB? the
SQL server is on the local C drive of the remote computer so it is not
web based.
Otherwise I guess I'd have to install VS on the remote computer and
create the program there.... but I'm guessing, I really need some
advice here.

[Erland Sommarskog]

Skye (ms***********@hotmail.com) writes:

I am a newbie at all this, but here's what I want to do: We have a
very large database sitting on a SQL server that is on a remote
computer. I can access it through remote desktop and browse the
Enterprise Manager and the DB.

What I am trying to do is create a Visual Studio .Net program that
accesses the DB. Can I use a data adapter to connect to the DB? the
SQL server is on the local C drive of the remote computer so it is not
web based.
Otherwise I guess I'd have to install VS on the remote computer and
create the program there.... but I'm guessing, I really need some
advice here.

Yes, you can access SQL Server from your remote computer, provided that
you are on the same network, and you have some login that has been
granted access to the server. Typically the connection string would
look like this:

Data Source=SERVER;Initial Catalog=Name of DB;Integrated Security=SSPI

Replace Integrated Security with User ID and Password if you are using
SQL Authentication.

(I am here assuming that you are using SqlClient.)

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[Raju]

VS.NET is having problem connecting to DB and also there is a problem
with truncation of data when using VS.net.

I installed Sql 2k client and was able to connect.

Thank you
Raju

ms***********@hotmail.com (Skye) wrote in message news:<c4**************************@posting.google. com>...

Hi,

I am a newbie at all this, but here's what I want to do: We have a
very large database sitting on a SQL server that is on a remote
computer. I can access it through remote desktop and browse the
Enterprise Manager and the DB.

What I am trying to do is create a Visual Studio .Net program that
accesses the DB. Can I use a data adapter to connect to the DB? the
SQL server is on the local C drive of the remote computer so it is not
web based.
Otherwise I guess I'd have to install VS on the remote computer and
create the program there.... but I'm guessing, I really need some
advice here.