I have a program in VB6 that runs OK on my machine but when I try to run it on other machines I the error message Class not registered. Looking for object with CLSID: 00000010-0000-0010-8000-OOAA6D2EA4. The other tables in the database run OK, just this one table that plays up. Anybody with any ideas please; I'm tearing my hair out!
The only thing I can think of is the fact that I'm using;
'Select * from Members Order by Last Name' in the program:(

A R Bradley

__________________
A R Bradley

That's not an sql error, it's a dll or object error, are you installing something in the client machine?

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

A R Bradley

Hi Gonzalo
Yes I'm trying to run my program on the client machine; I can other programs to do so but not this one. There are three tables in the database, two work without trouble but this one will not. The whole program runs without any bother on my machine (the one I wrote the program on). The SQL bit is only my idea of what is wrong, it could be that I have it all wrong! Thanks for looking.

A R Bradley

Well.. what do you do to get that data?

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Well, I just load the program on to the host computer and try to run it. The program runs OK until I try to access this one table and then I the message. If I continue to run the program,it works but without the database being accessed; any further operation produces the error code 713 which presumably means the database table is not available. Sorry to be such a pain.

A R Bradley

Could you just debug the code and get a better hand into the error? I can't help you without knowing better what is happening...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Hi Gonzalo,
The program shows no bugs when tested. It runs OK within VB and also when compiled and run on a computer with VB installed. The problem occurs when I try to run a compiled copy on a computer without VB installed on it. I use the package & deployment wizard to install the program on the host computer but still get the error message quoted. It is ONLY one table in the database that can't be addressed; I have tried rewriting that table but it has made no difference
UKBrad

A R Bradley

Ok.. what database are you using?? are you using any diferent way to access that table?? (comparing with the others tables)

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

I agree with Gonzalo. The error that you posted is not related to the tables in your database, per se. It is related to the code that is running when you try to access the table or database. You have a dll not registered on the machine where you have installed the application. This is a deployment issue, and even though you have used the Packaging and Deployment wizard you still have problems delivering and installing components your application is dependent on. These could be dlls that you have written and are part of your application, or they could be dlls that are part of VB or part of some 3rd party libraries. This is not a simple issue with a table in your database.

Post the relevant code here and perhaps you will be able to get some help. If you have to post more than 10 or 15 lines of code, you haven't isolated your problem well enough for this sort of forum.

Woody Z
http://www.learntoprogramnow.com
How to use a forum to help solve problems
My blog... please visit