This is a migrated thread and some comments may be shown as answers.

Firebird problem

4 Answers 70 Views
Data Access Free Edition
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Alex
Top achievements
Rank 1
Alex asked on 22 Dec 2011, 08:56 PM
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()

4 Answers, 1 is accepted

Sort by
0
Ady
Telerik team
answered on 23 Dec 2011, 12:20 PM
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. 
0
Alex
Top achievements
Rank 1
answered on 23 Dec 2011, 02:27 PM
I tried with another Charset and worked fine. 
0
Ady
Telerik team
answered on 23 Dec 2011, 03:28 PM
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. 
0
Alex
Top achievements
Rank 1
answered on 23 Dec 2011, 09:43 PM
Sorry. I don't whats happen but I coun't reproduce the problem. I will try.
Tags
Data Access Free Edition
Asked by
Alex
Top achievements
Rank 1
Answers by
Ady
Telerik team
Alex
Top achievements
Rank 1
Share this question
or