title: Make a ODBC connection from a delphi-7 application throu ADOConnectionstring
body: <p><strong>Background :</strong></p>
  
  <p>Application written in Delphi-7 or -6 (have search through the .exe file). Called Sigmanest.</p>
  
  <p>I have moved to new server and that's left is SigmaNest database running under SQL server. After many hours of troubleshooting for migrate that database to new server. The trouble have covered all aspect of this SQL server app. services not started at default, non working wizard, lack of full-text something, ridiculous many places to right click etc .. The lost goes on and on.</p>
  
  <p>At the moment I have a working SQL server with the database SNDBase (sigmanest) at the new hardware but not be able to connect from client.</p>
  
  <p>Na this can't be right I thought and searched for alternatives.. 4-5 click in MySQL workbench and I have it up an running on test linux box... Fine ..</p>
  
  <p>But now it comes to problem.</p>
  
  <p>SigmaNest uses a <code>ini</code> files for its config.</p>
  
  <p>So inside one <code>ini</code> file I found </p>
  
  <pre><code>; 1 = Paradox, 2 = MSSQLServer or MSDE
  ADOConnectionString=Provider=SQLOLEDB.1;Data Source=ODIN\SIGMANEST;User ID=sigmanest;Password="";Persist Security Info=True;Initial Catalog=SNDBase;
  </code></pre>
  
  <p>Okej .. installed Mysql odbc driver on the client and made the connection . All working so far ..</p>
  
  <p>Turned to google and found the ADOConnectionsstring for mysql ...</p>
  
  <pre><code>ADOConnectionString=DRIVER={MySQL ODBC 5.2a Driver};SERVER=192.168.100.19;PORT=3306;DATABASE=SNDBase;UID=sigmanest;PASSWORD=;OPTION=4;
  </code></pre>
  
  <p>But the app will not start . just return to sigmanest's config tool for db connection.</p>
  
  <p>Have posted this to SigmaTek but the only response I have been giving is a mail with ADOConnection string for MS sql server through  SQLOLEDB.</p>
  
  <p>Have searched the drive and haven't found anny dbex*.dll files witch means that they don't uses dbExpress component (my guess).</p>
  
  <p>So is there some missing dll files that didn't come with the app. Or is this kind of thing hardcoded inside the program?</p>
  
  <p>Anyone having a idea how to proceed ?   </p>
  
  <p>Or should I drop the mysql dream and go for the waste of space sql server backend.</p>
  
  <p>Per Nils</p>
  
  <p>PS.
  The SigmaNest.exe have a time stamp 2006-05-19 
  DS.</p>