>From an ASP.NET Web Service environment, with VB.NET code which uses my framework to process each SQL select. We are using the SQLClient provider. The approach is the data adapter by the use of its oDataAdapter.SelectCommand syntax. But, there is a verification in place within that context. Because, doing the same command from SSMS environment works all the time.

I'm pretty sure that it's .NET problem not SQL Server.