ODBC driver does not support the requeste
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=4102
Printed Date: 30 March 2026 at 10:06am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: ODBC driver does not support the requeste
Posted By: ngaisteve1
Subject: ODBC driver does not support the requeste
Date Posted: 07 July 2003 at 1:37am
|
I got this error mesg. Using response.end, I found it's after this line of code. What's possible solution for this? Thanks. rs.Open sql, conn, 3, 3 Screen shot - http://www.htmlforums.com/attachment.php?s=&postid=166892 - http://www.htmlforums.com/attachment.php?s=&postid=166892 |
Replies:
Posted By: MorningZ
Date Posted: 07 July 2003 at 11:13am
|
have you tried dropping the "3, 3" from the end of that line? obviously you don't understand the meaning of them :-(, so just leave em off ------------- Contribute to the working anarchy we fondly call the Internet |
Posted By: the boss
Date Posted: 07 July 2003 at 2:33pm
the 3,3 in the end are for cursor type and lock type  ------------- http://www.web2messenger.com/theboss"> 
|
Posted By: ngaisteve1
Date Posted: 07 July 2003 at 7:01pm
|
It's true. I don't understand 3, 3 though I did read about it before. I just follow the existing code. Any simplest word to explain this cursor type and lock type? Thanks to MorningZ, it works after I remove it.
|
Posted By: ngaisteve1
Date Posted: 07 July 2003 at 8:00pm
| But then it return -1 for recordcount if I drop 3, 3 |
Posted By: MorningZ
Date Posted: 07 July 2003 at 9:11pm
|
do this: sql = "SELECT emp_id, emp_privilege FROM intranet.citylink_employee WHERE emp_userid = '" & strUserID & "' AND emp_password = '" & strPassword & "' " rs.CursorLocation = 3 and rs.RecordCount should work properly ------------- Contribute to the working anarchy we fondly call the Internet |
Posted By: ngaisteve1
Date Posted: 07 July 2003 at 9:15pm
Big big thanks. It works.  .
|