Error message is Microsoft OLE DB Provider for SQL Server error '80040e21' The requested properties cannot be supported.
I am trying to get this code to run on my new dev environment. If I comment out lines 4,5 and 6, the code works. This code does work on the production box. I have tried updating MDAC. My sql server driver is version 2000.86.3959.00 which is the same as production. I can't comment out the lines because there are hundreds of other lines of code similar to this.
Set RSPortalProgrammer = Server.CreateObject("ADODB.Recordset")
RSPortalProgrammer.ActiveConnection = MM_PortalDBConn_STRING
RSPortalProgrammer.Source = "SELECT * FROM tblNames"
RSPortalProgrammer.CursorType = 0
RSPortalProgrammer.CursorLocation = 2
RSPortalProgrammer.LockType = 3