|
|
Posted by Steve on 09/20/07 14:24
"Rodent" <denismcf@gmail.com> wrote in message
news:1190295843.172575.319790@19g2000hsx.googlegroups.com...
>I have an IIS 6.0, 2003 Server running with PHP installed.
>
> I have an access database with a DSN ODBC connection configured.
>
> When this ODBC is configured to access the database locally - great,
> works fine.
> When configured to access a remote copy of this database I get the
> following :
>
> "....Warning: odbc_connect() [function.odbc-connect]: SQL error:
> [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database
> engine cannot open the file '(unknown)'. It is already opened
> exclusively by another user, or you need permission to view its data.,
> SQL state S1000 in SQLConnect in C:\Inetpub\wwwroot\PI\getdata.php on
> line 3...."
>
> I have tried to set permissions on the database stored on the
> networked volume to allow the 'IUSR_servername' user on the web-server
> to have rights but am unable. I've tried giving 'everyone' the full
> rights to the database all to no avail.
great! all of that *needed* to be done. however, the error message is not
related to file permissions. what you need to do now, is open up the db on
the network volume in *access*. once open, you need to set the options for
it (tools...options). next, go to the 'advanced' tab and set the 'default
open mode' to shared. close access. finally, go the the network volume where
the .mdb file is. once there, delete all .ldb files. then give it a go.
btw, afaicr, you can also massage some of that in your odbc config and/or
connection string.
i should state that you should *always* use a connection string instead of
actually creating a DSN for access. further, only use access db's when you
plan to have access provide the gui interface as well. mysql (and just about
any other db engine) beats the snot out of ms access in terms of speed,
reliability, and capacity. you'll find that out as soon as you get 2 users
simultaneously hitting it and your mdb file size gets to about 1MB.
but, that's just my 0.02 usd
> Getting to the stage where I'm going to ask the end user to copy their
> database permanantly to the server where the PHP page lives, and give
> them a shortcut to it .... but .... it's reaally reaally annoying me
> now and I'd like to sort it out properly.
that would require you to NOT use ms access. ;^)
Navigation:
[Reply to this message]
|