[erlang-questions] MySQL and Erlang: ODBC , column type error

[Carl McDade]

Hello,

Is this a problem with the driver (usually it is) or Erlangs use of the driver?

5> ConnString = "Driver={MySQL ODBC 5.1
Driver};Server=localhost;Database=wordpress;
User=root;Password=;Option=3;".
"Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=wordpress;
User=root;Password=;Option=3;"
6> {ok, Conn} = odbc:connect(ConnString, []).
{ok,<0.43.0>}
7> Results = odbc:sql_query(Conn, "SELECT post_title FROM wp_posts LIMIT 5").
{error,"Column type not supported"}
8> Results = odbc:sql_query(Conn, "SELECT post_name FROM wp_posts LIMIT 5").
{error,"Column type not supported"}
9> Results = odbc:sql_query(Conn, "SELECT * FROM wp_posts LIMIT 5").
{error,"Column type not supported"}
10> Results = odbc:sql_query(Conn, "SELECT option_name FROM wp_options").
{error,"Column type not supported"}
11> Results = odbc:sql_query(Conn, "SELECT OPTION_NAME FROM wp_options").
{error,"Column type not supported"}


It seems to me that there is a flaw in what the ODBC driver is sending
and what Erlang can understand. But in might also be a bug since I
doubt many use MySQL in conjunction with Erlang. So maybe no one has
tested this?


Can someone toss me a bone?

Thanks,

-- 
Carl McDade
Content Management Systems Consultant
www.hiveminds.co.uk
________________________