Glad it helped.

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

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,

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

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.

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

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

You should be good to re-register now.

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.

Hi Dustin,

My licenses have not been reset as you said so I can re-activate it with the settings I now have for my test server.  I have move the test server outside of the firewall/proxy and gave it a new URL to eliminate any problems caused by them.  Please reset the licenses so I can update it with the new URL.  The MAC address is still the same.

Thanks,

Jeff

Hi Dustin,

Now that you mention this.  My server does NOT have 2 nic cards, but I think my network admin put the server behind a proxy/firewall.  I do not know a whole lot about this stuff, but I think this may be distorting the MAC Address/IP Address references.  Is this a probable cause?  I will discuss this with my admin.

I did not find MicroFour License.dll listed in the GAC.  Therefore, this should not be a problem.

Thanks,

Jeff