Member Avatar for saj_amo

hi i have a problem when connecting my application with sql server installed in a different server i am placing my connection string in this way :
Public Const strConnection = "Server=SERVER\QTMLSQLSERVER;User Id=sa; Password=sa; Database=QTML_DB
but its not working.

  • 2 Contributors
  • 1 Reply
  • 71 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by Renukavani
Member Avatar for Renukavani

Use this,

SqlConnection myConnection =
          new SqlConnection("Data Source=IP address;Initial Catalog=Databasename;Persist Security Info=True;User ID=username123;Password=password123");
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.