You can translate the question and the replies:

Invalid object name 'fn_listextendedproperty' when introspecting tables in SQLServer2000 via JDBC

We are trying to create base views on tables in a SQLServer2000 dataase using Microsoft SQL Server 2000 (JTDS) datbase adapter. However in the "Create base view" tab if we select a table we get an error: ***Invalid object name 'fnlistextendedproperty'*** . The table is in the the default schema "dbo" schema. We can successfully create a base view using the "Create from Query" option and entering "select * from actions" ("actions" is one of the table names). However we do not want to have to create base views this way for every table, because there are a large number of tables and it is better practice to use introspection.
11-09-2021 09:41:53 -0400

1 Answer

Hi, If I face this error, I would do the following checks: * In the underlying source, check if the table exists and the user performing the view creation from Denodo has necessary privileges. * Check if the JDBC driver for the MSSQL Server “mssql-jdbc-6.2.2.jre8.jar” exists under the <Denodo_Home>/extensions/jdbc-drivers/mssql-jdbc-6.x directory. * Also try accessing the same table using equivalent JDBC clients like DBVisualiser(using the same driver and user credentials) and verify if that works fine. If the issue persits and if you are a user with valid support access, create a support case in [Denodo Support Site]( so that our support team will assist you further in resolving this issue. Hope this helps!
Denodo Team
14-09-2021 08:30:27 -0400
You must sign in to add an answer. If you do not have an account, you can register here