System.Data.Odbc.OdbcException: 'ERROR [HY000] HTTP status code: 404, Code: 73, e.displayText() = DB::Exception: Unknown format ODBCDriver2

224 views
Skip to first unread message

Seevali H Rathnayake

unread,
Oct 16, 2018, 12:08:34 AM10/16/18
to ClickHouse

I am getting the above error when running bellow code in a C# (.Net FX 4.0) app (Windows). Connection opens but the error occurs on line 

command.ExecuteReader();


var connection = new OdbcConnection("Driver={ClickHouse ANSI};SERVER=172.<<IP_ADDRESS>>;DATABASE=<<DB_NAME>>;PORT=<<PORT>>;FRAMED=0;Uid=<<USER>>;Pwd=<<PASSWORD>>");
 
var strSql = "SELECT * FROM tblName LIMIT 2";
 
var command = new OdbcCommand(strSql, connection);
 connection
.Open();
 
var reader = command.ExecuteReader();

ODBC Driver: https://github.com/yandex/clickhouse-odbc/releases/tag/2018-09-03

Denis Zhuravlev

unread,
Oct 16, 2018, 12:14:17 AM10/16/18
to ClickHouse
THIS RELEASE (and all next) COMPATIBLE WITH CLICKHOUSE SERVER 18.10.3+
If you have older server -- use older releases.

Seevali H Rathnayake

unread,
Oct 17, 2018, 1:13:30 AM10/17/18
to ClickHouse
Thanks!
Reply all
Reply to author
Forward
0 new messages