title: SWI Prolog ODBC error
body: <p>I am attempting to connect to a local MySQL database using SWI Prolog (with ODBC driver) and I am receiving the following error</p>
  
  <pre><code>?- [family].
  % family compiled 0.00 sec, 264 bytes
  true.
  
  ?- open_db.
  ERROR: ODBC: State S1090: [unixODBC][Driver Manager]Invalid string or buffer length
  </code></pre>
  
  <p>The database name: prolog_test</p>
  
  <p>The Prolog Code (family.pl)</p>
  
  <pre><code>open_db :-
      odbc_connect('mysql:dbname=prolog_test;host=localhost', _,
                   [ user('prologuser'),
                     password('prologpass'),
                     alias(localhost),
                     open(once)
                   ]).
  
  children(X) :-
      odbc_query(localhost, 'SELECT (lemma) FROM tableName',X).
  </code></pre>
  
  <p>Thanks for the help</p>