The problem was in the C++ code! Ha!

Steve

The problem was in the C++ code! Ha!

Steve

>> WHat type of app

C++ front end, SQL Server on the back.

>> what is happening

Well the symptoms are much like the bug reported in Q191268 at ms-help://MS.VSCC/MS.MSDNVS/kboledb/Source/oledb/q191268.htm.

It's the same problem...

More information: here's the code that generates the error:

declare @iXmlDoc int

declare @vcXml VARCHAR(1000)

set @vcXml = '<root><Obj Id="3578"/>,<Obj Id="3591"/>,<Obj Id="3722"/>,<Obj Id="3703"/>,<Obj Id="3693"/>,<Obj Id="3771"/>,<Obj Id="3829"/></root>'

exec sp_xml_preparedocument @iXmlDoc output, @vcXml

exec GetOrderedMultiTxtXml$ @iXmlDoc, 5001,...

Thanks for the effort. I'm kinda impressed that you would use this problem to try your first C++ app on. I have C++ coders all around here, and I've forwarded...

Our problem looks much like the one reported in KB 191268. It gives no workaround. I don't how we have a server side query going on, but everything else matches.

We...

We have a C++ front end. We're using OLE DB for the connection.

I wanted to do the code in a stored proc, but my colleagues are telling me it would...

Both machines are running mixed mode authentication. I've switched the authentication on both, using all 4 combinations of Windows and mixed mode, and it doesn't seem to make a difference.

I...

>> Steve: IN is like an OR except less code for multiple or's.

Well, sure. But if ask my wife, she'd tell you about this. If says that the tea is...

I think part of the problem is that I'm not seeing any OR in the whole select statement. (It would help if it was not all uppercase.) Sorry, but I'm...

One of the machines that needed the user and password was mine.

Went to Computer Management (XP). I'm part of the Administrators Group.

Because I'm on XP, I went to User Accounts....

Here's another example. I'm trying to connect to another developer machine that I know is running. I open Enterprise Manager to Register a New Connection. I get an error telling...

I went to Enterprise Manager on both machines (these are all development machines), went to properties, then the Security tab. Both have "SQL Server and Windows" checked. This leads me...

Not quite sure what you're asking. Maybe the CASE statement will do what you want. From Books On Line:

USE pubs

GO

SELECT 'Price Category' =

...

Getting MDAC 2.6 SP2 appears to have cured it. Thanks.

Steve