Firebird problem

5 posts, 0 answers
  1. Alex
    Alex avatar
    9 posts
    Member since:
    Sep 2008

    Posted 22 Dec 2011 Link to this post

    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()
  2. Ady
    Admin
    Ady avatar
    589 posts

    Posted 23 Dec 2011 Link to this post

    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. 
  3. DevCraft banner
  4. Alex
    Alex avatar
    9 posts
    Member since:
    Sep 2008

    Posted 23 Dec 2011 Link to this post

    I tried with another Charset and worked fine. 
  5. Ady
    Admin
    Ady avatar
    589 posts

    Posted 23 Dec 2011 Link to this post

    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. 
  6. Alex
    Alex avatar
    9 posts
    Member since:
    Sep 2008

    Posted 23 Dec 2011 Link to this post

    Sorry. I don't whats happen but I coun't reproduce the problem. I will try.
Back to Top
DevCraft banner