Hi Boris,
Thank you for the reply. The connection string was generated by OpenAccess and yes it was off by a minor version.
As for Firebird. I was using Firebird embedded 2.5. Originally, I used the 2.1 version but upgraded when the error occurred.
See the following for the error. I removed the code but still had this error saved. I am using LINQ for the query. Below was an Any<>() query returning a bool and I also tried a standard LINQ Select query returning a List<>(). I received the same error for both. Querying a different table yielded the same error. Running the generated query against the DB in the query builder yielded a working result after a slight reformat of the generated SQL.
An exception occured during the execution of
'Extent<Dash.DAL.PROFILE>().Where(p => (p.PROFILE_NAME == value(Dash.Client.BizObjects.ProfileManager+<>c__DisplayClass0).InProfileName))'
. Failure: Count(*) query failed: Telerik.OpenAccess.RT.sql.SQLException: Dynamic SQL Error
SQL error code = -204
Table unknown
PROFILE
At line 1, column 165
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery(Nullable`1 commandTimeout)
at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery(Nullable`1 commandTimeout)
at OpenAccessRuntime.Relational.RelationalStorageManager.executeCount(RelationalCompiledQuery cq, QueryParameters parameters)
SELECT COUNT(1) FROM ( SELECT a.
"PROFILE_ID"
AS COL1, a.
"ACTIVE"
AS COL2, a.
"CREATE_DATE"
AS COL3, a.
"LAST_UPDATE"
AS COL4, a.
"PROFILE_NAME"
AS COL5 FROM
"PROFILE"
a WHERE a.
"PROFILE_NAME"
= ? ) AS TMP_COUNT
(
set
event
logging to all to see parameter values) Telerik.OpenAccess.RT.sql.SQLException: Dynamic SQL Error
SQL error code = -204
Table unknown
PROFILE
At line 1, column 165
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery(Nullable`1 commandTimeout)
at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery(Nullable`1 commandTimeout)
at OpenAccessRuntime.Relational.RelationalStorageManager.executeCount(RelationalCompiledQuery cq, QueryParameters parameters)
See InnerException
for
more details.
Complete Expression:
.Call System.Linq.Queryable.Where(
.Constant<Telerik.OpenAccess.Query.ExtentQueryImpl`1[Dash.DAL.PROFILE]>(Extent<DAL.PROFILE>()),
'(.Lambda #Lambda1<System.Func`2[Dash.DAL.PROFILE,System.Boolean]>))
.Lambda #Lambda1<System.Func`2[Dash.DAL.PROFILE,System.Boolean]>(Dash.DAL.PROFILE $p) {
$p.PROFILE_NAME == .Constant<Dash.Client.BizObjects.ProfileManager+<>c__DisplayClass0>(Dash.Client.BizObjects.ProfileManager+<>c__DisplayClass0).InProfileName
}