I have created a component that uses ADOX to create an access database and define a set of linked tables. When the component runs within the VB6 debug all the action is done by VB6.EXE and the component functions. When the component is compiled IIS runs the component as DLLHOST.EXE and the component fails
creating the link table.

ErrNum:-2147467259
ErrDesc:ODBC--connection to '0' failed.
ErrSrc:Microsoft JET Database Engine

I have checked every security setting I can find. If IUSR and IWAM are members of Administrators the component fails. The JET Db engine is able to create the temp files in the TMP directory.

What am I missing that causes this component not to be able to create the linked table when run as DLLHOST.EXE?

Frustrated,
Rob