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?