SQL Table Generator
Updated: 21 May 2010 | 2 comments
I'm trying to use the SQL Table Generator to pull back 7 columns from the HD_workitem_detail_view. I have the connection string set up and working properly but when I choose the intended table, I get the following error.
"Cannot get definitions from table HD_workitem_detail_view. Error message: Timeout expired. The timeout period elapsed prior to completion of the operation of the server is not responding."
By default it is pulling select * from table and that is what's causing the time out. Does anyone know how to resolve this?
discussion Filed Under:
Comments
I believe there is a timeout
I believe there is a timeout value property that gets created with the generated component. You can try a combination of boosting this value as well as marking up the "select * "
Another Option
is to use a stored procedure to retrieve only the 7 colums you want. HD Workitme detail has a heck of a lot of data in it, so retrieveing all of it has little value.
By using a stored procedure, you can target exactly what you want.
rob
Would you like to reply?
Login or Register to post your comment.