User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the ASP section within the Web Development category of DaniWeb, a massive community of 392,085 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,922 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ASP advertiser: Lunarpages ASP Web Hosting
Views: 12235 | Replies: 6
Reply
Join Date: Jul 2004
Posts: 2
Reputation: Chris Norton is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
Chris Norton Chris Norton is offline Offline
Newbie Poster

IIS connection will not write data

  #1  
Jul 4th, 2004
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
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Jul 2004
Location: Tyler, TX
Posts: 22
Reputation: brob5000 is an unknown quantity at this point 
Rep Power: 5
Solved Threads: 0
brob5000's Avatar
brob5000 brob5000 is offline Offline
Newbie Poster

Solution Re: IIS connection will not write data

  #2  
Jul 6th, 2004
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.



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
Reply With Quote  
Join Date: Jul 2004
Posts: 32
Reputation: RobUK is an unknown quantity at this point 
Rep Power: 5
Solved Threads: 1
RobUK RobUK is offline Offline
Light Poster

Re: IIS connection will not write data

  #3  
Jul 13th, 2004
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.
Rob - DMOZ Editor
Web Design Forums - Free website critiques. Web design + SEO Advice
Reply With Quote  
Join Date: Jul 2004
Posts: 2
Reputation: Chris Norton is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
Chris Norton Chris Norton is offline Offline
Newbie Poster

Solution Re: IIS connection will not write data

  #4  
Jul 13th, 2004
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.

Problem fixed. It was caused by permissions in IUSR set to read only Thanks anyway
Reply With Quote  
Join Date: Jul 2004
Posts: 32
Reputation: RobUK is an unknown quantity at this point 
Rep Power: 5
Solved Threads: 1
RobUK RobUK is offline Offline
Light Poster

Re: IIS connection will not write data

  #5  
Jul 14th, 2004
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.
Rob - DMOZ Editor
Web Design Forums - Free website critiques. Web design + SEO Advice
Reply With Quote  
Join Date: Nov 2004
Posts: 1
Reputation: mdawg is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
mdawg mdawg is offline Offline
Newbie Poster

Re: IIS connection will not write data

  #6  
Nov 16th, 2004
Originally Posted by Chris Norton
Problem fixed. It was caused by permissions in IUSR set to read only Thanks anyway

Chris, how did you change your permissions. My OS is Windows 2000 Professional. thank you for your time, the error I got is located below.

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
Reply With Quote  
Join Date: Jul 2004
Location: Sydney, Australia
Posts: 166
Reputation: Lafinboy is an unknown quantity at this point 
Rep Power: 5
Solved Threads: 7
Lafinboy's Avatar
Lafinboy Lafinboy is offline Offline
Junior Poster

Re: IIS connection will not write data

  #7  
Nov 22nd, 2004
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 ::

Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

DaniWeb ASP Marketplace
Thread Tools Display Modes

Similar Threads
Other Threads in the ASP Forum

All times are GMT -4. The time now is 12:31 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC