Hi there I just wrote a small data access application that reads from a SQL 7 database, writes the result to a text file, and then using a 3rd party email component, emails the text file to another address.

The problem is that when I install the executable on the machine that it is supposed to run on, I get a runtime error '13', Type mismatch. I get this error after the program runs. The program works, just this message box pops up, at the end.

What's also weird, this doesn't happen on my development machine, only the other one. The host machine has the VB runtime libraries installed as well as the dll's that belong to the 3rd party email component.

My app uses ADO 2.1, which the host machine didn't have the dll for, thus I copied it into the c:\Program Files\Common Files\System\Ado folder. Unfortunately that didn't work. So I recompiled the app using ADO 2.0 which the host machine did have the dll file for. Alas that didn't work either.

The host machine runs NT4 w/ service pack 5. The development machine runs Win 2K Pro. Any help would be greatly appreciated as this app will run as a SQL 7 job and will be part of a larger solution. Thanks in advance.

Regards,
Jack Vinitsky