title: crystal reports 8 - set location dynamically in vb6
body: <p>I have a VB6 front end, SQL Server 2005 as the back end and Crystal Reports 8.5 for reports.  </p>
  
  <p>I need to set the location at run time in my application as I have 2 databases.  My problem is that when I change database, but the location remain the same.  It will be great if anyone can help me out.  Thanks in advance for your time, and here is my code.</p>
  
  <pre><code>Private Sub prin_Click()
  With CrystalReport1
      .Connect = MDI1.txtcn --&gt; this is my connection info "driver={sql server};server=server;database=database;uid=user;pwd=password"        
      .DiscardSavedData = True
      .Action = 1
      .PrintReport
  End With
  </code></pre>