Home / Community & Support / Developer Productivity Tools Forums / OpenAccess ORM > OpenAccess ORM Free Edition > Firebird problem

• Alex

  Posted on Dec 22, 2011 (permalink)

  Hi,
  
  I have a firebird database (2.0.1) with dialect 1 and every table access I receive the same error base ( column unknown ) : Column exists and I used the option "Generate Model from Database".
  
  Unhandled Exception: Telerik.OpenAccess.Exceptions.DataStoreException: Error exe
  cuting query: Telerik.OpenAccess.RT.sql.SQLException: Dynamic SQL Error
  SQL error code = -104
  Token unknown - line 1, column 10
  "ID_EMPRESA"
     at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuer
  y()
     at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery()
     at OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute()
  SQL:
  SELECT a."ID_EMPRESA" AS COL1, a."DT_UPDATE" AS COL2, a."EM_FANTASIA" AS COL3, a
  ."EM_NOMERAZAO" AS COL4, a."ID_USUARIO" AS COL5 FROM "EMPRESA" a ORDER BY a."ID_
  EMPRESA"  Telerik.OpenAccess.RT.sql.SQLException: Dynamic SQL Error
  SQL error code = -104
  Token unknown - line 1, column 10
  "ID_EMPRESA"
     at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuer
  y()
     at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery()

  Reply

• Ady Ady

  Posted on Dec 23, 2011 (permalink)

  Hi,
  
  Do you get this error on every persistent class that you try to query for? This might be a problem with the mapping. Can you send me your .rlinq file? Having a closer look at your mapping might give further insight into the problem and its cause.
  
  Looking forward to your reply
  
  Kind regards,
  Ady
  the Telerik team

  Want to use Telerik OpenAccess with SQL Azure? Download the trial version today. 

  Reply

• Alex

  Posted on Dec 23, 2011 (permalink)

  I tried with another Charset and worked fine. 

  Reply

• Ady Ady

  Posted on Dec 23, 2011 (permalink)

  Hello,
  
   Can you provide details of which charset you used earlier and what did you change it to? This would help us in improving our test coverage.
  
  All the best,
  Ady
  the Telerik team

  Want to use Telerik OpenAccess with SQL Azure? Download the trial version today. 

  Reply

• Alex

  Posted on Dec 23, 2011 (permalink)

  Sorry. I don't whats happen but I coun't reproduce the problem. I will try.

  Reply

Back to Top

Home / Community & Support / Developer Productivity Tools Forums / OpenAccess ORM > OpenAccess ORM Free Edition > Firebird problem