Hi,
Am I doing this right? Is there something that I am missing?
I am trying to connect to an Access database using a simple perl script. All this script really does is test the connection.
I keep on getting the error:
Error connecting to testdsn
Error: [-1032] [] "[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."
For one it is not opened by anybody else, and I can't even connect to it to open it and 2) I have done ALOT of research on this error.
The information that I found basically told me that the IUSR_computername (which is used for web users anonymous access) does not have the correct permissions. That it needs permissions to not only read and write to the access db but to create the ldb file in the directory.
So from the advice of well reearched documents I...
Gave FULL CONTROL for IUSR_computername to:
1) the folder that the database is in
2) the database itself
3) the folder and files that my test script is in
But still I get the same error. I know that full control is a little drastic, but I figured that once I worked out what permissions that it needs, then I will restrict what it doesn't.
So I have know idea what the problem is. If there is a permission section somewhere else that I have missed, please let me know, I have been working on this for days, and only asked for help as a last resort.
Thanks for any advice that anyone can give me
HappyB
Am I doing this right? Is there something that I am missing?
I am trying to connect to an Access database using a simple perl script. All this script really does is test the connection.
I keep on getting the error:
Error connecting to testdsn
Error: [-1032] [] "[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."
For one it is not opened by anybody else, and I can't even connect to it to open it and 2) I have done ALOT of research on this error.
The information that I found basically told me that the IUSR_computername (which is used for web users anonymous access) does not have the correct permissions. That it needs permissions to not only read and write to the access db but to create the ldb file in the directory.
So from the advice of well reearched documents I...
Gave FULL CONTROL for IUSR_computername to:
1) the folder that the database is in
2) the database itself
3) the folder and files that my test script is in
But still I get the same error. I know that full control is a little drastic, but I figured that once I worked out what permissions that it needs, then I will restrict what it doesn't.
So I have know idea what the problem is. If there is a permission section somewhere else that I have missed, please let me know, I have been working on this for days, and only asked for help as a last resort.
Thanks for any advice that anyone can give me
HappyB