Microsoft OLE DB Provider for ODBC Drivers error

0
votes

I am getting the following error.

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

ODBC driver does not support the requested properties.

C:\Local_Path/tblPlaylist.asp, line 4

I have setup the website in IIS

The line 4 in the code is 

rs.Open "SELECT numPlaylistID FROM `tbl_playlist-page` WHERE numPageID=" & Cint(numPageID), dbConn, 1, 2
1
mysqliisodbcoledb

1 Answers

1
votes

One possible reason for that is the cursor type that is being specified. The 1 in the Open call indicates a keyset cursor type (adOpenKeySet). That can result in 0x80040e21 error depending on the underlying driver. You might try changing it to another value as a test (e.g., change to 0 for a forward only cursor).