interop.ADOX and VB.Net distributions

[John Dann]

I have a VB.Net application that primarily uses ado.net to manipulate
an Access/JET database. It uses adox to create a new empty database if
one doesn't already exist. This works fine on the development machine
but on trying a test deployment (to a Win2K PC) the step to create the
new database fails as an unhandled exception with the error
'Interop.ADOX or one of its dependencies was not found'

Now AFAICS interop.adox.dll was included as part of the .msi
installation package and can be found in the application folder.
MSadox.dll wasn't for some reason packaged (actually I think it was a
permissions problem) but I moved it manually to the program folder.

Obviously something is not right in this scheme of things. Can anyone
suggest where to look first.

TIA
JGD

 

[Elton Wang]

You might neet to register COM, MSadox.dll, to development
machine:

Copy MSadox.dll to WINNT/System32
Execute regsvr32 MSadox.dll

 

[John Dann]

You might neet to register COM, MSadox.dll, to development
machine:

Copy MSadox.dll to WINNT/System32
Execute regsvr32 MSadox.dll

Many thanks - that seems to have done the trick. I'm tempted to ask
whether this is just a quirk/bug relating to msadox.dll or a more
general feature that I should be aware of in respect of other
referenced dll's. Is it perhaps a difference between operating in a
VB.Net environment and eg VB6?

JGD

 

[Paul Clement]

¤ On Sun, 14 Nov 2004 09:01:24 -0800, "Elton Wang"
¤
¤ >You might neet to register COM, MSadox.dll, to development
¤ >machine:
¤ >
¤ >Copy MSadox.dll to WINNT/System32
¤ >Execute regsvr32 MSadox.dll
¤ >
¤
¤ Many thanks - that seems to have done the trick. I'm tempted to ask
¤ whether this is just a quirk/bug relating to msadox.dll or a more
¤ general feature that I should be aware of in respect of other
¤ referenced dll's. Is it perhaps a difference between operating in a
¤ VB.Net environment and eg VB6?

It's distributed with MDAC which may or may not be installed on the machine to which you are
deploying.

http://www.microsoft.com/downloads/results.aspx?productID=&freetext=mdac&DisplayLang=en


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)