• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 137
  • Last Modified:

Using a RDO connection from a different program

I wrote 10 different client server applications for SQL-Server. Now, my problem is that this uses 10 different connections on SQL-server. Is it possible for a VB app to use a sql connection from a different vb app.
0
evertd
Asked:
evertd
1 Solution
 
cymbolicCommented:
Yes.  You need to do connection pooling via an OLE process to conserve connections.  That is you would write an out of process OLE database server.  It would establish the connection(s), and your client routines would perform I/O using methods to the OLE Server.  ANother advantage of this techinique is that you have consolidated all your database I/O in one piece of code, thereby making it possible to collect central measurements and to easily convert to another database.  This also provides an abstraction layer between your business logic and your database logic, and prepares you to move your application into an n-tier mode, eventually migrating your ole server through dcom into a separate machine, and distributing your application to handle higher volumes.
0
 
evertdAuthor Commented:
oke, but it is not so easy as a thought because all the programs are already written, so I have to rewrite them.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now