Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > Beginning VB 6
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Beginning VB 6 For coders who are new to Visual Basic, working in VB version 6 (not .NET).
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Beginning VB 6 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old March 17th, 2008, 07:57 AM
Authorized User
 
Join Date: Mar 2008
Location: Leicester, UK, United Kingdom.
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default Error Message

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
Reply With Quote
  #2 (permalink)  
Old March 17th, 2008, 09:06 AM
Friend of Wrox
Points: 7,395, Level: 36
Points: 7,395, Level: 36 Points: 7,395, Level: 36 Points: 7,395, Level: 36
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Capital Federal, , Argentina.
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

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
================================================== =========
Reply With Quote
  #3 (permalink)  
Old March 17th, 2008, 10:08 AM
Authorized User
 
Join Date: Mar 2008
Location: Leicester, UK, United Kingdom.
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
quote:Originally posted by gbianchi
 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
Reply With Quote
  #4 (permalink)  
Old March 17th, 2008, 10:21 AM
Authorized User
 
Join Date: Mar 2008
Location: Leicester, UK, United Kingdom.
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #5 (permalink)  
Old March 17th, 2008, 11:22 AM
Friend of Wrox
Points: 7,395, Level: 36
Points: 7,395, Level: 36 Points: 7,395, Level: 36 Points: 7,395, Level: 36
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Capital Federal, , Argentina.
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

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
================================================== =========
Reply With Quote
  #6 (permalink)  
Old March 17th, 2008, 12:42 PM
Authorized User
 
Join Date: Mar 2008
Location: Leicester, UK, United Kingdom.
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #7 (permalink)  
Old March 17th, 2008, 01:14 PM
Friend of Wrox
Points: 7,395, Level: 36
Points: 7,395, Level: 36 Points: 7,395, Level: 36 Points: 7,395, Level: 36
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Capital Federal, , Argentina.
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

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
================================================== =========
Reply With Quote
  #8 (permalink)  
Old March 18th, 2008, 06:03 AM
Authorized User
 
Join Date: Mar 2008
Location: Leicester, UK, United Kingdom.
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #9 (permalink)  
Old March 18th, 2008, 10:47 AM
Friend of Wrox
Points: 7,395, Level: 36
Points: 7,395, Level: 36 Points: 7,395, Level: 36 Points: 7,395, Level: 36
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Capital Federal, , Argentina.
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

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
================================================== =========
Reply With Quote
  #10 (permalink)  
Old March 18th, 2008, 11:26 AM
Friend of Wrox
 
Join Date: May 2006
Location: San Diego, CA, USA.
Posts: 643
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
What is the error message for a 500 server error? chobo2 C# 2005 1 May 4th, 2008 04:11 AM
Where does the error message go? Wei Wang BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0 1 March 13th, 2006 02:03 PM
Error Message alannoble26 Excel VBA 4 November 25th, 2005 11:20 AM
error message. Tasha Access VBA 2 August 12th, 2004 12:07 AM
Help with Error message mariakovacs Classic ASP Databases 3 October 10th, 2003 04:59 PM



All times are GMT -4. The time now is 02:22 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.