sql dmo deployment

hi there,

i am developing a system using vb6 and sql 2005 as backend database, i used the SQLDMO.dll in the project, then i am using the installshield for my deployment, but i was wondering why does the SQLDMO is not running properly (results to app err, then exits the system) considering that the sqldmo.dll was properly installed in the target pc.

pls help.. do i need to do other things aside from including the reference/dll in my installer.

alexis

You need the proper MDAC also amongst other things...

More than that.... sqldmo.dll is merely the entry point.... there's 5 or 6 other dlls that also need to be shipped to properly support sqldmo.

fyi: sqldmo works just fine by itself, it does not require MDAC to be installed.... doesn't hurt mind you just that it's not required.

-tg

Ahhhhh.... The old sortcut the installation trick.... Bad Ju-Ju!!! ;)