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
}