Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > Pro VB Databases
Pro VB Databases Advanced-level VB coding questions specific to using VB with databases. Beginning-level questions or issues not specific to database use will be redirected to other forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Pro VB Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old April 3rd, 2005, 10:02 PM
Registered User
Join Date: Apr 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Multiple ADO multiple user login Oracle9i

I have a visual basic program which uses ADO to connect to an oracle9i database. I am using MSDAORA Driver. I have modules which uses multiple ADO to connect to oracle server, the problem is each ADO connects to Oracle with different sessions which is not good because when each user uses the program with multiple ADO the number of user allowed to connect to oracle exceeds. I am new member on this forum. i will appreciate any help. Thanks in advance!

Old April 4th, 2005, 11:23 AM
Friend of Wrox
Join Date: Nov 2004
Posts: 1,621
Thanks: 1
Thanked 3 Times in 3 Posts

First of all there is not a 'thing' called an ADO. Do you mean 'multiple ADO Connection objects to connect to Oracle?'
I believe you can change the number of concurrent sessions that Oracle will permit.

Do you really need the isolation that the setup you are using creates? Could you have one global connection within the application, which you then use to open multiple recordsets? I presume someone logs into this application, and that the application then contacts Oracle for the necessary data, using that username and password.
If you are using the login of the user of the application for each connection (if 'connection' is what you actually mean), then one connection would work as well. If the username and password are different for each connection (if that is what you mean), then you do need to use independent connections.

If the user logs in, and you use their login for some things, but the application also has its own internally stored username and pasword for other things, then you would need 2 connections. But that’s not all that many, compared to what you seem to be saying is the current situation.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Login multiple db ess100 ASP.NET 2.0 Professional 1 January 16th, 2007 08:18 AM
BLOCK MULTIPLE LOGIN dayarprasad Classic ASP Databases 3 July 25th, 2006 11:01 PM
Oracle9i and ADO error?? philVT2000 Pro VB Databases 1 March 1st, 2005 11:54 AM
login to multiple web applications dhaywirex Classic ASP Professional 7 January 30th, 2004 05:26 AM
Login for multiple web applications dhaywirex Classic ASP Basics 1 January 30th, 2004 04:20 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.