You have a variable inside your sql string which will never be evaluated. I think you'd be much better off using the command object, but if you still want to use the Open method, try this:
sql="exec dbo.fp_qr_code @sequence =" & request.querystring("id")
I made that change, but it is still creating a 500 Server Error. I do appreciate your effort, however.
I always used the command object for stored procedures. That's what I would suggest at this point.
I resolved this. Here is the query that worked:
sql="exec fp_qr_code '" & request.querystring("id") & "'"
set rs = Conn.Execute(sql)
if rs.eof then response.write("No Records")
while not rs.eof
Of course. The sproc parameter needed to be quoted. Good catch.