im trying print records from my db (IIS, MSSQL PHP) but i have this error… Warning: sqlsrv_fetch_array() expects parameter 1 to be resource, boolean given in Answer Your query failed. This causes sqlsrv_query() to return false. Your error in your query is an errant comma: Remove it and your query should…
Tag: sql-server
php adodb MSSQL connection
I have a linux server that I’m trying to use php adodb to connect to a MSSQL server. I’ve install mssql through yum etc and I know the server can connect to it as I’ve tried the following: Any ideas why my adodb wont connect, or any examples on how I can connect would be much appreciated. An…
PHP MSSQL Server connection issue
I have a database of MSSQL server 2005. I can connect to the server via MSSLQL client software (MSSQL Management Studio). The issue is I cant connect to the server from PHP script using the same …
Help Reading Binary Image Data from SQL Server into PHP
I cannot seem to figure out a way to read binary data from SQL server into PHP. I am working on a project where I need to be able to store the image directly in the SQL table, not on the file system. Currently, I have been using a query like this one: INSERT INTO myTable(Document) SELECT * FROM OPENROWSET(BUL…
Php SQL Server table value parameter
I am using php against SQL Server 2008 using the mssql driver. Anyone know of a way to pass a table value parameter into stored procedure? Answer Table-valued parameters are not yet supported by the PHP MSSQL Driver. You’ll have to try something else, like converting your TVP into XML and passing it as …
mssql_bind empty string converting to NULL
I am currently using SQL Server 2000 Stored Procedures with PHP. Following the PHP doc, I use mssql_bind to assign value of parameters and then execute the Stored Procedure. The problem is that I got this bug which prevents me to bind empty strings to parameters (they are converted to NULL when the Stored Pro…
ASP.Net (C#) & SQL Server -or- PHP & MySQL for performance? [closed]
Money, Staff, Skill and preference to open source or commercial is neutral. Let’s take the best of the best programmers (for arguments sake) and think about this: What will perform better overall: …