how to execute data base view in sender communication channel ?

[Former Member]

hi experts

how execute data base view in sender communication channel.?

when i execute select * from data base . ( Its working)

When i execute select * from dbo.view (its showing error )

My Question is there any procedure or syntax execute the views in sender side . ?

Thanks and Regards

G.Praveen Kumar

[Former Member]

Hi

Well I had a similar problem.. Try to use Select * from view with out schema(dbo) PI doesn't use schema.

[Former Member]

Hi

select * from view also not working. .

[Former Member]

the query you are going to configure is the same as the one which you need to execute in Database

May be the user credentials used for executing is different i,.e check the user used is having sufficient privileges for the same

Rajesh

[Former Member]

The Error showing

Database-level error reported by JDBC driver while executing statement 'select * from View_abcMap'. The JDBC driver returned the following error message: 'com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'View_abcMap'.'. For details, contact your database server vendor