Search results for query: *

Did you implement the 2 fixes I described: Do NOT use zero's for your timeout settings, because if the program is locking the table it might NEVER be released. Again without any block-level error handling, if an error is raised you can affirmatively close the data connection, leaving it open...

Sounds exactly like an SQL locking issue, even more of a reason to NOT use zero's for your timeout settings, because if the program is locking the table it might NEVER be released. Again without any block-level error handling, if an error is raised you can affirmatively close the data...

I see several problems with this code, but the obvious error is using zero's for both of your timeout settings, zero means infinity, try using 20 for both. Concatenating strings is a bad idea and will slow your code down, remember strings are immutable, use StringBuilder instead. I don't see...

Why are you blaming MSSQL, saying it is weak and buggy? It does what it's told to do (by your code), and is much more robust and stable than any dbf would ever be. Again you are approaching this from the wrong angle, you need to fix the bug in your code, not blame MSSQL. If you want to post...

NEVER forcefully or directly unlock a table, you can corrupt the entire database. It sounds like you really don't understand MSSQL, therefore you shouldn't be tinkering with this. sounds like you're junior-level, seek help from more senior-level staff, don't try to do this on your own.

This is not an MTS question, why did you post in the MTS forum? Also, locking is handled slightly differently depending on which version of MSSQL you're running, and I don't see anywhere in your post where you have this. Moreover, unlocking a locked table is not the solution, you need to fix...

You definately will see a huge performance boost when you move from DBF's to a database system like SQL. When you say you do a direct query and then store to temporary tables it sounds like you're doing all the calculations within your program, that's probably why it's slow. The data I pull in...

Ok, I've got my initial program up and running in VB.NET with an MSSQL backend. We've got about 70,000 people I have to calculate commission for down to 6 levels, I'm pulling the original data in through a stored procedure in SQL and mapping it all to DataTables in a master DataSet in memory...

I ran across this post and it sounds related to something I'm working on right now. I work for an MLM company and I have to rewrite a commission program that calculates down to 6 levels. Currently it's written in Access and I'm converting it in to Dot Net. sbtbill - you say that you use 5 or...