Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Saturday, December 16, 2017

Dev Articles
Search Directory
SQL Server

Home > Search > Knowledge Base > SQL Server > Bugs and Fixes > Bugs and Fixes
FIX: ADO Returns No Resultset for Prepared Parameterized Query Involving CHAR Data with SQLOLEDB (Q311313)        
Total Hits: 377  |  Today: 0       Rating:  
Read Reviews | Write Review | Your Rating: 

ActiveX Data Objects (ADO) may return no data with the SQLOLEDB provided under the following conditions:
  • The Prepared property on the command object is set to TRUE.

  • The query has a parameterized LIKE clause.

  • The column included with the LIKE clause is defined as CHAR (and not as VARCHAR) at the back end.

  • The parameter value has fewer characters than the back-end column size.

  • You are connecting to either a Microsoft SQL Server 7.0 or SQL Server 2000 database. If it is a SQL Server 2000 database, the Defer Prepare property is set to FALSE on the command object.

This problem occurs with the versions of ADO that are listed in the beginning of this article.

What's New at DevASP.Net
04/23  A Debug Stopwatch
04/23  The virtual bool bug
04/23  Application.EnableVisualStyles Bu..
04/23  The Process Async Reader Bug
04/23  Load a DBF into a DataTable
04/23  Weird Error: Unable to Validate D..
04/23  ASP.NET and jQuery to the Max
04/23  Fixing Error: "SetConfigurationSe..
04/23  Generics in .NET
04/23  Builder Design Pattern
04/23  Abstract Factory Design Pattern
04/23  Prototype Design Pattern
04/23  Bridge Design Pattern
04/23  Composite Design Pattern
04/23  Decorator Design Pattern
04/23  Validation in .NET Framework 4
04/23  Windows Phone 7: How to Encrypt C..
04/23  Text box to accept only number
04/23  Using the Raw Input API to Proces..
04/23  Study EVM (Earned Value Managemen..

DevASP.Net - Disclaimer - Privacy