| | |
IIS connection will not write data
Please support our ASP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
•
•
Join Date: Jul 2004
Posts: 2
Reputation:
Solved Threads: 0
I can recieve data into my .asp pages from my access database but when I try to write to the db I get the following errormessage
:
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
--------------------------------------------------------------------------------
Technical Information (for support personnel)
Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/NewMembResp.asp, line 11
This must a common problem. Any advice much appreciated
:
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
--------------------------------------------------------------------------------
Technical Information (for support personnel)
Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/NewMembResp.asp, line 11
This must a common problem. Any advice much appreciated
Chris, I'd need to see the code segment (line 11 - /NewMembResp.asp) or similar code segment that is generating this error.
Some quick thoughts: make sure the data types of the fields in your database tables match the data types of the values you're trying to write to the corresponding fields in the table(s). Also, make sure that the table and field names you are referencing in your source code exactly match those in your database.
Some quick thoughts: make sure the data types of the fields in your database tables match the data types of the values you're trying to write to the corresponding fields in the table(s). Also, make sure that the table and field names you are referencing in your source code exactly match those in your database.
•
•
•
•
Originally Posted by Chris Norton
I can recieve data into my .asp pages from my access database but when I try to write to the db I get the following errormessage
:
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
--------------------------------------------------------------------------------
Technical Information (for support personnel)
Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/NewMembResp.asp, line 11
This must a common problem. Any advice much appreciated
•
•
Join Date: Jul 2004
Posts: 32
Reputation:
Solved Threads: 1
I think if you posted the fields in your DB, along with their TYPE and your ASP code, we'll wrap this up in no time.
•
•
Join Date: Jul 2004
Posts: 2
Reputation:
Solved Threads: 0
•
•
•
•
Originally Posted by brob5000
Chris, I'd need to see the code segment (line 11 - /NewMembResp.asp) or similar code segment that is generating this error.
Some quick thoughts: make sure the data types of the fields in your database tables match the data types of the values you're trying to write to the corresponding fields in the table(s). Also, make sure that the table and field names you are referencing in your source code exactly match those in your database.
•
•
Join Date: Jul 2004
Posts: 32
Reputation:
Solved Threads: 1
Thats a weird error to get for a permissions error... normally the error you get is this:-
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only
OR
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x6f8 Thread 0x5ec DBC 0x224603c Jet'.
OR most commonly:
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
I'll add your one to memory for future puzzlement.
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only
OR
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x6f8 Thread 0x5ec DBC 0x224603c Jet'.
OR most commonly:
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
I'll add your one to memory for future puzzlement.
•
•
Join Date: Nov 2004
Posts: 1
Reputation:
Solved Threads: 0
•
•
•
•
Originally Posted by Chris Norton
Problem fixed. It was caused by permissions in IUSR set to read only Thanks anyway
Here is the error I got:
The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed.
--------------------------------------------------------------------------------
Please try the following:
Click the Refresh button, or try again later.
Open the localhost: home page, and then look for links to the information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
--------------------------------------------------------------------------------
Technical Information (for support personnel)
Error Type:
Provider (0x80004005)
Unspecified error
/urmc/deleteEvent.asp, line 9
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322)
Page:
POST 57 bytes to /urmc/deleteEvent.asp
POST Data:
DeleteEvent=24&DeleteEvent=23&DeleteEvent=20&Process=True
Time:
Tuesday, November 16, 2004, 3:25:33 PM
More information:
Microsoft Support
To change permissions on a folder/file open explorer and navigate to the folder/file. Right Click and select Properties, then open the Security tab. Check in the Group or User Names window for Internet Guest Account. If it is there then select it and in the Permissions window select the Read and Execute, Read, Write boxes. If the Internet Guest Account isn't in the User Names window you will need to Add it. Select Add and enter IUSR_computername in the Object Name area. Make sure to replace computername with the name of your computer. Set the permissions and Apply.
If I've been a help please confirm by clicking the Add to Lafinboy's Reputation link in the header of this reply.
Lafinboy Productions
:: Website Design :: Website Development ::
Lafinboy Productions
:: Website Design :: Website Development ::
![]() |
Similar Threads
Other Threads in the ASP Forum
- Previous Thread: Pretty urgent but not too hard (i think)...
- Next Thread: sports score feeds
| Thread Tools | Search this Thread |
archive asp asp.net aspandmssqlserver2005 aspandmssqlserver2005connection aspconnection connection database databaseconnection dreamweaver excel fso iis msmsql mssql2005 mssqlserver2005 mssqlserver2005andasp mssqlserverandasp opentextfile record searchbox selectoption single specfic sqlserver sqlserverconnection windows7





