We help IT Professionals succeed at work.

ADOX deployment problem under VB.Net 2003

John_Crumley
John_Crumley asked
on
Medium Priority
398 Views
Last Modified: 2007-11-27
Hello!

I have an application which relinks some tables in an Access database using ADOX 2.7.  Everything works fine in the development  environment.  When the setup package is run (on the same machine) and then the INSTALLED program is run, I receive an error "System.IO.FileNotFoundException: File or assembly name Interop.ADOX, or one of its dependencies, was not found." when it attempts to run the code which references the ADOX library

(with, for example...
        Dim ADOXTable As ADOX.Table
        Dim ADOXCatalog As New ADOX.Catalog
        Dim ADOConnection As New ADODB.Connection
).

The "detected dependancies" include "Interop.ADOX.dll" and the file is in the installation directory with the executable program.  The other installed dll's are ADODB.dll and InterOp.ADOR.dll.  

MDAC 2.7 is installed on the machine and works fine when the code runs in the development environment.

Does anyone have any ideas on what can be causing the problem or any additional steps I need to take to use ADOX from an installed program?

Thanks,

John

Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2008

Commented:
When you say:

>>MDAC 2.7 is installed on the machine and works fine when the code runs in the development environment.

Do you mean that MDAC 2.7 is installed on the production machine or the development machine?  I would imagine that it is a dependency problem that you are having, because MDAC was not installed on the target machine.

Bob

Author

Commented:
Bob,

The problem is occuring on the development machine and on target machines.  Everything works fine within the IDE on the development machine but when I install the software on the development machine (by running the install app from within the IDE) I get the specified error.  It also occurs on target machines when MDAC 2.7 has been installed.

John
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2008

Commented:
In your solution, what references do you have for ADOX?

VS.NET 2002 or 2003?

When adding ADOX reference, I don't have Interop.ADOX.Dll?  How did you get this?

Bob

Author

Commented:
I am using VS.NET 2003.

The "Interop.ADOX.dll" is added to the "Detected Dependancies" of the install project when I add a reference to "Microsoft ADO Ext. 2.7 for DDL and Security" to the project and then "refresh dependancies".  It goes away when I remove the reference.  I will try excluding "Interap.ADOX.dll" and see what happens.

An interesting point is that ADO works fine in the installed program.  It is only the ADOX that has a problem.  This is one of the reasons I do not think it is an MDAC install issue.

John

Author

Commented:
Excluding "Interop.ADOX.dll" did not help.  Same error messagge.

John
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2008

Commented:
I need to ask what you are using ADOX for?  Would it be possible to do it the ADO.NET way?

Bob

Author

Commented:
I'm using ADOX to relink tables in an Access database.  The tables reside in a database which is the data store for a 3rd party business system.  I link the tables and then extract data from the 3rd party system into mine so that it can be manipulated without any impact on the 3rd party system.

My understanding is there is no ADO.NET options for this and that I must use ADOX or DAO.  I think of DAO as dead so I picked ADOX.  I may need to switch over to DAO and see if I can distribute it.

John
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2008

Commented:
I understand now.  You are right in the ADO.NET does not have the capability to link Access tables.

Have you ever used a Dependency Walker program to determine the dependencies for the .dll file?

Bob

Author

Commented:
Bob,

No, I have not traced the dependancies that way.  I think I will punt at this point and do it in DAO though I may scrap the setup project and start over to see if that makes a difference.

John
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2008

Commented:
You should probably delete this question.

Bob "Cleanup Volunteer"

Author

Commented:
Ok...Thanks.

Author

Commented:
Ok...how do I delete a question?

It appears I say "please delete this question"?  If not, a helpful hint on where to go in the navigation structure to delete the question would be great!

Thanks,

John
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2008

Commented:
Post a question in Community Support TA and ask for this question to be deleted.

Thanks,
Bob
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2008

Commented:
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.