title: Cannot Connect To Oracle Database Using 10g Driver but can via OLEDB Provider
body: <p>I can currently connect to an Oracle database using the following connection string:</p>
  
  <p>Provider=OraOLEDB.Oracle.1;User ID="username";Password="password";</p>
  
  <p>Ideally however i'd like to connect using the Oracle 10g driver which i believe is on the server using the following:</p>
  
  <p>DRIVER={Oracle in OraDb10g_home1};DBQ=ORCL;uid="username";pwd="password";</p>
  
  <p>I have checked using the Odbcad32.exe located within System32 as this is server 2008 64 bit and can see it is using the SQLORA32.dll driver for Oracle in OraDB10g_home1.  For some reason however I cannot connect using my string.</p>
  
  <p>I have done some on numerous other servers with no changes to my connection string indicating there is likely to be a config issue with this server.  Any ideas what to look for?  Could it be something to do with 32/64 bit oracle etc?</p>
  
  <p>Many Thanks.</p>