unable to connect to access database using win32::ODBC

[wmitty]

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]

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:
>
>
>
>

 

[wmitty]

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:
> >
> >
> >
> >

 

[Obaid]

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:
> > >
> > >
> > >
> > >

 

[Enkidu]

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?

 

[wmitty]

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?
>

 

[Obaid]

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:
>
>
>
>