VB6 ADO Crashing When Trying to Access SQL Server under Win XP

David C. Barber

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?

Nov 3 '06 #1

Jan Hyde

"David C. Barber" <da***@NOSPAMdbarber.com>'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)

Nov 3 '06 #2

David C. Barber

"Jan Hyde" <St***********@REMOVE.ME.uboot.comwrote in message
news:up********************************@4ax.com...

"David C. Barber" <da***@NOSPAMdbarber.com>'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)

I'll quit multi-posting when CLVB and CLBV are combined into one group.
Until then, there's no good indication which group is better to be using at
a given time. It's stupid to have both groups, and we'd be better off with
only one of them.

Dec 30 '06 #3

Steve Gerrard

"David C. Barber" <da***@NOSPAMdbarber.comwrote in message
news:5P******************************@comcast.com. ..

>

I'll quit multi-posting when CLVB and CLBV are combined into one group.
Until then, there's no good indication which group is better to be using at
a given time. It's stupid to have both groups, and we'd be better off with
only one of them.

If you want to send a post to both CLVB and CLBV, then cross-post, don't
multi-post.

Multi-post: Two separate posts are sent, each addressed to a single newsgroup,
but containing identical text.

Cross-post: A single post is sent, with two newsgroups listed in the address
field, separated by a comma, similar to sending an email to two people at once.

If you cross-post, then replies made in one newsgroup will also appear in the
other group, avoiding a lot of confusion, repetition, and annoyance. Also in
many newsreaders, if I read the post in one group, it is automatically marked as
read in the other group as well.

Dec 30 '06 #4