Not sure this is right forum, but here goes:

 

Runnins IIS (personal web server) and trying to update Access 2003 database

via perl script using the following:

 

$DSN = "Test";

use Win32::ODBC;

$db = new win32::ODBC($DSN);

$db->sql("select * from SiteVisits where script_name = "counter" ");

 

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."

 

As best I can determine tll files/databases have "full" permissions.

 

Help!!!

 

If this is not the correct forum please direct me to the correct one. Thanks.

This attempt nets the following error:

For updating, adding, deleting, the "IUSER<machine name>"

anonymous Internet User account must have "change" permission for either the

folder containing the database, or the database file itself. This is a

permission setting that is not configurable through IIS.

 

Please check the permissions for IUser account.

 

Thanks,

Obaid.

 

 

"wmitty" wrote:

> Not sure this is right forum, but here goes:

>

> Runnins IIS (personal web server) and trying to update Access 2003 database

> via perl script using the following:

>

> $DSN = "Test";

> use Win32::ODBC;

> $db = new win32::ODBC($DSN);

> $db->sql("select * from SiteVisits where script_name = "counter" ");

>

> 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."

>

> As best I can determine tll files/databases have "full" permissions.

>

> Help!!!

>

> If this is not the correct forum please direct me to the correct one. Thanks.

> This attempt nets the following error:

>

>

>

>

Obaid, thanks for the input, but I'm not quite sure ow to change the

permissions for "IUSR?". Anyway, this problem seems to occur ONLY when I use

an SSI (Server Side Include) such as: <!-- #exec

cgi="/cgi-bin/perl/execute_script.pl" -->

???

 

"Obaid" wrote:

> For updating, adding, deleting, the "IUSER<machine name>"

> anonymous Internet User account must have "change" permission for either the

> folder containing the database, or the database file itself. This is a

> permission setting that is not configurable through IIS.

>

> Please check the permissions for IUser account.

>

> Thanks,

> Obaid.

>

>

> "wmitty" wrote:

>

> > Not sure this is right forum, but here goes:

> >

> > Runnins IIS (personal web server) and trying to update Access 2003 database

> > via perl script using the following:

> >

> > $DSN = "Test";

> > use Win32::ODBC;

> > $db = new win32::ODBC($DSN);

> > $db->sql("select * from SiteVisits where script_name = "counter" ");

> >

> > 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."

> >

> > As best I can determine tll files/databases have "full" permissions.

> >

> > Help!!!

> >

> > If this is not the correct forum please direct me to the correct one. Thanks.

> > This attempt nets the following error:

> >

> >

> >

> >

Hi,

 

In Windows Explorer, navigate to the appropriate folder and right

click it, choose Properties, then the Security tab. Either add the

anonymous user account or click on it if it exists, and place check

marks in the appropriate boxes. Normally MODIFY will do it.

 

Hope that helps.

Thanks,

Obaid.

 

 

"wmitty" wrote:

> Obaid, thanks for the input, but I'm not quite sure ow to change the

> permissions for "IUSR?". Anyway, this problem seems to occur ONLY when I use

> an SSI (Server Side Include) such as: <!-- #exec

> cgi="/cgi-bin/perl/execute_script.pl" -->

> ???

>

> "Obaid" wrote:

>

> > For updating, adding, deleting, the "IUSER<machine name>"

> > anonymous Internet User account must have "change" permission for either the

> > folder containing the database, or the database file itself. This is a

> > permission setting that is not configurable through IIS.

> >

> > Please check the permissions for IUser account.

> >

> > Thanks,

> > Obaid.

> >

> >

> > "wmitty" wrote:

> >

> > > Not sure this is right forum, but here goes:

> > >

> > > Runnins IIS (personal web server) and trying to update Access 2003 database

> > > via perl script using the following:

> > >

> > > $DSN = "Test";

> > > use Win32::ODBC;

> > > $db = new win32::ODBC($DSN);

> > > $db->sql("select * from SiteVisits where script_name = "counter" ");

> > >

> > > 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."

> > >

> > > As best I can determine tll files/databases have "full" permissions.

> > >

> > > Help!!!

> > >

> > > If this is not the correct forum please direct me to the correct one. Thanks.

> > > This attempt nets the following error:

> > >

> > >

> > >

> > >

Are you saying that you can run it as a CGI, Walt? Obaid's solution will

fix the problem if it is because the anonymous user doesn't have

permissions to access the database. The web service runs as the

anonymous user (loosely speaking). It's suspicious that the file name is

given as 'unknown'.

 

Cheers,

 

Cliff

 

wmitty wrote:

> Obaid, thanks for the input, but I'm not quite sure ow to change the

> permissions for "IUSR?". Anyway, this problem seems to occur ONLY when I use

> an SSI (Server Side Include) such as: <!-- #exec

> cgi="/cgi-bin/perl/execute_script.pl" -->

> ???

>

> "Obaid" wrote:

>

>> For updating, adding, deleting, the "IUSER<machine name>"

>> anonymous Internet User account must have "change" permission for either the

>> folder containing the database, or the database file itself. This is a

>> permission setting that is not configurable through IIS.

>>

>> Please check the permissions for IUser account.

>>

>> Thanks,

>> Obaid.

>>

>>

>> "wmitty" wrote:

>>

>>> Not sure this is right forum, but here goes:

>>>

>>> Runnins IIS (personal web server) and trying to update Access 2003 database

>>> via perl script using the following:

>>>

>>> $DSN = "Test";

>>> use Win32::ODBC;

>>> $db = new win32::ODBC($DSN);

>>> $db->sql("select * from SiteVisits where script_name = "counter" ");

>>>

>>> 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."

>>>

>>> As best I can determine tll files/databases have "full" permissions.

>>>

>>> Help!!!

>>>

>>> If this is not the correct forum please direct me to the correct one. Thanks.

>>> This attempt nets the following error:

>>>

>>>

>>>

>>>

 

 

--

 

Have you ever noticed that if something is advertised as 'amusing' or

'hilarious', it usually isn't?

Problem Solved !!!

 

I changed a kzillion permissions, both users (IUSR and others using this

computer) and catabase/files. Wha la! The d*&% thing started to work.

THANKS for y'all's inputs . . .

 

"Enkidu" wrote:

>

> Are you saying that you can run it as a CGI, Walt? Obaid's solution will

> fix the problem if it is because the anonymous user doesn't have

> permissions to access the database. The web service runs as the

> anonymous user (loosely speaking). It's suspicious that the file name is

> given as 'unknown'.

>

> Cheers,

>

> Cliff

>

> wmitty wrote:

> > Obaid, thanks for the input, but I'm not quite sure ow to change the

> > permissions for "IUSR?". Anyway, this problem seems to occur ONLY when I use

> > an SSI (Server Side Include) such as: <!-- #exec

> > cgi="/cgi-bin/perl/execute_script.pl" -->

> > ???

> >

> > "Obaid" wrote:

> >

> >> For updating, adding, deleting, the "IUSER<machine name>"

> >> anonymous Internet User account must have "change" permission for either the

> >> folder containing the database, or the database file itself. This is a

> >> permission setting that is not configurable through IIS.

> >>

> >> Please check the permissions for IUser account.

> >>

> >> Thanks,

> >> Obaid.

> >>

> >>

> >> "wmitty" wrote:

> >>

> >>> Not sure this is right forum, but here goes:

> >>>

> >>> Runnins IIS (personal web server) and trying to update Access 2003 database

> >>> via perl script using the following:

> >>>

> >>> $DSN = "Test";

> >>> use Win32::ODBC;

> >>> $db = new win32::ODBC($DSN);

> >>> $db->sql("select * from SiteVisits where script_name = "counter" ");

> >>>

> >>> 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."

> >>>

> >>> As best I can determine tll files/databases have "full" permissions.

> >>>

> >>> Help!!!

> >>>

> >>> If this is not the correct forum please direct me to the correct one. Thanks.

> >>> This attempt nets the following error:

> >>>

> >>>

> >>>

> >>>

>

>

> --

>

> Have you ever noticed that if something is advertised as 'amusing' or

> 'hilarious', it usually isn't?

>

Thank you for your feedback.

 

Glad we could help.

--

Thanks,

Obaid.

 

 

"wmitty" wrote:

> Not sure this is right forum, but here goes:

>

> Runnins IIS (personal web server) and trying to update Access 2003 database

> via perl script using the following:

>

> $DSN = "Test";

> use Win32::ODBC;

> $db = new win32::ODBC($DSN);

> $db->sql("select * from SiteVisits where script_name = "counter" ");

>

> 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."

>

> As best I can determine tll files/databases have "full" permissions.

>

> Help!!!

>

> If this is not the correct forum please direct me to the correct one. Thanks.

> This attempt nets the following error:

>

>

>

>