note 47387 deleted from function.odbc-exec by didou

[email protected]
Newsgroups php.notes
Message-ID <[email protected]>
Note Submitter: Philip_Neeson at Hotmail dot com 

----

I kept getting FATAL: emalloc() errors when using select statements via odbc for MS SQL.

I had no control over the DB as it is a commercial CRM system.

I found that by 1st issuing an SQL query of "set textsize 9999;' within my PHP script is has resolved the issue..

I am running PHP 3.x on a Windows 2000 server that is patched to the max, 

I spent hours on this one trying diferent ODBC drivers etc and this simple SQL resolved the issue.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.