Author Topic: MsSQL: access to table but not to data  (Read 202 times)

Offline Subz

  • Full Member
  • ***
  • Join Date: Jul 2017
  • Posts: 6
  • Forum Citizenship: +0/-0
MsSQL: access to table but not to data
« on: 09 Jul 2018 05:48:40 am »
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 :-)

Offline fry

  • Community Leader
  • *****
  • Join Date: Jun 2013
  • Posts: 78
  • Forum Citizenship: +0/-0
Re: MsSQL: access to table but not to data
« Reply #1 on: 09 Jul 2018 08:48:28 pm »
Are you running Framework Manager as admin. If you are using drivers, make sure you are using DQM in FM

Offline Subz

  • Full Member
  • ***
  • Join Date: Jul 2017
  • Posts: 6
  • Forum Citizenship: +0/-0
Re: MsSQL: access to table but not to data
« Reply #2 on: 11 Jul 2018 03:24:16 am »
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  :(

Offline sdf

  • Statesman
  • ******
  • Join Date: Feb 2014
  • Posts: 456
  • Forum Citizenship: +3/-0
Re: MsSQL: access to table but not to data
« Reply #3 on: 18 Jul 2018 11:10:06 am »
just for checking, can you set up an ODBC connection to your SQL and try to use that?

Offline the6campbells

  • Community Leader
  • *****
  • Join Date: Jan 2012
  • Posts: 97
  • Forum Citizenship: +6/-1
Re: MsSQL: access to table but not to data
« Reply #4 on: 20 Jul 2018 08:54:11 am »
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.


 


       
Twittear