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

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

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: Windows Vista at One Year (Dark Side Report)
    ... Shop manager Aaron Kaplan said they were prompted to put it up because so many people were having problems with Windows Vista, including compatibility issues with older software and trouble adjusting to the interface. ... Microsoft released Windows Vista to the world one year ago with ads likening the new PC operating system to such awe-inspiring moments as the first American spaceflight and the fall of the Berlin Wall. ...
    (soc.retirement)
  • RE: Vista unable to logon with RDP in Remote Web Workplace
    ... I searched for other threads related to TCP Autotuning and found ... Do all Vista workstation have such issue? ... Can you see any error messages when connecting to server desktop? ... When trying to connect to a terminal server from Windows Vista, ...
    (microsoft.public.windows.server.sbs)
  • Re: Connection problem with WPA2 Enterprise with Windows Vista (Home Premium)
    ... I have deployed a Wi-Fi network with WPA2 protocol set, and authentication with RADIUS server, both "users" file and Active Directory. ... Everyone but users that try to get access to Wi-Fi network with a Windows Vista operating system. ... DHCP address from whatever unspecifed device is delivering the IP ...
    (alt.internet.wireless)
  • Re: Apple is Completely Eclipsed
    ... 60 Million Copies of Windows Vista Completely Eclipse Apple - Vista sells ... revenue growth in the 2007 fiscal year ended on June 30. ...
    (comp.sys.mac.advocacy)
  • Re: Why one should choose Linux over Vista
    ... Because you hate Microsoft ... It?s never too much for Vista! ... There is no Linux Genuine Advantage! ... DVD Burning Problem in Windows Vista ...
    (microsoft.public.windows.vista.general)