Nemachtiani (4/8/2013)
Hi Mr. MagooSorry for being "vague" but cannot just post all code for obvious reasons...
I'll check with detail your tip about "byref"...just don't know why the "byval" have been working for years and millions of times executing without this "extra-ordinare" case...
but at this time I could expect anything...
thanks a lot!
understood about posting the actual code, but even a simple example that show the method you use to create/open/pass the connection around and the same for the transaction object would help.
Also, we can't see what is happening inside your SQL procedures - as you have already said they have code to handle transactions as well, and in my experience this will almost certainly cause problems unless you are extremely careful.
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);