Member Avatar for mansoorhacker

hello every body.

recently i completed a visual c# application in which the software is deployed on the client pc and the database is on database server.

my software connects well when on the same pc software and database is deployed , but do not connect when software is deployed on one pc and database is on the other.

i use connection string like this.

eg. string qry="select * from employees";

string connString="server=myservername;integrated security=true;database=xxxxx";

sqldataadapter dap=new sqldataadapter(qry,connString);

hope u will understand my problem from the dummy code.

thx and regards in advance.

  • 2 Contributors
  • 1 Reply
  • 104 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by kvprajapati
Member Avatar for kvprajapati

>help me to connect with the server

Steps:
1. Launch Visual Studio.
2. View Menu + Server Explorer (Database explorer)
3. Right click on DataConnection and Select "Add Connection" to verify the connection.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.