How and when?

Can anybody tell me how and when ACTIVE X dlls are used.

and
ACTIVEX EXEs are used?

For example, what is best for data connection to SQL server, oracle or another database?

can u give me more examples of how and when to use it?

any tutorial links are helpful but a few words would also be great.

thanks for all the help

krishna

ActiveX DLL's and EXE's are like standard VB projects except they expose their public class modules to other projects that might want to instantiate them.

For instance, if I've written a function in one project and I want other projects to be able to use it, I would make it an ActiveX project. I don't have any tutorials on the subject but it's not difficult. As long as you know how to use class modules, you'll be fine.

The difference between DLL's and EXE's are that DLL's run in the same process as the calling application and EXE's run in a seperate process. Hence, DLL's are faster as calls to EXE's have to be marshalled across process bounderies but if an EXE crashes, it won't drag the calling application down with it.

Also, EXE's can run in stand alone mode whereas DLL's have to be called by another application.

ActiveX DLL or EXE have nothing with database connection.
if u r coding with VB 6.0 and want to connect to any RDBMS like Oracle, SQL Server, DB2 etc. the best way is using ADO via OLE DB.