I have included the snitz forum in my site and it all works fine on my local site. Upo uploading to my server and going to the front page in my browser it comes back with the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

/Forum/inc_functions.asp, line 716

Is this something I have done, or haven't done as the case may be?

Your help would be greatly apreciated.

Red Leader

I had some problems with snitz when I first uploaded as well.

I cant remember the error messages but have you done the following:

1. Ensure that the Database is not set to read only.

2. Run the Setup.asp page



Regards
Vince

Response.write("The best line of code you can ever use"

VBScript | ASP | HTML | SQL | Oracle | Hosting

I have run the setup and it is still happening. This may be me but I not sure of how to make my database anything other than read when uploading it in Dreamweaver - can you set permissions in dreamweaver?

Red Leader

Setting the database should be a case of right clicking on the file and ensuring that the 'make readable' option is greyed out.

Can you copy / paste Line 716 of inc_functions.asp (or the whole thing) to a message so I can see it.

Regards
Vince

Response.write("The best line of code you can ever use"

VBScript | ASP | HTML | SQL | Oracle | Hosting

heres line 716

my_conn.Execute (strSql)

cheers

Red Leader

if you have set a username / password on the access database you need to specify that in the connection, that could be a reason it is saying it cannot write,

are you using a DSN connection or are you specifying a direct path to the database?

Regards
Vince

Response.write("The best line of code you can ever use"

VBScript | ASP | HTML | SQL | Oracle | Hosting

its a DSN connection. There is no password on the database itself.

Red Leader

Let me speak to a coleague of mine, I will get back to you on this one.

Regards
Vince

Response.write("The best line of code you can ever use"

VBScript | ASP | HTML | SQL | Oracle | Hosting