To clarify a few things here:

The "string accumulation technique" is absolutely supported in SQL Server and likely always will be (the "Quirky Update" is a bit more of a grey...

Hmm, well "An error occurred in dialog transmission:" is definitely Service Broker stuff. Have you checked to see what spid 18 is on your Sql server?

Ahh,...

Jeff Moden (5/16/2012)

---

You know me... I don't go into these things blind. I always have test data. Helps me keep my alligator mouth from overloading my humming bird...

You know, the more I think about and look into this, the more I suspect that I may be just totally wrong. Let's just forget the whole thing ...

Heh, glad I could help, Grant. 🙂

Well, "officially" is too strong on my part, I'm not sure that India has an official arbiter of their dialect of English since leaving the Empire. Unless they still...

Lynn Pettis (5/17/2012)

---

You find it used off-shore, particularly India: http://oald8.oxfordlearnersdictionaries.com/dictionary/upgradation

We now have, English, American...

Grant Fritchey (5/17/2012)

---

The defaults for the 2012 install should be for traditional. If not, go to Tools, Options, Keyboard & change it to the default. That's one fight with the...

What do the errors in your ERRORLOG say? They should identify what proc/batch is failing due to insufficient TempDb space.

Oh, and "Upgradation" isn't really a valid word in English. Just use "Upgrade" instead.

I could, but I really want to use the new one. Plus, as a consultant, sometime I will *have* to use it, so I'd really like to be able...

Ah well, "(4,34) Microsoft Vbscript compilation error Invalid c(h)aracter" is a completely different problem, it has nothing to do with SQL Server or ODBC.

In the code that you posted:

-------------------------------------------------------------------------------------------

Const adOpenStatic...

Well I looked at the estimated and actual query plans for several different versions of my attempt,...

Thanks for the test, Kevin.

Hmm, I wonder why that didn't work? ...