Problems with OBDC, Access and PHP

[gavwvin]

Can anyone help me- this is driving me insane! I've got an access database to query which I have done with ODBC. I need to call a query with a parameter, and put it into an array.

$connection=odbc_connect("<dsn>","<username>","<password>");
$result=odbc_exec($connection,"{CALL Qpostage3(".$_SESSION['total_items'].")}");
while($row=odbc_fetch_array($result))
{
$postage[$row['postage_method']]=$row['MinOftotalcost'];
}
odbc_close($connection);

This code works wonderfully when it works, but it seems to not work at random- infact PHP crashes and no pages that use php can be accessed. It says:

"PHP has encountered an Access Violation at 77F47300"

Can anyone help me- please! I'm going mad!

[FMB]

I wanted to have a look at your problem, so I did a STFW and it came up with a lot of results, see for your self:

http://www.google.com/search?q=%22PHP+has+encountered+an+Access+Violation+%22+&sourceid=firefox&start=0&start=0&ie=utf-8&oe=utf-8

[gavwvin]

I had searched the web extensively- I joined this forum as a last resort!

Mostly there are lots of relevant links, about a similar problem but no solutions.

But thanks for the link, there was one possible solution there to do with permissions on the datasource. As far as I know there are none, but its worth looking into. Still, if that was the problem you'd think It would never work, rather than working once or twice then stopping. I'll investigate.

[gavwvin]

problem seems to have been fixed now, the database has been made simpler and the results returned restricted, and it seems to work fine. It must just have simply been too complicated for the poor thing to handle, so it packed up.