title: DSN to connectionstring?
body: <p>We've got an ASP.NET website that uses a database that we want to be able to use a connectionstring to get to.  We've successfully set up a DSN for connecting to this DB, but I can't seem to discover the correct magic to go with a connectionstring.</p>
  
  <p>Is there a straightforward way to translate the values from the DSN into a connectionstring?  I know that from the UI, there isn't an obvious answer for this...each db vendor provides a different UI for creating a DSN based on what they require.  However, I was hoping that underneath the UI it might just be doing something like creating a connection string behind the scenes, and I could look at that to see what I'm doing wrong.  Any hope of this?  If so, any pointers on how to get the info I need?</p>
  
  <p>(I've gone to connectionstrings.com to try to make sure my connection string is in the right format, but nothing seems to be working...which is why I'm trying this strange translate-from-dsn tact.)</p>
  
  <p><strong>EDIT:</strong> Something I must not have been clear on is that we do not want to have a DSN entry.  We have created one, and have used it for the time being, but we want to be able to get rid of it and use a connectionstring <strong>without</strong> a dsn.</p>