title: sql connection string issue
body: <p>I want to connect to a remote database (SQL Server 2008) through code using a connection string. But I am not be able to connect to it. But I can connect the database using the SQL Server Management Studio successfully, using SQL Server authentication.</p>
  
  <p>But whenever I am trying using code I am getting the exception like::</p>
  
  <blockquote>
    <p>[DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection.</p>
  </blockquote>
  
  <p>My connection string is like this ::</p>
  
  <pre><code>Data Source=192.x.x.x;Initial Catalog=mydbName;User ID=user;Password=passw;provider=SQLOLEDB
  </code></pre>
  
  <p>Can anybody help me out.</p>
  
  <p>thanks in advance.</p>