Dreamweaver - Operation must use an updateable query error...

Author

Operation must use an updateable query error...

Jenn S

2004-08-06, 4:15 am

Hi all,

Ok, I know this error is covered on the MM support site but I still can't
get it to work. I've always kept all of my sites on an external hard drive,
with write permissions set using localhost on my c drive to perform database
updates.without any problems.

Well now, I'm doing a demonstration at a client's location and thought it
would be better to move the site over to the c drive so that I wouldn't have
to worry about setting up the external drive. Of course it couldn't be that
easy. I'm getting the well known error: Operation must use an updateable
query. Here's an overview of what I did:

I set up a copy of my site at c:\MySite\website\

Using IIS I set up a virtual directory, with write permissions set for
everything (just in case). I double checked both the database file itself
and the database's parent folder. The directory is:
c:\inetpub\wwwroot\MySite\. I then had DW "upload" the files from the above
directory to this one.

I tried pointing the virtual directory to both folders, with no success. I
know that I read somewhere that the database needs to be under the wwwroot
directory but figured I'd give it a try.

I set up write permissions (actually full permissions, just in case) from
Windows Explorer under the security tab for all IUSR Users listed, for both
directories.

I also double checked to see that the database itself had write permissions,
thought I knew this couldn't be it because it works on the external drive.

I can't think of anything else to try. I know the error is in regards to
permissions but I followed all of the directions in both the MM Technote and
Microsoft's article and I still can't get it to work. It's been so long
since I set up a site directly on my c drive. I have more than a dozen
dynamic sites working fine on my external drive so it has to be with how I
set up my directories or permissions.

My DW Site Settings are:

Local Info:
Local root folder: c:\MySite\website\
Remote Info:
Access: Local/Network
Remote Folder: c:\inetpub\wwwroot\MySite\
Testing Server:
Access: Local/Network
Remote Folder: c:\inetpub\wwwroot\MySite\

I'm working on a WinXP machine using DWMX 2004. I'm using a DSNless
connection and an access database, that has a password set on it directly.
Again, I believe that has to do with how I set up the directories since all
works well on the external drive.

If anyone could point me in the right direction, or have any ideas on what
to try, I would appreciate it. I know it's probably something simple/stupid
that I'm missing. In the meantime I'm going to pull up the DW manual
(*gasp*)....if I can even find it.

Boy do I feel like a newbie with a problem like this!!

Thanks! Jenn

Jorgen

2004-08-06, 4:15 am

Hi,

Just a thought:
Can it be the Remote Testing Server info? Which should be in an absolute
format instead of a local one?

Grtz, Jorgen.

in article cev79r$ffh$1@forums.macromedia.com, Jenn S at
subscriptions@plumdropvisions.com wrote on 06-08-2004 08:08:

> Hi all,
>
> Ok, I know this error is covered on the MM support site but I still can't
> get it to work. I've always kept all of my sites on an external hard drive,
> with write permissions set using localhost on my c drive to perform database
> updates.without any problems.
>
> Well now, I'm doing a demonstration at a client's location and thought it
> would be better to move the site over to the c drive so that I wouldn't have
> to worry about setting up the external drive. Of course it couldn't be that
> easy. I'm getting the well known error: Operation must use an updateable
> query. Here's an overview of what I did:
>
> I set up a copy of my site at c:\MySite\website\
>
> Using IIS I set up a virtual directory, with write permissions set for
> everything (just in case). I double checked both the database file itself
> and the database's parent folder. The directory is:
> c:\inetpub\wwwroot\MySite\. I then had DW "upload" the files from the above
> directory to this one.
>
> I tried pointing the virtual directory to both folders, with no success. I
> know that I read somewhere that the database needs to be under the wwwroot
> directory but figured I'd give it a try.
>
> I set up write permissions (actually full permissions, just in case) from
> Windows Explorer under the security tab for all IUSR Users listed, for both
> directories.
>
> I also double checked to see that the database itself had write permissions,
> thought I knew this couldn't be it because it works on the external drive.
>
> I can't think of anything else to try. I know the error is in regards to
> permissions but I followed all of the directions in both the MM Technote and
> Microsoft's article and I still can't get it to work. It's been so long
> since I set up a site directly on my c drive. I have more than a dozen
> dynamic sites working fine on my external drive so it has to be with how I
> set up my directories or permissions.
>
> My DW Site Settings are:
>
> Local Info:
> Local root folder: c:\MySite\website\
> Remote Info:
> Access: Local/Network
> Remote Folder: c:\inetpub\wwwroot\MySite\
> Testing Server:
> Access: Local/Network
> Remote Folder: c:\inetpub\wwwroot\MySite\
>
> I'm working on a WinXP machine using DWMX 2004. I'm using a DSNless
> connection and an access database, that has a password set on it directly.
> Again, I believe that has to do with how I set up the directories since all
> works well on the external drive.
>
> If anyone could point me in the right direction, or have any ideas on what
> to try, I would appreciate it. I know it's probably something simple/stupid
> that I'm missing. In the meantime I'm going to pull up the DW manual
> (*gasp*)....if I can even find it.
>
> Boy do I feel like a newbie with a problem like this!!
>
> Thanks! Jenn
>
>

Julian Roberts

2004-08-06, 7:14 am

Try using an OLEDB connection

http://www.basic-ultradev.com/articles/ADOConnections/

Failing that, try creating a new blank database and importing data from old
one.

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

Jenn S

2004-08-07, 7:15 pm

Ok, everyone, I solved the problem (yippee!!) and it was all down to my own
confused idea of how to work with iis and virtual directories. I'll post the
answer, but first a couple of responses...

Jorgen, your suggestion was on the right track for what was causing the
problem. It was a problem with my site definitions.

Julian, I actually am using a OLEDB connection and the problem couldn't have
been corruption with the database because it would work fine on the external
drive. But thank you for taking the time to offer the suggestion. (p.s.
also, thanks for a wonderful website and great learning tools. Your site was
instrumental in my beginning days with dynamic sites...and I still visit for
a peek or two at a resource :) And it actually was your article on how to
create a virtual directory in iis that helped me realize what I was doing
wrong!!

So here's what worked:

I didn't set any details for Remote Server. I deleted them completely.
And I set up my Testing Server the same as my Local Info.

Now everything works perfectly.

It seems that my misunderstanding was that I needed to create a folder in
the wwwroot folder and point the virtual directory to that. So I gave IIS a
conflict. It had a folder in wwwroot called MySite AND a virtual directory,
with the same name and pointing to the same folder. Can't say it liked that
too much :)

So all is well in Jennifer Land and back to my lovely 20 hour days codin and
designin.

Thanks again Julian and Jorgen for helping out with such a newbie
question...I can still feel the shame!!

Jenn S

"Jenn S" <subscriptions@plumdropvisions.com> wrote in message
news:cev79r$ffh$1@forums.macromedia.com...
> Hi all,
>
> Ok, I know this error is covered on the MM support site but I still can't
> get it to work. I've always kept all of my sites on an external hard
drive,
> with write permissions set using localhost on my c drive to perform
database
> updates.without any problems.
>
> Well now, I'm doing a demonstration at a client's location and thought it
> would be better to move the site over to the c drive so that I wouldn't
have
> to worry about setting up the external drive. Of course it couldn't be
that
> easy. I'm getting the well known error: Operation must use an updateable
> query. Here's an overview of what I did:
>
> I set up a copy of my site at c:\MySite\website\
>
> Using IIS I set up a virtual directory, with write permissions set for
> everything (just in case). I double checked both the database file itself
> and the database's parent folder. The directory is:
> c:\inetpub\wwwroot\MySite\. I then had DW "upload" the files from the
above
> directory to this one.
>
> I tried pointing the virtual directory to both folders, with no success. I
> know that I read somewhere that the database needs to be under the wwwroot
> directory but figured I'd give it a try.
>
> I set up write permissions (actually full permissions, just in case) from
> Windows Explorer under the security tab for all IUSR Users listed, for
both
> directories.
>
> I also double checked to see that the database itself had write
permissions,
> thought I knew this couldn't be it because it works on the external drive.
>
> I can't think of anything else to try. I know the error is in regards to
> permissions but I followed all of the directions in both the MM Technote
and
> Microsoft's article and I still can't get it to work. It's been so long
> since I set up a site directly on my c drive. I have more than a dozen
> dynamic sites working fine on my external drive so it has to be with how I
> set up my directories or permissions.
>
> My DW Site Settings are:
>
> Local Info:
> Local root folder: c:\MySite\website\
> Remote Info:
> Access: Local/Network
> Remote Folder: c:\inetpub\wwwroot\MySite\
> Testing Server:
> Access: Local/Network
> Remote Folder: c:\inetpub\wwwroot\MySite\
>
> I'm working on a WinXP machine using DWMX 2004. I'm using a DSNless
> connection and an access database, that has a password set on it directly.
> Again, I believe that has to do with how I set up the directories since
all
> works well on the external drive.
>
> If anyone could point me in the right direction, or have any ideas on what
> to try, I would appreciate it. I know it's probably something
simple/stupid
> that I'm missing. In the meantime I'm going to pull up the DW manual
> (*gasp*)....if I can even find it.
>
> Boy do I feel like a newbie with a problem like this!!
>
> Thanks! Jenn
>
>