ASP: ODBC driver does not support the requested properties.

[ngaisteve1]

I got this error mesg (screen shot in attachment). Using response.end, I found it's after this line of code. What's possible solution for this? Thanks.

sql = "SELECT emp_id, emp_privilege FROM intranet.citylink_employee WHERE emp_userid = '" & strUserID & "' AND emp_password = '" & strPassword & "' "

[putts]

Well, that line of code is just setting a variable in ASP, it's not touching the ODBC at all.

The only time ODBC should throw a flag like that is on a ADODB.Connection's open function or on a ADODB.Connection's execute function where information is being passed to or from the database server.

Is this happening on the live server (web)? or the production server (your PC)? or both?

[ngaisteve1]

production server. by the way, the live server's and production server is different. Is that make a different?

[ngaisteve1]

I got that solved by dropping 3 (adOpenStatic),3 (adLockOptimistic). But, doing that, I got recordset return -1.

[putts]

The SQL String you're trying to execute must not be working and that's why you got those errors when trying to use the openStatic and LockOptimistic options of the recordset.

Do a
response.write(SQL String)
response.end
just before the line where you do the
db.execute(SQL String)
and double check the Query String to make sure it's valid.

[ngaisteve1]

I got that fix by putting rs.CursorLocation = 3 before the connection code.