Skip to Content
0
Former Member
Jan 16, 2012 at 02:48 PM

JDBC Lookup doesn't retrieve table definition

24 Views

Hi Experts,

I'm trying to perform JDBC lookup from MS-SQL table.

I am using an existing com. channel for it.

I get the tables list but after selecting the table i can't get the definition of it like I know it.

The hourglass stays forever till I cancel it.

The PI uses a ro user in the MS-SQL database and I checked the permissions for the "view definition" as well

Any ideas?

I also get the list of the tables only.

Is there any way to see the views list?

Cheers

Ranny