sharing ADO connection across multiple VB EXEs
Has anybody found a way to share an ADO connection across multiple EXEs (all
apps and components done with VB6). I want to be able to have an exe or
activex exe/document create an ADO connection, then be able to get to that
connection from inside other EXEs that are started AFTER the first EXE establishes
the connection. The goal is to have a single connection to the database
per client machine for our application.
I know that you can't GetObject on a component created in VB.
I found the RotHook/RotClock example here on DEVX and I'm reading through
that now, but it's getting pretty deep and I'm looking for any other solutions
(other than building a C++ component) to solve this issue.
The final solution may end up being to leave this alone until we move to
.NET and then build this application the right way, but for now, we are stuck
w/ the existing design from 5+ years ago that we have to maintain for the
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL