|
       
 |
|
| Knowledge Base Most common error and how to trouble shoot them off |
  |
|
Arguments are of the wrong type, are out of acceptable range, or are in conflict with
|
LinkBack | Thread Tools | Display Modes |
27-Feb-2007, 08:11 PM
|
#1 (permalink) |
|
Fixed Error!
Posts: 141
Location: Chennai
Join Date: Feb 2007
Rep Power: 2
IM:
|
Arguments are of the wrong type, are out of acceptable range, or are in conflict with
but when I try opening one (rsSurgery) using parameters: rsSurgery.Open strSQL, Session("conn"), adOpenDynamic, adLockOptimistic, adCmdTableDirect it breaks, giving the error: Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. adOpenDynamic, adLockOptimistic, adCmdTableDirect should open an editable recordset, such that AddNew will work. (I don't even have the AddNew in there yet!!!) Thanks! ************************************************** ** <html> <head> <title>Add a Surgery</title> </head> <body> <table border=1> <tr> <td font size="4">Add a Surgery</td> </tr> <% Set rsSurgery = Server.CreateObject("ADODB.Recordset") Set rsRep = Server.CreateObject("ADODB.Recordset") strSQL = "SELECT [ARA_RepKey] FROM [ARA_RepHeader] WHERE [ARA_RepName] = '" strSQL = strSQL & Request.Form("cboRepName") & "'" rsRep.Open strSQL, Session("conn") Response.Write(rsRep("ARA_RepKey")) ' <---- this works, proving that Session("conn") ' is connected to the database strSQL = "SELECT [AKA_SurgeryDate] FROM [AKA_CaseHeader]" rsSurgery.Open strSQL, Session("conn"), adOpenDynamic, adLockOptimistic, adCmdTableDirect rsRep.Close rsSurgery.Close %> <tr> <td>done</td> </tr> </table> </body> </html> |
|
       
|
|
|
|
|
27-Feb-2007, 08:11 PM
|
#2 (permalink) |
|
Fixed Error!
Posts: 141
Location: Chennai
Join Date: Feb 2007
Rep Power: 2
IM:
|
Re: Arguments are of the wrong type, are out of acceptable range, or are in conflict
Please ensure the MDB file is not read-only. Also please ensure user IUSR_COMPUTERNAME is allowed to modify the mdb file. |
|
|
|
| |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
