Multiple db connections on NTFS

I've just migrated my web development from Windows 2000 Pro to Windows
2000 Server. The file format on the W2K Pro was FAT32, while the W2K
Server is NTFS. Using IIS for the web server for both. I'm now
having trouble with multiple simultaneous connections to the ACCESS
database, using the JET engine USING ADODB Connection (not DSN). I
believe it is something to do with setting permissions for multiple
simultaneous db connections on W2K Server for the NTFS file system.
If I move the web from the NTFS drive to a FAT 32 drive on the W2K
server, it will allow multiple simultaneous connections (eg: the web
can connect with the database while ACCESS has the db open, not with
exclusive lock as when ACCESS has the Design feature open, or two
classes can connect simultaneously and use the db) as I had on the W2K
Pro box. IF anyone can give me a steer on this (is it the permissions
for W2K/NTFS, how to set, etc), I'd very much appreciate it. TIA.

Re: Multiple db connections on NTFS

On Sun, 14 Nov 2004 17:03:43 -0500, a new guy <> wrote:

>I've just migrated my web development from Windows 2000 Pro to Windows
>2000 Server. The file format on the W2K Pro was FAT32, while the W2K
>Server is NTFS. Using IIS for the web server for both. I'm now
>having trouble with multiple simultaneous connections to the ACCESS
>database, using the JET engine USING ADODB Connection (not DSN). I
>believe it is something to do with setting permissions for multiple
>simultaneous db connections on W2K Server for the NTFS file system.
>If I move the web from the NTFS drive to a FAT 32 drive on the W2K
>server, it will allow multiple simultaneous connections (eg: the web
>can connect with the database while ACCESS has the db open, not with
>exclusive lock as when ACCESS has the Design feature open, or two
>classes can connect simultaneously and use the db) as I had on the W2K
>Pro box. IF anyone can give me a steer on this (is it the permissions
>for W2K/NTFS, how to set, etc), I'd very much appreciate it. TIA.

Might help if you detailed why you think it isn't working. Are you
getting errors, and if so, what errors?

Jeff

Re: Multiple db connections on NTFS

thanks for the interest and help, sorry for omitting the error.
Here's the error message I get on IE:

Error Type:
Microsoft JET Database Engine (0x80004005)
Could not use ''; file already in use.
/homenet/_Class/incCls.asp, line 29

The incCls.asp in an include containing the class files.

If I move the web from an NTFS drive to a FAT32 drive the error does
not occur. Thanks again for the interst and any help.

On Sun, 14 Nov 2004 22:27:54 GMT, jeff.nospam@zina.com (Jeff Cochran)
wrote:

>On Sun, 14 Nov 2004 17:03:43 -0500, a new guy <> wrote:
>
>>I've just migrated my web development from Windows 2000 Pro to Windows
>>2000 Server. The file format on the W2K Pro was FAT32, while the W2K
>>Server is NTFS. Using IIS for the web server for both. I'm now
>>having trouble with multiple simultaneous connections to the ACCESS
>>database, using the JET engine USING ADODB Connection (not DSN). I
>>believe it is something to do with setting permissions for multiple
>>simultaneous db connections on W2K Server for the NTFS file system.
>>If I move the web from the NTFS drive to a FAT 32 drive on the W2K
>>server, it will allow multiple simultaneous connections (eg: the web
>>can connect with the database while ACCESS has the db open, not with
>>exclusive lock as when ACCESS has the Design feature open, or two
>>classes can connect simultaneously and use the db) as I had on the W2K
>>Pro box. IF anyone can give me a steer on this (is it the permissions
>>for W2K/NTFS, how to set, etc), I'd very much appreciate it. TIA.
>
>Might help if you detailed why you think it isn't working. Are you
>getting errors, and if so, what errors?
>
>Jeff

Re: Multiple db connections on NTFS

Permissions.
You can look your error up here: http://www.aspfaq.com/show.asp?id=2009, but
the bottom line is that all users of the database need read/write permission
(file-system, not IIS) for the folder containing the database. In IIS, that
means granting the IUSR and IWAM accounts Modify permission on that folder.

Bob Barrows

a new guy wrote:
> thanks for the interest and help, sorry for omitting the error.
> Here's the error message I get on IE:
>
> Error Type:
> Microsoft JET Database Engine (0x80004005)
> Could not use ''; file already in use.
> /homenet/_Class/incCls.asp, line 29
>
> The incCls.asp in an include containing the class files.
>
> If I move the web from an NTFS drive to a FAT32 drive the error does
> not occur. Thanks again for the interst and any help.
>
> On Sun, 14 Nov 2004 22:27:54 GMT, jeff.nospam@zina.com (Jeff Cochran)
> wrote:
>
>> On Sun, 14 Nov 2004 17:03:43 -0500, a new guy <> wrote:
>>
>>> I've just migrated my web development from Windows 2000 Pro to
>>> Windows 2000 Server. The file format on the W2K Pro was FAT32,
>>> while the W2K Server is NTFS. Using IIS for the web server for
>>> both. I'm now having trouble with multiple simultaneous
>>> connections to the ACCESS database, using the JET engine USING
>>> ADODB Connection (not DSN). I believe it is something to do with
>>> setting permissions for multiple simultaneous db connections on W2K
>>> Server for the NTFS file system. If I move the web from the NTFS
>>> drive to a FAT 32 drive on the W2K server, it will allow multiple
>>> simultaneous connections (eg: the web can connect with the database
>>> while ACCESS has the db open, not with exclusive lock as when
>>> ACCESS has the Design feature open, or two classes can connect
>>> simultaneously and use the db) as I had on the W2K Pro box. IF
>>> anyone can give me a steer on this (is it the permissions for
>>> W2K/NTFS, how to set, etc), I'd very much appreciate it. TIA.
>>
>> Might help if you detailed why you think it isn't working. Are you
>> getting errors, and if so, what errors?
>>
>> Jeff

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"