activex control and SQL Server access

[mojoribbit]

I have recently been asked by my company to develop a web based timesheet program for use throughout the company. I have determined that the functionality that they require would be best provided through the use of an activex control. The problem I am running into is the fact that the control runs in the client browser, so all data access has to be done from the client machine, and most of the machines do not have the SQL Server ODBC driver. Is there a way that I can push the driver to them with the control? I have also considered using an activex dll to perform all of the data accesses, but how do I get the control on the client machine to communicate with the dll on the server? An answer to either question would solve my problem

[Chris]

Perhaps, you can start write your own COM and store all the Business logic into it & install it into the MTS server.

In this COM you can use the ADO object to connect to SQL server. So that you no need to install any SQL ODBC driver on anyone of your client PC. Yet, it easy to maintain becuase it just a DLL and you only need to update 1 PC instead all your client PC.

Hope this little hint can help you.

[mojoribbit]

Thanks I will give that a try. I'm still a little iffy on MTS but I guess I have an excuse to read up on it now