title: How to bind data to SQLBindCol using ODBC Driver API using C++
body: <p>I'm trying to create a custom ODBC driver using C++ for a Windows environment (like PostgreSQL, Simba, Firebird, etc.) since the ODBC API has multiple <a href="https://msdn.microsoft.com/en-us/library/ms714562(v=vs.85).aspx" rel="noreferrer">ODBC API</a> methods by default.</p>
  
  <p>I established connections using DSN, and I'm able to execute the SQL query using the <a href="https://msdn.microsoft.com/en-us/library/ms713611(v=vs.85).aspx" rel="noreferrer">SQLExecuteDirect</a> method.</p>
  
  <p>However, while connecting Excel with our ODBC driver, I'm unable to bind the table list to the Microsoft query wizard.
  <a href="https://i.stack.imgur.com/FRoMc.png" rel="noreferrer"><img src="https://i.stack.imgur.com/FRoMc.png" alt="enter image description here"></a></p>
  
  <p>The <a href="https://msdn.microsoft.com/en-us/library/ms711831(v=vs.85).aspx" rel="noreferrer">SQLTables()</a>, <a href="https://msdn.microsoft.com/en-us/library/ms711010(v=vs.85).aspx" rel="noreferrer">SQLBindColumn()</a>, and <a href="https://msdn.microsoft.com/en-us/library/ms712424(v=vs.85).aspx" rel="noreferrer">SQLFetch()</a> methods are used to retrieve the list of tablenames here. The data is bound using the SQLBindColumn method.</p>
  
  <p>But I'm confused about how to retrieve the tablenames and bind them to Excel?  </p>