Re: Intermittent odbc_connect() problem with iodbc/openlink

Crone, James wrote:

I'm having intermittent problems with odbc_connect(). Here's the situation.... I'm trying to connect to a Sybase Adaptive Server Anywhere database running on Win2K from my web server using Solaris, Apache, PHP, iODBC, and OpenLink's ODBC universal data access driver for MSSQL/Sybase. About 75% of the time, my php scripts talk to the Sybase system fine. However, the other 25% of the time nothing really happens. IE reports a "Page cannot be displayed" error, while Firefox acts like it may do something for a fraction of a second, but then just stays on the currently loaded page. I have tracing turned on in iODBC. When things work fine, a lengthy trace file is generated and everything seems to be in order. When things don't work, all I get is the following: [snip]

No connect errors are generated either in the trace file or in the browser's display. It's almost as if the process just dies without saying anything about why it happened. [snip]

What do your servers error logs say? This sounds suspiciously like the behavior one gets when php runs out of memory. If so, it should have an "Unable to allocate # bytes " type message in the error log. Check that, and increase memory_limit in your php.ini if this is the case. Cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital.