two dell pc's, alike in dignity, in fair london, where we lay
our scene....

From ancient grudge break to new mutiny, 'cos the 2nd one wont bloody work!

this is driving me mad! i had a disastrous crash on our speedy dell pc which
i use as my main development machine. after much mucking around i managged
to do a w2k reinstall in a new folder and get all my work off to a dog slow
pc that i'ev just installed w2k on.

now the dog slow one works a-ok. i literally set all the DSN's and
directories up and hey presto, up and running!

so i wipe the hard drive on the speedy pc and resinstall w2k. all good. then
my database's wont work. set up all the dsn's, all good.

i can search the information in the database but when i try and insert i get
this error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.
/jake/insert.asp, line 93

the sever configuration is exactly the same - the set up is exatly as it was
before the crash!!

I DONT GET IT AND I"M RUNNING OUT OF HAIR!!!!

please help??!!

cheers,

jake

Did you copy that database over to the other server with a CD?  Make
sure the database isn't read-only.

Erika Foster
Web Applications Developer
engineering-environmental Management (e2M)
xxx-xxx-xxxx


-----Original Message-----
From: jake williamson 28 [mailto:jake.williamson@2...] 
Sent: Wednesday, May 22, 2002 7:39 AM
To: Access ASP
Subject: [access_asp] two dell pc's, alike in dignity, in fair london,
where we lay our scene....


two dell pc's, alike in dignity, in fair london, where we lay
our scene....

From ancient grudge break to new mutiny, 'cos the 2nd one wont bloody
work!

this is driving me mad! i had a disastrous crash on our speedy dell pc
which
i use as my main development machine. after much mucking around i
managged
to do a w2k reinstall in a new folder and get all my work off to a dog
slow
pc that i'ev just installed w2k on.

now the dog slow one works a-ok. i literally set all the DSN's and
directories up and hey presto, up and running!

so i wipe the hard drive on the speedy pc and resinstall w2k. all good.
then
my database's wont work. set up all the dsn's, all good.

i can search the information in the database but when i try and insert i
get
this error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an
updateable
query.
/jake/insert.asp, line 93

the sever configuration is exactly the same - the set up is exatly as it
was
before the crash!!

I DONT GET IT AND I"M RUNNING OUT OF HAIR!!!!

please help??!!

cheers,

jake

 http://support.microsoft.com/default.aspx?scid=kb;EN-US;q175168

Jake, here is the Microsoft notice on this one--I've seen this before--
check permissions on the db directory, look at the dsn according to the
comments
in this support article from Microsoft.

Hope this helps.

Karri

-----Original Message-----
From: Erika Foster [mailto:efoster@e...]
Sent: Wednesday, May 22, 2002 8:55 AM
To: Access ASP
Subject: [access_asp] RE: two dell pc's, alike in dignity, in fair
london, where we lay our scene....


Did you copy that database over to the other server with a CD?  Make
sure the database isn't read-only.

Erika Foster
Web Applications Developer
engineering-environmental Management (e2M)
xxx-xxx-xxxx


-----Original Message-----
From: jake williamson 28 [mailto:jake.williamson@2...] 
Sent: Wednesday, May 22, 2002 7:39 AM
To: Access ASP
Subject: [access_asp] two dell pc's, alike in dignity, in fair london,
where we lay our scene....


two dell pc's, alike in dignity, in fair london, where we lay
our scene....

From ancient grudge break to new mutiny, 'cos the 2nd one wont bloody
work!

this is driving me mad! i had a disastrous crash on our speedy dell pc
which
i use as my main development machine. after much mucking around i
managged
to do a w2k reinstall in a new folder and get all my work off to a dog
slow
pc that i'ev just installed w2k on.

now the dog slow one works a-ok. i literally set all the DSN's and
directories up and hey presto, up and running!

so i wipe the hard drive on the speedy pc and resinstall w2k. all good.
then
my database's wont work. set up all the dsn's, all good.

i can search the information in the database but when i try and insert i
get
this error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an
updateable
query.
/jake/insert.asp, line 93

the sever configuration is exactly the same - the set up is exatly as it
was
before the crash!!

I DONT GET IT AND I"M RUNNING OUT OF HAIR!!!!

please help??!!

cheers,

jake

hey Karri,

thanks for getting back to me - i think i may have just found out what it
is.

baring in mind that both pc's have exactly the same installation on w2k and
access....

if i right click on the db file on one pc it just has one tab: General

the other pc, when i right click on the db file has THREE tabs:

General, Security and summary.

i went and changed the permissions on the Security tab for the 'Everyone'
name. it's write properties were set to no.

changing it to yes has fixed it!!

what i dont get is why the 2nd install has three tabs!

cheers,

jake



on 22/5/02 3:00 pm, Karri Peterson at KPeterson@C... wrote:

> 
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;q175168
> 
> Jake, here is the Microsoft notice on this one--I've seen this before--
> check permissions on the db directory, look at the dsn according to the
> comments
> in this support article from Microsoft.
> 
> Hope this helps.
> 
> Karri

so it was  a permssions but on the db file--cool.

Any good info/resources of W2K default
permissions behavior on install would really helpful--these
permissions things have other implications on dlls and other stuff.

Anyone got a good source on this kind of stuff?

Karri



-----Original Message-----
From: jake williamson 28 [mailto:jake.williamson@2...]
Sent: Wednesday, May 22, 2002 9:34 AM
To: Access ASP
Subject: [access_asp] RE: two dell pc's, alike in dignity, in fair lon
don, where we lay our scene....


hey Karri,

thanks for getting back to me - i think i may have just found out what it
is.

baring in mind that both pc's have exactly the same installation on w2k and
access....

if i right click on the db file on one pc it just has one tab: General

the other pc, when i right click on the db file has THREE tabs:

General, Security and summary.

i went and changed the permissions on the Security tab for the 'Everyone'
name. it's write properties were set to no.

changing it to yes has fixed it!!

what i dont get is why the 2nd install has three tabs!

cheers,

jake



on 22/5/02 3:00 pm, Karri Peterson at KPeterson@C... wrote:

> 
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;q175168
> 
> Jake, here is the Microsoft notice on this one--I've seen this before--
> check permissions on the db directory, look at the dsn according to the
> comments
> in this support article from Microsoft.
> 
> Hope this helps.
> 
> Karri

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "jake williamson 28" <jake.williamson@2...>
Subject: [access_asp] RE: two dell pc's, alike in dignity, in fair lon don,
where we lay our scene....


: if i right click on the db file on one pc it just has one tab: General
: the other pc, when i right click on the db file has THREE tabs:
:
: General, Security and summary.
:
: i went and changed the permissions on the Security tab for the 'Everyone'
: name. it's write properties were set to no.
:
: changing it to yes has fixed it!!
:
: what i dont get is why the 2nd install has three tabs!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Probaby because one partition (with only the 1 tab) is formatted as FAT or
FAT32, and the other partition (with 3 tabs) is formatted as NTFS.

NTFS partitions support file/folder level permissions (ie you can assign
permissions to individual folders/files to groups or individual user
accounts). You can't do that on FAT/FAT32 partitions.

You can use the convert.exe utility to convert a FAT partition to NTFS (or
use the Computer Management MMC Snapin).

Cheers
Ken

Gives a whole new meaning to, "Dude your gettin' a Dell."

The only thing that comes to mind is be sure the directory
and files are setup to allow access to proper people, validated
users or everyone however you wish to set it up.  Check the
status of DB file also.

Hopefully,
Chuck


>From: jake williamson 28 <jake.williamson@2...>
>Reply-To: "Access ASP" <access_asp@p...>
>To: "Access ASP" <access_asp@p...>
>Subject: [access_asp] two dell pc's, alike in dignity, in fair london, 
>where we lay our     scene....
>Date: Wed, 22 May 2002 14:38:42 +0100
>
>
>two dell pc's, alike in dignity, in fair london, where we lay
>our scene....
>
>From ancient grudge break to new mutiny, 'cos the 2nd one wont bloody work!
>
>this is driving me mad! i had a disastrous crash on our speedy dell pc 
>which
>i use as my main development machine. after much mucking around i managged
>to do a w2k reinstall in a new folder and get all my work off to a dog slow
>pc that i'ev just installed w2k on.
>
>now the dog slow one works a-ok. i literally set all the DSN's and
>directories up and hey presto, up and running!
>
>so i wipe the hard drive on the speedy pc and resinstall w2k. all good. 
>then
>my database's wont work. set up all the dsn's, all good.
>
>i can search the information in the database but when i try and insert i 
>get
>this error:
>
>Error Type:
>Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
>[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
>query.
>/jake/insert.asp, line 93
>
>the sever configuration is exactly the same - the set up is exatly as it 
>was
>before the crash!!
>
>I DONT GET IT AND I"M RUNNING OUT OF HAIR!!!!
>
>please help??!!
>
>cheers,
>
>jake
>
>




"If your not part of the solution,
there is good money to be made
prolonging the problem."


http://aa8vs.dhs.org:81/aa8vs


_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com

karri,

getting there, i keep hitting on problems (post on it's way to the list!)

but i found a very handy site for database errors, check out:

http://www.webwizguide.com/asp/faq/

and

http://www.webwizguide.com/asp/faq/server_permissions.asp

it's a confusing world in windows land....

cheers,

jake

on 22/5/02 4:01 pm, Karri Peterson at KPeterson@C... wrote:

> so it was  a permssions but on the db file--cool.
> 
> Any good info/resources of W2K default
> permissions behavior on install would really helpful--these
> permissions things have other implications on dlls and other stuff.
> 
> Anyone got a good source on this kind of stuff?
> 
> Karri
> 
> 
> 
> -----Original Message-----
> From: jake williamson 28 [mailto:jake.williamson@2...]
> Sent: Wednesday, May 22, 2002 9:34 AM
> To: Access ASP
> Subject: [access_asp] RE: two dell pc's, alike in dignity, in fair lon
> don, where we lay our scene....
> 
> 
> hey Karri,
> 
> thanks for getting back to me - i think i may have just found out what it
> is.
> 
> baring in mind that both pc's have exactly the same installation on w2k and
> access....
> 
> if i right click on the db file on one pc it just has one tab: General
> 
> the other pc, when i right click on the db file has THREE tabs:
> 
> General, Security and summary.
> 
> i went and changed the permissions on the Security tab for the 'Everyone'
> name. it's write properties were set to no.
> 
> changing it to yes has fixed it!!
> 
> what i dont get is why the 2nd install has three tabs!
> 
> cheers,
> 
> jake
> 
> 
> 
> on 22/5/02 3:00 pm, Karri Peterson at KPeterson@C... wrote:
> 
>> 
>> http://support.microsoft.com/default.aspx?scid=kb;EN-US;q175168
>> 
>> Jake, here is the Microsoft notice on this one--I've seen this before--
>> check permissions on the db directory, look at the dsn according to the
>> comments
>> in this support article from Microsoft.
>> 
>> Hope this helps.
>> 
>> Karri

ok, my hairs growing back, my pc is now running the NFTS file system and i'm
getting to grips with the new permissions things.

thank you all for your help, be lost with out ya!

but...

there's a real simple script that i've been using on a majority of my sites
as a hit counter (you may remember some of you helped me out with it a month
or so ago).

this is the code:

<%
' Setting variables
Dim con, sql_insert, data_source
data_source = "dsn=Ridgeback;"
sql_insert = "insert into HITS (SERVERADDRESS, BROWSER, OS, PAGE) values ('"
& Request.ServerVariables("SERVER_NAME") & "', '" &
Request.ServerVariables("HTTP_USER_AGENT") & "', '" &
Request.ServerVariables("HTTP_UA_OS") & "', 'contact')"
' Creating the Connection Object and opening the database
Set con = Server.CreateObject("ADODB.Connection")
con.Open data_source
' Executing the sql insertion code
con.Execute sql_insert
' Done. Now Close the connection
con.Close
Set con = Nothing
%>

only when i run the script now i get this error:

Could not use '(unknown)'; file already in use.

the error is in this line:

con.Open data_source

i dont get it! i'm sure it's related to this new permissions thing i'm
sorting out in my head but why file unknown??

a web search on http://www.webwizguide.com/asp/faq/access_database_faq.asp
says:

This is a bit of an odd error that I have never received myself but have
been asked about on number of occasions. It usually means that either
incorrect permissions are set on the server or the incorrect version of MDAC
(Microsoft Data Access Components installed on the server or the version is
not correctly installed). You need to ensure the ODBC version you have is 4
or greater.

but everythings up to date!!!

please help (again, i know, i'm sorry)

cheers,

jake

Appreciate it, Jake. 

Thanks.

Karri

-----Original Message-----
From: jake williamson 28 [mailto:jake.williamson@2...]
Sent: Friday, May 24, 2002 8:01 AM
To: Access ASP
Subject: [access_asp] RE: two dell pc's, alike in dignity, in fair lon
don, where we lay our scene....


karri,

getting there, i keep hitting on problems (post on it's way to the list!)

but i found a very handy site for database errors, check out:

http://www.webwizguide.com/asp/faq/

and

http://www.webwizguide.com/asp/faq/server_permissions.asp

it's a confusing world in windows land....

cheers,

jake

on 22/5/02 4:01 pm, Karri Peterson at KPeterson@C... wrote:

> so it was  a permssions but on the db file--cool.
> 
> Any good info/resources of W2K default
> permissions behavior on install would really helpful--these
> permissions things have other implications on dlls and other stuff.
> 
> Anyone got a good source on this kind of stuff?
> 
> Karri
> 
> 
> 
> -----Original Message-----
> From: jake williamson 28 [mailto:jake.williamson@2...]
> Sent: Wednesday, May 22, 2002 9:34 AM
> To: Access ASP
> Subject: [access_asp] RE: two dell pc's, alike in dignity, in fair lon
> don, where we lay our scene....
> 
> 
> hey Karri,
> 
> thanks for getting back to me - i think i may have just found out what it
> is.
> 
> baring in mind that both pc's have exactly the same installation on w2k
and
> access....
> 
> if i right click on the db file on one pc it just has one tab: General
> 
> the other pc, when i right click on the db file has THREE tabs:
> 
> General, Security and summary.
> 
> i went and changed the permissions on the Security tab for the 'Everyone'
> name. it's write properties were set to no.
> 
> changing it to yes has fixed it!!
> 
> what i dont get is why the 2nd install has three tabs!
> 
> cheers,
> 
> jake
> 
> 
> 
> on 22/5/02 3:00 pm, Karri Peterson at KPeterson@C... wrote:
> 
>> 
>> http://support.microsoft.com/default.aspx?scid=kb;EN-US;q175168
>> 
>> Jake, here is the Microsoft notice on this one--I've seen this before--
>> check permissions on the db directory, look at the dsn according to the
>> comments
>> in this support article from Microsoft.
>> 
>> Hope this helps.
>> 
>> Karri