in reply to Re: Re: DBI ODBC CGI Access hangs on execution of select statement
in thread DBI ODBC CGI Access hangs on execution of select statement

I'm only using Access because I don't know how to use MySQL yet.

Concepts are all the same. GUI Interface is of course different. You also have a command line interface which is good if you come from *nix but may be very unfaliliar if you were weaned on drag and drool.

I think I will try to backup the db and just delete the original...

Why? Just repair it. Make a copy first of course just to be safe. We have all had the M$ hanging data loss blues (BSOD) at one stage of another.

my db is in a general folder one level above my cgi-bin folder. Does it need to be somewhere specific?

Not really provided you can connect to it. Just wanted to clarify that it is on localhost and therefore there are no network issues involved. The only real issue is that you don't want it under your HTTP root in a world readable directory assuming that this is a commercial widget and you don't want just anybody walking off with your data. Plus all the usual security stuff.

cheers

tachyon

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

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

Replies are listed 'Best First'.
Re: Re: Re: Re: DBI ODBC CGI Access hangs on execution of select statement
by buttroast (Scribe) on Apr 14, 2003 at 01:32 UTC
    One of the first things I tried to do was compact and repair it, but it wouldn't let me. It said the database was in use. I rebooted, but forgot to try it again. Thanks buttroast

      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

        Thanks again...I'll post my results later. buttroast