Less people know how to debug ODBC; I'm afraid no help can give to you.

Best regards,

Shaofeng Shi 史少锋
Apache Kylin PMC
Email: shaofeng...@apache.org

Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html
Join Kylin user mail group: user-subscr...@kylin.apache.org
Join Kylin dev mail group: dev-subscr...@kylin.apache.org




killyu <kil...@foxmail.com> 于2019年3月22日周五 下午4:53写道:

> 您好,
>       我编写C#程序时使用ODBC能成功连接Kylin,但尝试使用以下代码获取表列表时发生错误:
>             var odbcConnection = new OdbcConnection(ConnectionString);
>             using (odbcConnection)
>             {
>                 odbcConnection.Open();
>                 var table = odbcConnection.GetSchema("Tables");
>
>
>                 foreach (DataRow tableRow in table.Rows)
>                 {
>                     foreach (var column in tableRow.ItemArray)
>                     {
>                         Console.Write(column + ", ");
>                     }
>
>
>                     Console.WriteLine();
>                 }
>
>             }
> 发生错误的行为var table = odbcConnection.GetSchema("Tables");错误信息为
> Arithmetic operation resulted in an overflow.
>    at System.Data.Odbc.OdbcDataReader.BuildMetaDataInfo()
>    at System.Data.Odbc.OdbcDataReader.GetSchemaTable()
>    at
> System.Data.Odbc.OdbcMetaDataFactory.NewDataTableFromReader(IDataReader
> reader, Object[]& values, String tableName)
>    at
> System.Data.Odbc.OdbcMetaDataFactory.DataTableFromDataReader(IDataReader
> reader, String tableName)
>    at System.Data.Odbc.OdbcMetaDataFactory.GetTablesCollection(String[]
> restrictions, OdbcConnection connection, Boolean isTables)
>    at System.Data.Odbc.OdbcMetaDataFactory.PrepareCollection(String
> collectionName, String[] restrictions, DbConnection connection)
>    at System.Data.ProviderBase.DbMetaDataFactory.GetSchema(DbConnection
> connection, String collectionName, String[] restrictions)
>    at System.Data.Odbc.OdbcConnection.GetSchema(String collectionName,
> String[] restrictionValues)
>    at KylinConnectTest.Program.Main(String[] args) in
> C:\vsprojects\temp\Test\MysqlConnectorTest\KylinConnectTest\Program.cs:line
> 27
>
> 而当使用odbcConnection.GetSchema();时能正确运行。
> 请问这种方式是否可行?或者能否使用其它方式获取所有表信息?

Reply via email to