title: Excel VBA 80040e4d Automation Error connecting to Firebird
body: <p>there.</p>
  
  <p>I'm trying to connect to a Firebird database through Excel 2010 VBA with no success. I'm kind of newbie with this ADO ODBC thing, so I can't figure out the mistake.</p>
  
  <p>I have a <strong>.fdb</strong> file. On my Excel I reference to <strong>Microsoft ActiveX Data Objects 6.0 Library</strong>. Then I gone to Firebird site and downloaded and installed the <a href="http://www.firebirdsql.org/en/odbc-driver/" rel="nofollow">Firebird ODBC Driver</a>.</p>
  
  <p>My VBA Code is simple:</p>
  
  <pre><code>Dim conn As ADODB.connection
  
  Set conn = New ADODB.connection
  conn.Open "DRIVER=Firebird/InterBase(r) driver; UID=SYSDBA; PWD=admini; DBNAME=C:\test.fdb;"
  </code></pre>
  
  <p>My connection string, as stated is <strong>"DRIVER=Firebird/InterBase(r) driver; UID=SYSDBA; PWD=admini; DBNAME=C:\test.fdb;"</strong></p>
  
  <p>When I run the sub, I get a </p>
  
  <blockquote>
    <p>Run-time error '-2147217843 (80040e4d)': </p>
    
    <p>Automation error</p>
  </blockquote>
  
  <p>What am I missing? What could I do? Do I need a Firebird server installed at my machine and on any clients machine?</p>
  
  <p>Cheers.</p>