How to connect to remote SQL Server using ADO.NET

by EdgarJan » Tue, 23 Jul 2002 10:33:23

string connectionString = "server=192.168.1.205;initial
Catalog=finehome;uid=edgar;password=julie;database=WHMS_S",
CommandType.Text, "Select * from GERINFOS";

using (System.Data.SqlClient.SqlConnection cn = new
System.Data.SqlClient.SqlConnection(connectionString))
{
try
{
cn.Open();
}
catch(Exceptio se)
{
MessageBox.Show(se.ToString());
}

Quote:}

---> cn.Open() has a problem.

please give me some hints.
thank you.

Top

1. connecting to a remote server using vb+sql server using ADO

hi,

i want to develop a database application using visual basic and ms-sql
server. i will be using front end application from different systems
on a network and the database resides on a Windows 200 Advanced Server
in the same network(in the same location).

i want to know which way i can connect to the server for accessing the
database. i want to connect using ADO.

also i want to know the connection properties if the database resides
on a different location.

somebody can plz email me the connection properties at

regards,

sunil.

2. Brio/Web developer consultant

3. Crystal Reports/Active X/MSIE/IIS 3.0/MS SQL Server

4. VB.NET clients connecting to remote SQL server using URL

5. Advice needed for GroupSelection

6. How to connect to SQL Server using ADO.NET and C#

7. Why PostgreSQL is not that popular as MySQL?

8. Using ADO.Net to connect to a SQL Server Database