"Operation must use an updateable query".- after conversion to NTFS

[Aaron [SQL Server MVP]]

You need to set NTFS permissions for IUSR (which weren't in place,
obviously, when using FAT32).

Right-click the folder, hit sharing and security, and on the security tab,
make sure IUSR_MachineName is there and has read/write/modify.

And stop using ODBC! [url]http://www.aspfaq.com/2126[/url]

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)




"only_me" <nospam.chris.bartley@ntlworld.com> wrote in message
news:oAbSc.537$Qs4.377@newsfe5-gui.ntli.net...

> Just converted one of my volumes to NTFS ( XP Pro),
> asp sites on that volume now give " Operation must use an updateable

query".

> asp sites on another drive which is still FAT32 still working OK
> So just a permissions thing between IIS and NTFS - but where ?
> TIA
>
>

[only_me]

Just converted one of my volumes to NTFS ( XP Pro),
asp sites on that volume now give " Operation must use an updateable query".
asp sites on another drive which is still FAT32 still working OK
So just a permissions thing between IIS and NTFS - but where ?
TIA

[only_me]

No security tab seen ?
just sharing and web sharing ( and general and customise)
in web sharing - I set share this folder and enabled write permissions since
it wasn't already set
No change !

"Stop using ODBC" - I'm not, I'm using OLDB AFAIK
i.e. "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=........"

apologies in advance for another thread posted with same question -

"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:ez5u06xfEHA.2604@TK2MSFTNGP10.phx.gbl...

> You need to set NTFS permissions for IUSR (which weren't in place,
> obviously, when using FAT32).
>
> Right-click the folder, hit sharing and security, and on the security tab,
> make sure IUSR_MachineName is there and has read/write/modify.
>
> And stop using ODBC! [url]http://www.aspfaq.com/2126[/url]
>
> --
> [url]http://www.aspfaq.com/[/url]
> (Reverse address to reply.)
>
>
>
>
> "only_me" <nospam.chris.bartley@ntlworld.com> wrote in message
> news:oAbSc.537$Qs4.377@newsfe5-gui.ntli.net...

> > Just converted one of my volumes to NTFS ( XP Pro),
> > asp sites on that volume now give " Operation must use an updateable

> query".

> > asp sites on another drive which is still FAT32 still working OK
> > So just a permissions thing between IIS and NTFS - but where ?
> > TIA
> >
> >

>
>

[joker]

Disable simple file & printer sharing. If you have XP Home you need to
boot into safe mode to do this. It will only be disabled while you are
in safe mode so the changes may not take effect. IF you are running XP
Home I strongly urge you to upgrade to XP Pro.

I am glad though you are smart enough to have stopped using ODBC. I
think he posted that because so many people who post here have no idea
that it's a very bad idea to use ODBC.

only_me wrote:

> No security tab seen ?
> just sharing and web sharing ( and general and customise)
> in web sharing - I set share this folder and enabled write permissions since
> it wasn't already set
> No change !
>
> "Stop using ODBC" - I'm not, I'm using OLDB AFAIK
> i.e. "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=........"
>
> apologies in advance for another thread posted with same question -
>
> "Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
> news:ez5u06xfEHA.2604@TK2MSFTNGP10.phx.gbl...
>

>>You need to set NTFS permissions for IUSR (which weren't in place,
>>obviously, when using FAT32).
>>
>>Right-click the folder, hit sharing and security, and on the security tab,
>>make sure IUSR_MachineName is there and has read/write/modify.
>>
>>And stop using ODBC! [url]http://www.aspfaq.com/2126[/url]
>>
>>--
>>[url]http://www.aspfaq.com/[/url]
>>(Reverse address to reply.)
>>
>>
>>
>>
>>"only_me" <nospam.chris.bartley@ntlworld.com> wrote in message
>>news:oAbSc.537$Qs4.377@newsfe5-gui.ntli.net...
>>

>>>Just converted one of my volumes to NTFS ( XP Pro),
>>>asp sites on that volume now give " Operation must use an updateable

>>
>>query".
>>

>>>asp sites on another drive which is still FAT32 still working OK
>>>So just a permissions thing between IIS and NTFS - but where ?
>>>TIA
>>>
>>>

>>
>>

>
>

[only_me]

I'm using XP pro,
I just uninstalled "file & printer sharing" ( not simple ?)
But that didn't change the tabs available when right clicking on the folder

"joker" <no-spam@netzero.com> wrote in message
news:u5KUvm3fEHA.4040@TK2MSFTNGP10.phx.gbl...

> Disable simple file & printer sharing. If you have XP Home you need to
> boot into safe mode to do this. It will only be disabled while you are
> in safe mode so the changes may not take effect. IF you are running XP
> Home I strongly urge you to upgrade to XP Pro.
>
> I am glad though you are smart enough to have stopped using ODBC. I
> think he posted that because so many people who post here have no idea
> that it's a very bad idea to use ODBC.
>
> only_me wrote:
>

> > No security tab seen ?
> > just sharing and web sharing ( and general and customise)
> > in web sharing - I set share this folder and enabled write permissions

since

> > it wasn't already set
> > No change !
> >
> > "Stop using ODBC" - I'm not, I'm using OLDB AFAIK
> > i.e. "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=........"
> >
> > apologies in advance for another thread posted with same question -
> >
> > "Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
> > news:ez5u06xfEHA.2604@TK2MSFTNGP10.phx.gbl...
> >

> >>You need to set NTFS permissions for IUSR (which weren't in place,
> >>obviously, when using FAT32).
> >>
> >>Right-click the folder, hit sharing and security, and on the security

tab,

> >>make sure IUSR_MachineName is there and has read/write/modify.
> >>
> >>And stop using ODBC! [url]http://www.aspfaq.com/2126[/url]
> >>
> >>--
> >>[url]http://www.aspfaq.com/[/url]
> >>(Reverse address to reply.)
> >>
> >>
> >>
> >>
> >>"only_me" <nospam.chris.bartley@ntlworld.com> wrote in message
> >>news:oAbSc.537$Qs4.377@newsfe5-gui.ntli.net...
> >>
> >>>Just converted one of my volumes to NTFS ( XP Pro),
> >>>asp sites on that volume now give " Operation must use an updateable
> >>
> >>query".
> >>
> >>>asp sites on another drive which is still FAT32 still working OK
> >>>So just a permissions thing between IIS and NTFS - but where ?
> >>>TIA
> >>>
> >>>
> >>
> >>

> >
> >

>

[only_me]

OK - found it !
Needed "file & printer sharing" loaded
It was in the "sharing" tab - under "network sharing and security"
checked both the "share" and "allows users to change" checkboxes

"only_me" <only_me@hotmail.com> wrote in message
news:eGQkVI4fEHA.3944@tk2msftngp13.phx.gbl...

> I'm using XP pro,
> I just uninstalled "file & printer sharing" ( not simple ?)
> But that didn't change the tabs available when right clicking on the

folder

>
> "joker" <no-spam@netzero.com> wrote in message
> news:u5KUvm3fEHA.4040@TK2MSFTNGP10.phx.gbl...

> > Disable simple file & printer sharing. If you have XP Home you need to
> > boot into safe mode to do this. It will only be disabled while you are
> > in safe mode so the changes may not take effect. IF you are running XP
> > Home I strongly urge you to upgrade to XP Pro.
> >
> > I am glad though you are smart enough to have stopped using ODBC. I
> > think he posted that because so many people who post here have no idea
> > that it's a very bad idea to use ODBC.
> >
> > only_me wrote:
> >

> > > No security tab seen ?
> > > just sharing and web sharing ( and general and customise)
> > > in web sharing - I set share this folder and enabled write permissions

> since

> > > it wasn't already set
> > > No change !
> > >
> > > "Stop using ODBC" - I'm not, I'm using OLDB AFAIK
> > > i.e. "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=........"
> > >
> > > apologies in advance for another thread posted with same question -
> > >
> > > "Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
> > > news:ez5u06xfEHA.2604@TK2MSFTNGP10.phx.gbl...
> > >
> > >>You need to set NTFS permissions for IUSR (which weren't in place,
> > >>obviously, when using FAT32).
> > >>
> > >>Right-click the folder, hit sharing and security, and on the security

> tab,

> > >>make sure IUSR_MachineName is there and has read/write/modify.
> > >>
> > >>And stop using ODBC! [url]http://www.aspfaq.com/2126[/url]
> > >>
> > >>--
> > >>[url]http://www.aspfaq.com/[/url]
> > >>(Reverse address to reply.)
> > >>
> > >>
> > >>
> > >>
> > >>"only_me" <nospam.chris.bartley@ntlworld.com> wrote in message
> > >>news:oAbSc.537$Qs4.377@newsfe5-gui.ntli.net...
> > >>
> > >>>Just converted one of my volumes to NTFS ( XP Pro),
> > >>>asp sites on that volume now give " Operation must use an updateable
> > >>
> > >>query".
> > >>
> > >>>asp sites on another drive which is still FAT32 still working OK
> > >>>So just a permissions thing between IIS and NTFS - but where ?
> > >>>TIA
> > >>>
> > >>>
> > >>
> > >>
> > >
> > >

> >

>
>

[Aaron [SQL Server MVP]]

[url]http://www.aspfaq.com/2205[/url]

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)




"only_me" <only_me@hotmail.com> wrote in message
news:u0AiNQ4fEHA.2848@TK2MSFTNGP10.phx.gbl...

> OK - found it !
> Needed "file & printer sharing" loaded
> It was in the "sharing" tab - under "network sharing and security"
> checked both the "share" and "allows users to change" checkboxes
>
> "only_me" <only_me@hotmail.com> wrote in message
> news:eGQkVI4fEHA.3944@tk2msftngp13.phx.gbl...

> > I'm using XP pro,
> > I just uninstalled "file & printer sharing" ( not simple ?)
> > But that didn't change the tabs available when right clicking on the

> folder

> >
> > "joker" <no-spam@netzero.com> wrote in message
> > news:u5KUvm3fEHA.4040@TK2MSFTNGP10.phx.gbl...

> > > Disable simple file & printer sharing. If you have XP Home you need

to

> > > boot into safe mode to do this. It will only be disabled while you

are

> > > in safe mode so the changes may not take effect. IF you are running

XP

> > > Home I strongly urge you to upgrade to XP Pro.
> > >
> > > I am glad though you are smart enough to have stopped using ODBC. I
> > > think he posted that because so many people who post here have no idea
> > > that it's a very bad idea to use ODBC.
> > >
> > > only_me wrote:
> > >
> > > > No security tab seen ?
> > > > just sharing and web sharing ( and general and customise)
> > > > in web sharing - I set share this folder and enabled write

permissions

> > since

> > > > it wasn't already set
> > > > No change !
> > > >
> > > > "Stop using ODBC" - I'm not, I'm using OLDB AFAIK
> > > > i.e. "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=........"
> > > >
> > > > apologies in advance for another thread posted with same question -
> > > >
> > > > "Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
> > > > news:ez5u06xfEHA.2604@TK2MSFTNGP10.phx.gbl...
> > > >
> > > >>You need to set NTFS permissions for IUSR (which weren't in place,
> > > >>obviously, when using FAT32).
> > > >>
> > > >>Right-click the folder, hit sharing and security, and on the

security

> > tab,

> > > >>make sure IUSR_MachineName is there and has read/write/modify.
> > > >>
> > > >>And stop using ODBC! [url]http://www.aspfaq.com/2126[/url]
> > > >>
> > > >>--
> > > >>[url]http://www.aspfaq.com/[/url]
> > > >>(Reverse address to reply.)
> > > >>
> > > >>
> > > >>
> > > >>
> > > >>"only_me" <nospam.chris.bartley@ntlworld.com> wrote in message
> > > >>news:oAbSc.537$Qs4.377@newsfe5-gui.ntli.net...
> > > >>
> > > >>>Just converted one of my volumes to NTFS ( XP Pro),
> > > >>>asp sites on that volume now give " Operation must use an

updateable

> > > >>
> > > >>query".
> > > >>
> > > >>>asp sites on another drive which is still FAT32 still working OK
> > > >>>So just a permissions thing between IIS and NTFS - but where ?
> > > >>>TIA
> > > >>>
> > > >>>
> > > >>
> > > >>
> > > >
> > > >
> > >

> >
> >

>
>