PHWinfo - Afficher un message

14/09/2007, 22h18

(raymond_b_jimenez@yahoo.com) writes:
> For all the docs I've seen till now, KeyInfo really seems like the
> most interesting option. A couple of remarks:
> 1-I use an ExecuteReader with no parameters, so no CommandBehavior is
> being used.
> 2-I do not see any "SET FMTONLY OFF" being executed, despite some
> people complaining about that on the net. If one sees
> http://msdn2.microsoft.com/en-us/lib...dbehavior.aspx
> it would also be appearing in my case.
>
> I'm now looking into the SqlCommand and SQLConnection classes to see
> if something can make the "SET NO_BROWSETABLE ON" disappear. Anyone
> got a clue?

Since I don't see SET NO_BROWSETTABLE ON in my test setup, it's a bit
difficult to advice. Maybe you can post a sample program which produces
the dreaded NO_BROWSETABLE? Preferrably this should be a simple
command-line program without GUI.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

14/09/2007, 22h18	#2
Erland Sommarskog Messages: n/a Hébergeur:	Re: SET NO_BROWSETABLE ON ? (raymond_b_jimenez@yahoo.com) writes: > For all the docs I've seen till now, KeyInfo really seems like the > most interesting option. A couple of remarks: > 1-I use an ExecuteReader with no parameters, so no CommandBehavior is > being used. > 2-I do not see any "SET FMTONLY OFF" being executed, despite some > people complaining about that on the net. If one sees > http://msdn2.microsoft.com/en-us/lib...dbehavior.aspx > it would also be appearing in my case. > > I'm now looking into the SqlCommand and SQLConnection classes to see > if something can make the "SET NO_BROWSETABLE ON" disappear. Anyone > got a clue? Since I don't see SET NO_BROWSETTABLE ON in my test setup, it's a bit difficult to advice. Maybe you can post a sample program which produces the dreaded NO_BROWSETABLE? Preferrably this should be a simple command-line program without GUI. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx