Jeff, I have reset your ES license again so that you can take another stab at it. Let me know if this doesn't get you going.

Sorry about that! I had the form pulled up but didn't press save .

You should be good to re-register now.

Good news.  ES is finally up and running on my test server.  I hope that once I get my testing done that my production server will be a lot easier to setup.

One question I do have.  The database has a table with over 100,000 records that the client needs to see all at one time, but I got a timeout error when loading these records into a grid using a BO mapped to SQL Server View.  Where do I increase the timeout to adjust for loading these records using ES?

Thanks,

Jeff

This would be on the SqlCommand, not the server timeout. So you would create the SqlCommand and set the timeout to a really high number or 0 for infinite.



However, let me suggest possible another route. Why would you need all 100,000 records at once? If you are trying to perform an incremental search, then you can create a threaded loader so that every time you type in a new character, it gets added to the queue, gets passed over to the server to s SPROC which executes the query, and sends back a TOP result set. Generally I limit my TOP results to 100 (or possible 1000) when I do something like this. This way you get a really fast, real-time search. To date, I have never needed or seen a reason for having 100,000 records client side.

Hi Trent,

I agree with you.  I am going to have to provide some filtering capabilities for the client that will meet his requirements as you suggested.  I have no experience with threading.  So would you provide me some code examples about how I can accomplish this incremental search.

Thanks,

Jeff

To save you some time, I have created a sample showing how to do this.  I couldn't remember what language you used, so it is in C#.  It is easy to convert, though, and I will try to post a VB.NET sample later.  But either way, this should get you going and you can see what I was getting at.  Here is that sample:

http://forum.strataframe.net/FindPost25669.aspx

Hi Trent,

Thank you so much for the example.  I'm using VB.NET, but after looking at the example, I believe I can convert the C# code.

Jeff

Glad it helped.