From: StellaDrinker@REMOVE.ME.uboot.com   
      
   "David C. Barber" 's wild thoughts   
   were released on Thu, 2 Nov 2006 22:56:21 -0700 bearing the   
   following fruit:   
      
   >I have a VB6 application that uses command line ADO to communicate to a SQL   
   >Server database.  I developed it under Visual Studio 6 SP 6 on a Win 2K   
   >machine, and it is very similar to other applications I've also developed to   
   >talk to different databases on this same SQL Server.   
   >   
   >The problem is that, when I load the application on a Win XP SP2 computer it   
   >crashes during execution with an Invalid Object Name message (-2147217865)   
   >on the second or third database recordset Open.  The invalid object   
   >referenced is a table name in SQL Server.  Other, similar, applications   
   >built from the same code-base don't crash.  And everything runs fine under   
   >Win 2K.  It also runs fine in the IDE on 2K and XP.   
   >   
   >I'm building the install package using the Package & Deployment Wizard,   
   >which has never screwed me up before.  And regardless of whether I build the   
   >setup package on XP or 2K, the .exe still crashes on XP.   
   >   
   >Any suggestions?   
      
   Don't mulipost for one...   
      
   Jan Hyde (VB MVP)   
      
   --   
   Migration: A headache birds get when they fly down for the winter.   
   (Richard Lederer)   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)