title: How to modify a database command in Crystal Reports
body: <p>Alright, so I've been working on this project for the past year and I've never understood this one issue in crystal reports. (I'm using the crystal reports that comes with Visual Studio 2008)</p>
  
  <p>Let's say I want to modify a database field nested in the command.</p>
  
  <p><img src="https://i.stack.imgur.com/Fdz5J.png" alt="Screenshot of the Command"></p>
  
  <p>I right-click the command field and choose the database expert option from the context menu.</p>
  
  <p><img src="https://i.stack.imgur.com/yzttN.png" alt="Database expert option"></p>
  
  <p>I then right-click the command once again and choose the Modify option.</p>
  
  <p><img src="https://i.stack.imgur.com/IkFM3.png" alt="Modify option"></p>
  
  <p>Here's where I always get stuck.. I enter the password (which is the same I use in the ConnectionString for my project) and click the finish button..</p>
  
  <p><img src="https://i.stack.imgur.com/np3I6.png" alt="Oracle connection window"></p>
  
  <p>..only to be presented with the following error message, which translates to <strong>"ORA-12154: TNS:could not resolve the connect identifier specified"</strong></p>
  
  <p><img src="https://i.stack.imgur.com/y7LZo.png" alt="Error message"></p>
  
  <p>After some searching around I found this article : <a href="http://scn.sap.com/thread/3291225" rel="nofollow noreferrer">http://scn.sap.com/thread/3291225</a></p>
  
  <p>The answer to the same problem that I'm getting was :</p>
  
  <p><em>You must install the Oracle Driver 64 if youe OS is 64 bits, and then install Oracle Driver 32 in the same home_oracle, this should be the home1. SAP just works with home1.
  You must install the Oracle Client Administrator mode.
  After that you must configure your ODBC driver to Oracle Home 1. Right now test if your ODBC connection is successful.
  Your application should run in 32 bit mode.</em></p>
  
  <p>Unfortunately I'm connected to this computer remotely and am not authorized to install / uninstall drivers and applications.</p>
  
  <p>My question is, is there another way that I can solve this issue so I can change that one field to a string?</p>
  
  <p>Thanks!</p>