Hi guys,
I have a client who insists on using PHP and an Access database. He
describes a problem with the access databases becoming locked when a user
clicks 'stop' in their browser whilst downloading the page (and I have to
stop the IIS server to release it). I have absolutely no experience with
PHP/Access connections, so I thought I'd ding it along and see if the elite
PHP programmers of the world can pick up an error in his code.
>
> I connect like this:
> $conn = new COM ('ADODB.Connection');
> $conn->Open ("Provider=Microsoft.Jet.OLEDB.4.0; Data
> Source='c:\\home\\westir\\data\\libcat.mdb'");
> $sql = "SELECT * FROM tbl_name ";
> $result = $conn->Execute($sql);
>
> // deal with the database generated information
>
> $result->Close()
> $conn->Close
Is there a better way to do this?
Best Regards
Bob Irwin
Server Admin & Web Programmer
Planet Netcom
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
