Re: VB6 + ADODB.Recordset + Vista = Automation error -2147024769

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I think I can see a light at the end of the tunnel!

It seems that the Installation-Process of the Tool is the guilty part.

Before the installation, a simple ADODB.Recordset-Test was running, after
the installation, the -214... automation error of the same example pops up.

I think the Installshield-Setup installs/copies/registers his "own"
ADO-DLL's or something.

After an uninstall of the program, a runtime error 429 appears...

So, the installation "destroys" something, think we have to rebuild the setup!


Greets

timmi

"timmi" wrote:

But I tested it on 3 Vista Systems now.

1 manual clean Installation (Business) and
2 different Laptop OEM Versions (Toshiba & Asus), which were pre-installed...

I haven't changed something, concerning the ADO-Installation (WDAC/MDAC).

"Jan Hyde (VB MVP)" wrote:

timmi <timmi@xxxxxxxxxxxxxxxxxxxxxxxxx>'s wild thoughts were
released on Wed, 10 Dec 2008 00:34:01 -0800 bearing the
following fruit:

Hello everybody!

WEEKS have passed now and it won't come to an end.

The problem is simple:

I've got a VB6 program that runs wonderful under Windows XP but Vista always
hangs up, when it tries to execute the following command:

Set rs = New ADODB.Recordset <-- DOESN'T WORK!

I do this this all the time in all the products I work on
and have never encountered a problem with Vista.

It's seems to me it's more likely a problem with your
installation of ADO.



This command exists inside a function, at the top of the .bas-File, the
Variable is declared:

Public rs As ADODB.Recordset

___________________________________
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
I've also tried to start with a new (clean) project and made everything as
simple as possible. It seems that no ADO-Components work under Windows Vista.

A try to get the ADODC-Control to work also failed (worked under XP, but not
under Vista).

___________________________________
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
I posted in several forums now, but nobody could help me.
Maybe the answers of others could, so I will link some of my Threads:

1) http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=4164774&SiteID=1
2)
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=4219413&SiteID=1&mode=1
3) http://www.vbarchiv.net/forum/id13_i16850t16850.html
4) http://www.dbforums.com/showthread.php?t=1635645

--
Jan Hyde (VB MVP)

https://mvp.support.microsoft.com/profile/Jan.Hyde

.

Relevant Pages

  • Re: Vista version Media Player 11 wont start up.
    ... start Windows Vista from your hard drive and insert the Windows Vista DVD ... wipe out the previous installation completely but obviously I was wrong. ... "I am not sure what causes the problem with Windows Media Player but at the ...
    (microsoft.public.windowsmedia.player)
  • Re: Disappearing DVD drive--not an upper or lower filter issue
    ... the optical drive was functioning before the installation of sp1. ... He rebooted, Vista came up, but he was uncomfortable with the hang, so he uninstalled sp1. ... when you want to install Windows Vista SP1 on ...
    (microsoft.public.windows.vista.hardware_devices)
  • MBR problem
    ... I used to have dual-boot Windows + Ubuntu computer and let EasyBCD do booting job. ... This morning I installed OpenSuse on computer containing only Windows Vista. ... Thought I done evrything OK, that is, I tought I installed Grub on Linux native partition, but instead directly booting to Windows after Linux installation, my computer went to OpenSuse boot selection. ... This can be caused by a non-standard MBR, use of a 3rd-party bootloader, or a failed Windows Vista install.To proceed, please enter the letter of your boot drive below. ...
    (microsoft.public.windows.vista.general)
  • Re: Vista version Media Player 11 wont start up.
    ... I have also created another account on my machine and media player works ... start Windows Vista from your hard drive and insert the Windows Vista DVD ... wipe out the previous installation completely but obviously I was wrong. ...
    (microsoft.public.windowsmedia.player)
  • Re: Vista version Media Player 11 wont start up.
    ... If you turn off the access control,then media player works fine as it does ... It is not possible to reinstall IE7 or Vista media player so this is a stale ... start Windows Vista from your hard drive and insert the Windows Vista DVD ... wipe out the previous installation completely but obviously I was wrong. ...
    (microsoft.public.windowsmedia.player)