Re: Re: Re: Re: Re: DBI ODBC CGI Access hangs on execution of select statement

You do have a lockfile issue then. If your DB is called FOO.MDB then you will find the lockfile called FOO.LDB in the same dir as the .MDB file. Delete FOO.LDB and all should be well. If Windows won't let you you can often make a copy of the 'locked' file FOO.MDB to say FOO1.MDB. FOO1.MDB will then have lost the lock.

cheers

tachyon

s&&rsenoyhcatreve&&&s&n.+t&"$'$`$\"$\&"&ee&&y&srve&&d&&print

Comment on Re: Re: Re: Re: Re: DBI ODBC CGI Access hangs on execution of select statement

Replies are listed 'Best First'.
Re: Re: Re: Re: Re: Re: DBI ODBC CGI Access hangs on execution of select statement by buttroast (Scribe) on Apr 14, 2003 at 01:53 UTC
Thanks again...I'll post my results later. buttroast	[reply]
Re: Re: Re: Re: Re: Re: Re: DBI ODBC CGI Access hangs on execution of select statement by buttroast (Scribe) on Apr 14, 2003 at 03:01 UTC
Hello, I am at home now. I do have a lock file issue...How do I get rid of it? I don't want to have to leave the file there forever. I don't know how to delete the ldb file. I also cannot delete the JETTMP file that is in cgi-bin. I'm using Apache and Windows ME. I don't want to have to rename my db either. Here is my entire script in case you see something wrong that I am overlooking...There is no security as far as incoming data checks yet Read more... (10 kB) Thanks buttroast	[reply] [d/l]