Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 801
  • Last Modified:

ADOX.CatalogClass.Create Error

Hello,

some of our users are getting the following error message when they first try to run our program:

Additional Description: Error Creating User Settings Database
Stack Trace: at ADOX.CatalogClass.Create(String ConnectionString)


When it is first run, the program looks for a "User Settings.mdb" database (in MS Access format) and tries to create one if there isn't already one present.

In order to programmatically create a Jet database, the program references:
 
  Microsoft ADO Ext. 6.0 for DDL and Security

and I include "msadox.dll" from the "ADO" folder in the "Common Files\System" folder and the "Interop.ADOX.dll" created by my project into the installer.


The program also references:
 
   Microsoft Jet and Replication Objects 2.6 Library

so the "msjro.dll" and "Interop.JRO.dll" DLLs are also included in the installation.


I assume that this error is occurring because the client's system isn't registering these dll's properly and/or I am not installing them correctly, or am missing something.  What can I do?  Thank you.

Vijay


0
vdurbal
Asked:
vdurbal
  • 3
  • 2
1 Solution
 
leonstrykerCommented:
Can you show us the piece of code where you are actually doing this.

Leon
0
 
vdurbalAuthor Commented:
I'm not sure what you mean.  The DLL's were added using the "Add Reference" menu option, then selecting the following references on the "COM" tab:

      Microsoft ADO Ext. 6.0 for DDL and Security
      Microsoft Jet and Replication Objects 2.6 Library

In our installer, I included those DLLs and on almost everyone's machine, the installation is fine and the program works.  The error I am describing only happens on one or two machines.  The latest one is running Windows XP Tablet Edition.

Also, I tried installing the MDAC downloaded from Microsoft, but it didn't make a difference.

I hope this helps.  Please let me know what else you need to diagnose the problem.  Thank you.

Vijau
0
 
Luke ChungPresidentCommented:
Do you know what version of ADOX is on their machine before you installed your program?
Why are you using ADOX to create a Jet database?  The DAO CreateDatabase command should work. There are all sorts of problems with ADOX.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
vdurbalAuthor Commented:
Thanks.  I'll try using the DAO command.
0
 
vdurbalAuthor Commented:
I'm only giving a B because my original question was not answered, but the accepted answer could be a reasonable workaround.  Thank you.
0
 
Luke ChungPresidentCommented:
Glad you liked my solution.
FYI, not sure if it helps but our Total Visual SourceBook product has lots of royalty-free source code related to creating and managing Access databases, workgroup security, passwords, etc.  It's a commercial product, so I know that may not be an option but you may find it helpful.
http://www.fmsinc.com/MicrosoftAccess/SourceCodeLibrary.html 
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now