Upgrade to Server 2003

[Jay]

I'm not sure where else to ask this question. Please point me to newsgroup
more suited.
Is there a Server 2003 group that handles issues with upgrades? Thank You so
much for your help in advance.

My client just upgraded their network from Novell to Server 2003. Their
customer management system is written in visual basic 6.0. Only the
database resides on the server and now 3 out of 7 xp client machines are
having problems accessing the database. The error message is "Connection
can not be used to perform this operation. It is either closed or invalid
in this context."

I was able to reproduce this message on my local machine (not at the client
site) by denying read access to the database from the currently logged in
user. This tells me that it is a permission problem with Server 2003.

Any help toward this end would be very much appreciated!

Thank You

[Daniel Wilson]

That's an ADO message seen in VB6 for a variety of reasons. For whatever
reason, the recordset or command failed to open, and on subsequent lines of
code emits that error message. It COULD be a permission problem reaching
the database, but is not necessarily.

What kind of database is it? Is the network configured as a domain or a
workgroup? Are all 7 clients on the same LAN segment?

These are shots in the dark until we learn more. I'm not sure which
newsgroup to refer you to ... but with more information someone should be
able to refer you appropriately.

dwilson

"Jay" <[e-mail]> wrote in message news:Lqi0d.40800$mu.23805@okepread07...

I'm not sure where else to ask this question. Please point me to newsgroup more suited.
Is there a Server 2003 group that handles issues with upgrades? Thank You so much for your help in advance.

My client just upgraded their network from Novell to Server 2003. Their
customer management system is written in visual basic 6.0. Only the
database resides on the server and now 3 out of 7 xp client machines are
having problems accessing the database. The error message is "Connection
can not be used to perform this operation. It is either closed or invalid
in this context."

I was able to reproduce this message on my local machine (not at the client site) by denying read access to the database from the currently logged in
user. This tells me that it is a permission problem with Server 2003.

Any help toward this end would be very much appreciated!

Thank You