How to connect to remote SQL Server using ADO.NET

How to connect to remote SQL Server using ADO.NET

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

string connectionString = "server=;initial
CommandType.Text, "Select * from GERINFOS";

using (System.Data.SqlClient.SqlConnection cn = new
    catch(Exceptio se)


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

please give me some hints.
thank you.


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


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



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

9. Access a remote OLAP / SQL Analysis server from ASP.NET using ADOMD

10. how to connect to remote oracle/sql server using adodb

11. using an IP address to connect from remote SQL Server

12. Connecting to remote SQL Server using DUN