I would suggest scapping using ODBC connections to the SQL server and instead start using ADO (ActiveX Data objects). When you connect to the SQL server - use the OLEDB provider for SQL. This way ODBC connections don't need to be set up for the individual workstation.
I am fairly new to using out of process components - I was lured by the promise of being able to have components working in the background on separate threads. So far I have had little success.
I have set up the following:
Client - instantiates out-of-process objects and fires the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.