Hi:
I have set up a sql connection, a sql command, and then a dataset to get the data from the SQL server and bind it to a datagrib. When the SQL command is pull from a view in SQL table, it return zero row, while if I change it to select from the tables it will return many rows. I run the select statement for the view in SQL and it return many rows. I have checked the pemission and I have the pemission for the view. And Idea?
Patrick
I have set up a sql connection, a sql command, and then a dataset to get the data from the SQL server and bind it to a datagrib. When the SQL command is pull from a view in SQL table, it return zero row, while if I change it to select from the tables it will return many rows. I run the select statement for the view in SQL and it return many rows. I have checked the pemission and I have the pemission for the view. And Idea?
Patrick
