Web Sharing

[Guest]

I am running Win XP Pro. Microsoft Access XP, Dreamweaver MX 04.

I am working on the dynamic web site, which is to be connected to Access
Database located on the same computer. I have installed IIS on my computer to
be able to use it as server.

I have created my database connection and I can test this successfully on my
local machine. However when I try to test this on my testing server which is
the one which came with XP (IIS 5.1 I believe) I get the following error -
'Could not use; file already in use".

I know that the problem comes from the fact that I cannot set correct Web
Sharing settings for the folder where Access DB is located. By searching
forums, I was able to find solutions for Win NT, however it does not work for
Win XP. At the same time I have seen it working on Win XP before.

Does anyone have any suggestion on how to get Web Sharing Tab to appear or
any other way to see web sharing settings? Thanks a lot.

 

[Dana Brash]

Web Sharing just creates a Virtual Directory in IIS under the site that you
create it in. If you really need to do that, you can just manually set it
up. It is odd that your Web Sharing tab is not showing though.... But what
is your purpose in using Web Sharing at all? I would put the db in a
.../data folder and use code to open the connection locally, particularly
using an Access db.

Because you're using Access, you can only make one connection to the same db
at a time. Each IIS site will make one connection

I would recommend copying over the db to your testing server as well, and
make sure that the testing server has it's own DSN to connect to it. Make
sure the path for the DSN is correct.

--
HTH,
=d=


Dana Brash
MCSE, MCDBA, MCSA

(e-mail address removed)