title: Classic ASP Remote SQL Connection String
body: <p>I have a dilemma which is completely and utterly baffling me... </p>
  
  <p>We have a Classic ASP site which has been running for about a year, its powered via a local Win2008 SQL database (The SQL Express engine is on the same server as IIS).  This is the connection string we currently use</p>
  
  <pre><code>Provider=SQLNCLI10;Server=SERVERNAME\SQLEXPRESS;Database=dbname;user id=username;password=password;
  </code></pre>
  
  <p>We now have a need to move the database to a dedicated DB server, and connect to it remotely - We restored the DB on the server, and checked everything looked ok (All data is present in all tables)</p>
  
  <p>So we changed the server name to the IP address and was unable to get it to connect, in the end the only way we could get it to connect was using this connection string.</p>
  
  <pre><code>driver={SQL Server Native Client 10.0};server=IPADDRESS\SQLEXPRESS,1433;uid=user;pwd=password;database=dbname;
  </code></pre>
  
  <p><strong>HOWEVER</strong>... Now it's randomly missing product names and SKU's and prices in the front and back end, even though the data is present in the DB <strong>AND it is REALLY slow</strong> to display the webpages? If I use the same DB locally with the previous connection string its fine and all data is appearing?</p>
  
  <p>I know this DB server is fine as it powers other ASP.NET sites with via a remote connection and they are very fast to connect?</p>
  
  <p>Any hints... or help on why this new connection string is causing problems with reading data from the DB???</p>