On 26/01/16 19:06, Alko Kotalko wrote: > I've tried all the notations with PDO as well and none of them work with > SAP HANA. It works with MySQL though. So I presume that there is either a > bug in PDO driver or there is some mismatch between PDO and SAP HANA.
Firebird does not support named parameters so we stick with ? parameters. Not sure on SAP HANA, but a quick google gives "The SAP HANA JDBC driver doesn't support named parameters" and I would anticipate that the ODBC driver probably has the same problem, but the simpler ordered array of parameters should work ... There WAS a document about just what combinations HAVE been tested and worked, but I'm not even sure now where it as created :( >From the generic ODBC driver - http://php.net/manual/en/function.odbc-prepare.php ... Some databases (such as IBM DB2, MS SQL Server, and Oracle) support stored procedures that accept parameters of type IN, INOUT, and OUT as defined by the ODBC specification. However, the Unified ODBC driver currently only supports parameters of type IN to stored procedures. It is some time since I used the ODBC interface, but I think PDO_odbc still uses the generic ODBC inerface and this does have it's own restrictons based on what platform you are using. It may be worth trying the generic ODBC interface and see if this works any differently. The ODBC driver uses the same style of working as the Firebird/Interbase driver for binding variables and that does work. -- Lester Caine - G8HFL ----------------------------- Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php