Field is read-only -- Error

[sgci]

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?

[sgci]

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

[Newsgroup_User]

> 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?

[sgci]

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

[Newsgroup_User]

> 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.



Normally, I would advise against DSN and recommend an OLEDB connection, but
I've never used that type db, don't know if a string is possible.
www.connectionstrings.com does not show a string for it, so I can't help.
Sorry.