1

Closed

HY104 when binding an empty string

description

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.
Closed Jul 17, 2010 at 7:59 PM by
Not supported.

comments

AshayC wrote Jul 17, 2010 at 7:59 PM

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.

tomkraw1 wrote Jan 20, 2012 at 6:05 AM

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.

Sign in to add a comment