when you are fixing the msoledbsql issue, make sure the OLE DB provider matches your SQL Server version and that all necessary Visual C++ Redistributables are installed.

I still don't see the left-hand forum list. Odd that others can. I'll try clearing my cache. There are no solutions, only trade-offs.    - Thomas Sowell A day can really slip by when you're deliberately avoiding what you're supposed to do.    - Calvin (Bill Watterson, Calvin & Hobbes)

I don't see "on-premises" as a general option for a future disgruntled enterprise customer. I know that the binary choice of one vs the other is the current way of thinking. But actually, when you think about 'cloud' and 'local' in their limiting cases (ie, all cloud vs all local), then compare the two, you only really have somewhat of a case to go on-prem if you are a huge enterprise since the other limiting case is a single human being doing computing with himself, like playing cards on a PC. But even for large enterprises, detailed connections with the outside world are just as imperative as they are for a small business or even individuals doing anything on the computer. The above is true and will remain true, in my opinion, as long as the case for individual human beings doing computing remains impractical regarding establishing sets of durable end point to end point connections with the outside world. From this scenario the cloud is merely a kind of a superfluous man-in-the-middle. But that discussion is too far away from the OP's disaster shout-out.

Surely this return will aid in your finding a good answer to a problem: CP Search[^]

Thanks, Richard. I'm frankly surprised that there's no documented way to return only specific result sets. I'll probably end up using the additional parameter to suppress output. Cheers. The difficult we do right away... ...the impossible takes slightly longer.

Good point, Griff! I didn't know that option existed! The difficult we do right away... ...the impossible takes slightly longer.

obermd wrote: So much for accuracy in results. Well, they accurately depicted the hopes of someone... Our Forgotten Astronomy | Object Oriented Programming with C++ | Wordle solver

I got your point.

Interesting, and good to know. I'm way behind on modern CSS. There are no solutions, only trade-offs.    - Thomas Sowell A day can really slip by when you're deliberately avoiding what you're supposed to do.    - Calvin (Bill Watterson, Calvin & Hobbes)

Doesn't say SQL-92 compliant, only that it has at least some features. " SQL-92 Compliance The SQL-92 standard is imprecise with regard to arithmetical operator precedence; assumptions on this matter differ amongst SQL implementations. Caché SQL supports two system-wide alternatives for SQL arithmetic operator precedence: By default, Caché SQL parses arithmetic expressions in strict left-to-right order, with no operator precedence. This is the same convention used in ObjectScript. Thus, 3+3*5=30. You can use parentheses to enforce the desired precedence. Thus, 3+(3*5)=18. You can configure Caché SQL to parse arithmetic expressions using ANSI precedence, which gives higher precedence to multiplication and division operators than addition, subtraction, and concatenation operators. Thus, 3+3*5=18. You can use parentheses to override this precedence, where desired. Thus, (3+3)*5=30. Caché SQL supports the complete entry-level SQL-92 standard with the following exceptions: There is no support for adding additional CHECK constraints to a table definition. The SERIALIZABLE isolation level is not supported. Delimited identifiers are not case-sensitive; the standard says that they should be case-sensitive. Within a subquery contained in a HAVING clause, one is supposed to be able to refer to aggregates which are “available” in that HAVING clause. This is not supported. " -- Introduction to Caché SQL | Using Caché SQL | Caché & Ensemble 2018.1.4 – 2018.1.9[^]

ok! thanks

Kent Sharkey wrote: That's so unlike Oracle. You are right, letting the features in the community version but change the EULA to not allow them in comercial software, then sueing everyone that uses them is more in Oracle's lines M.D.V. ;) If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about? Help me to understand what I'm saying, and I'll explain it better to you Rating helpful answers is nice, but saying thanks can be even nicer.

You have not given sufficient information to diagnose this. "no fetch data" can mean anything at any point in this code. You have a bunch of MessageBox statements which should be showing you the important values, but you don't mention anything at all about what they are saying. Asking questions is a skill CodeProject Forum Guidelines Google: C# How to debug code Seriously, go read these articles. Dave Kreskowiak

Protector or above, I'd guess. "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt AntiTwitter: @DalekDave is now a follower!