0x80040e21 - Microsoft OLE DB Service Components: Multiple-step OLE DB operation

• jjjohn

  SSC Veteran

  Points: 270

  More actions

  April 24, 2023 at 3:33 pm

  #4178693

  OpenConnection with MS SQL server 2022 generate error

  0x80040e21 - Microsoft OLE DB Service Components: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

  There is no any operation, error generated on Session_OnStart() procedure in Global.ASA file.

  Connection to server made during ODBC Source with ordinary default parameters.

   

   

   

  Attachments:

  You must be logged in to view attached files.

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  April 25, 2023 at 4:10 pm

  #4179300

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• jjjohn

  SSC Veteran

  Points: 270

  More actions

  April 25, 2023 at 6:20 pm

  #4179357

  I don't know why, but after series of reboot and reconfiguring again and again, connection established!

  My last connection string

  "Driver=SQL Server; Server=Localhost; Database=ZZZZZZZZZZZ; uid=YYYYYYY; pwd=XXXXXXXXXXX;DataTypeCompatibility=80;"