Skip to main content
S
sgci
Participant
July 10, 2008
Question

Field is read-only -- Error

  • July 10, 2008
  • 2 replies
  • 427 views
Using ASP vbscript, I created a small query to test one of my db connections, requesting three fields from a specified record based on URL parameter (this is a different project than my previous post) running IIS with an ODBC connection to a local db. The ODBC driver is read-only, which is fine, the purpose of this project is to display reports, not data entry. Anyway, when I test the query in DW CS3, everything is good, I get the results as expected. When I upload the page to the remote server and test the page I get:

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

Technical Information (for support personnel)

* Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
Field is read-only
/job_details.asp, line 21

I am not updating or inserting, so I do not understand this error. I also can't find anything on this specific error anywhere. Anyone got any ideas about where I should start looking?
This topic has been closed for replies.

2 replies

N
Newsgroup_User
Inspiring
July 10, 2008
> HTTP 500.100 - Internal Server Error - ASP error
> Internet Information Services
>
> Technical Information (for support personnel)
>
> * Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
> Field is read-only
> /job_details.asp, line 21
>
> I am not updating or inserting, so I do not understand this error. I also
> can't find anything on this specific error anywhere. Anyone got any ideas
> about where I should start looking?


That is somewhat queer, and I don't understand. Are you using a connection
string or a DSN?

S
sgciAuthor
Participant
July 10, 2008
Hi Ted,

It is using a DSN. I have never used this particular ODBC driver or this type of database before (Omnis), so I don't know if the problem was driver specific. All I know is that it works fine if I bypass the parameter append.

Now if I could just get the connection to work with cross-platform servers. In the above example, I put a copy of my datafile on the same machine that the web server is running on ... and it's working. But when I try to connect to the live db, which resides on a mac osx server I get :

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Unable to read disk (bad disk)
/job_details.asp, line 16

But I can use the same ODBC connection from MSAccess on the Windows machine and get query results.

arrrggghhhh!
Greg
S
sgciAuthor
Participant
July 10, 2008
Forget it. I think I figured it out. It has something to do with the way DW appends the parameter to the querystring. If I comment out those lines, and hard code the value I am filtering on ... works like I want it to.

Greg
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices