Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server ASP
SQL Server ASP Discussions about ASP programming with Microsoft's SQL Server. For more ASP forums, see the ASP forum category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server ASP section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old October 19th, 2006, 09:01 AM
Registered User
Join Date: Oct 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default "ODBC driver does not support the requested..."

Currently having a problem that makes no sense (to me anyway!):

An existing ASP Classic application is in place which I now have a development copy of running on a testing server as it is undergoing some overhaul. As part of this I have duplicated the database using DTS to another DB on the same SQL 2000 server. I've set up a new login/password for this "new" DB and changed the connection string accordingly. However I got this error message back:

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

ODBC driver does not support the requested properties.

on the first attempt to open a record set. Having googled to no real result in desperation I tried something that was after a MySQL server had a similar problem where it had problems with permissions for a specific table and was mis-reporting the error.

So I explicitly gave that user permissions for all the tables etc in the database. This resulted in the program getting further before bombing out with the same error message. Having looked at the line it is dying on it definately has permissions on the table(s) it is opening in that query. I found changing the Cursor type for that query from AdOpenReadOnly to AdOpenOptimistic made it work (????)

Obviously this isnt ideal since I dont like makeing changes like that for no apparant reason.


I'm not crazy - I'm just a little unwell
Old December 28th, 2007, 02:08 AM
Registered User
Join Date: Dec 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts


Anand.S.Sushil Kumar

Similar Threads
Thread Thread Starter Forum Replies Last Post
ODBC to text driver mnolting Word VBA 0 October 6th, 2008 06:52 PM
ODBC driver creation densam ADO.NET 0 January 4th, 2006 06:00 AM
SQL ODBC Driver Pragnesh1205 SQL Server 2000 6 October 31st, 2005 01:15 PM
Rdb ODBC Driver Eron Oracle 0 March 9th, 2005 04:32 AM
ODBC driver for Teradata clueless_may Access VBA 0 November 1st, 2004 11:00 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.