HY104 when binding an empty string

[v-mabarw]

Driver returns

[HY104 0] [Microsoft][SQL Server Native Client 10.0]Invalid precision value

when executing parametrized query with binding of the empty string with
default options:
sqlsrv_query('SELECT ?', array(''));

I am using the 1.1 driver on PHP 5.3, SQL Server 2000.

Work Item Details

Original CodePlex Issue: Issue 16410
Status: Closed
Reason Closed: Unassigned
Assigned to: Unassigned
Reported on: Feb 18, 2010 at 1:02 PM
Reported by: michalkocarek
Updated on: Jan 20, 2012 at 6:05 AM
Updated by: tomkraw1
Closed on: Jul 17, 2010 at 7:59 PM

[v-mabarw]

On 2010-07-18 02:59:35 UTC, AshayC commented:

v1.1 of the driver requires SQL Server Native Client (SNAC) 2008 at a minimum, and SNAC 2008 does not support SQL Server 2000. Hence your scenario is not tested or supported. Sorry.

[v-mabarw]

On 2012-01-20 14:05:12 UTC, tomkraw1 commented:

Last year I released an application using PHP SQL driver v 2. It works on IIS 6, FCGI, PHP 5.3 and SQL 2000. Everything works well except those parametrized queries mensioned by
@michalkocarek. SQL 2000 works with this driver and PHP 5.3 if you have "Microsoft SQL Server 2005 Backward Compatibility Components" installed and SNAC.

@ashayc if you could suggest where is the probblem I will test it.