MsSQL: access to table but not to data

[Subz]

Hi :-)

we just set up an MsSQL Data Source in the CA configuration. The test is successfull. In the Framework Manager we can import a table (we also can see all columns), but we are unable to receive Data. It fails every time. We installed the latest DB driver on the CA Server.

The DB User has the correct rights and we are receiving data with the mssql explorer.

Have someone an Idea why we cant receive Data?

Thanks :-)

[fry]

Are you running Framework Manager as admin. If you are using drivers, make sure you are using DQM in FM

[Subz]

yes, I´m admin at the FWM and we are using DQM with JDBC.

Its strange that we have access to the meta data of the table, but not to the data  :(

[sdf]

just for checking, can you set up an ODBC connection to your SQL and try to use that?

[the6campbells]

JDBC (and ODBC) metadata methods can return metadata for objects (i.e tables) even if the user performing the API call does not have the ability to query the table.

In some cases, a vendor may internally filter their metadata responses to only return those the use has access to, but that is not a requirement of the specification.