odbc - ADODB.Connection in VB6 - Open Method fails with Runtime Error '2147221164 (80040154)' -


this start happen on project on working, , far not able figure out root cause.

this stopped working without change side, thing know has changed since last time worked on project disk failed (used e: drive on applications installed). operative system windows server 2003.

below error:

runtime error

the libraries adding project following:

  • visual basic applications
  • visual basic runtime objects , procedures
  • visual basic objects , procedures
  • ole automation
  • microsoft cdo windows 2000 library
  • microsoft scripting runtime
  • windows scripting host object model
  • microsoft data binding collection vb6 (sp4)
  • microsoft activex data objecrs 2.8 library

the object oconn declared , instantiated following way:

  1. dim oconn adodb.connection
  2. set oconn = new adodb.connection

no reference marked missing in vb project.

i tried late binding, without success. tried use regsrv32.exe reregister msado15.dll, no joy.

i out of idea here, think dependencies no longer satisfied due failure of disk, don't know how investigate given few details provided ide.

thanks

this question has no easy answer. found, , has been suggested in comment @jim hewitt, mdac on windows server 2003 corrupted. component checker not able identify version of mdac, embedded component in version of windows. so, summarizing, whole windows installation corrupted (no idea on how have happened) , visual basic 6 doesn't work properly. solution has been setup machine.


Comments

Popular posts from this blog

jOOQ update returning clause with Oracle -

java - Warning equals/hashCode on @Data annotation lombok with inheritance -

java - BasicPathUsageException: Cannot join to attribute of basic type -