7 Replies Latest reply on May 1, 2015 12:01 PM by FanYang

    System.Data.Odbc.OdbcErrorCollection when working on FileMaker pro



      System.Data.Odbc.OdbcErrorCollection when working on FileMaker pro


      I am working on an application to get data from FileMaker pro, based on the document: The ODBC client driver supports the following Catalog functions: 1 SQLTables - catalog information is stored and reported as single part names (table name only).

      I tested the following code but got an exception called System.Data.Odbc.OdbcErrorCollection:

      conn = new OdbcConnection("DSN=FileMaker;Uid=Admin;Pwd=123456");
      cmd = new OdbcCommand("SELECT * FROM SimpleProductTest");
      cmd.Connection = conn;
      dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
      if ((dr != null) && (dr.HasRows))
       while (dr.Read())
               temp = dr.GetString(0);
      DataTable dt = conn.GetSchema("Tables");

      The stack trace:

      *at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)

      at System.Data.Odbc.OdbcDataReader.GetColAttribute(Int32 iColumn, SQL_DESC v3FieldId, SQL_COLUMN v2FieldId, HANDLER handler)

      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.ProviderBase.DbConnectionInternal.GetSchema (DbConnectionFactory factory, DbConnectionPoolGroup poolGroup, DbConnection outerConnection, String collectionName, String[] restrictions)

      at System.Data.Odbc.OdbcConnection.GetSchema(String collectionName, String[] restrictionValues)

      at VizSeekApp.DbMapForm.button1_Click(Object sender, EventArgs e) in C:\FrontEndProjects_new\WindowsDesktopApp\VizSeekApp\VizSeekApp\DbMapForm.cs:line 335*

      The inner exception and error message are empty.

      I did research about System.Data.Odbc.OdbcErrorCollection, but no luck. Also I tested this piece of code with MySql ODBC, which works well, it means that my code may not have problems. Anyone find a problem? Thanks in advance.