I am getting this error. Help me understand what am I doing wrong.
Microsoft VBScript runtime error '800a01c2'

Wrong number of arguments or invalid property assignment: 'Open'

/forms/Results.asp, line 43

Line:43 is:

ObjConn.Open "Escalation_Forms", ObjConn, , adLockOptimistic, adCmdTable

The rest of the code:

Dim TicketNum, rs, ObjConn, Conn, strSQL, adLockOptimistic, adCmdTable


TicketNum = Request.QueryString("Ticket_Number")

set objConn=Server.CreateObject("ADODB.CONNECTION")

ObjConn.Open "Provider=sqloledb;Data Source=Flmirsql02;Initial Catalog=Source_Forms;User Id=Source_Forms_User;Password=password;"

ObjConn.Open "Ticket_Number", ObjConn, , adLockOptimistic, adCmdTable

Set rs = Server.CreateObject("ADODB.Recordset")

Set rs = Conn.Execute("SELECT First_Name FROM Escalation_Forms WHERE Ticket_Number = " & TicketNum)

if rs.eof then
   Response.write("No data was returned for ticket number: " & TicketNum)
else
   First_Name = rs("First_Name")
end if

ObjConn.Close
Set ObjConn = Nothing
%>
<table>
   <tr>
      <td>First Name:</td><td><input type="text" name="firstName" value="<%=First_Name%>">
   </tr>
</table>

Hey,

Do you have these assigned to the correct value: adLockOptimistic, adCmdTable? They have to be assigned to their equivalent value. You can get them from the adovbs.inc whenever you create a new web site using Interdev.

Brian

Hi calibus,

   You include the file adovbs.inc file using

this file has all constants for ADO

Hi Calibus,
You cannot use CONNECTION object to do this. Also Open method of CONNECTION object doesn't take these sort of parameters. You can check out for its parameters.

Just comment this line, you should get things working.;)
''''ObjConn.Open "Ticket_Number", ObjConn, , adLockOptimistic, adCmdTable

Cheers!

_________________________
- Vijay G
Strive for Perfection