Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > Pro VB Databases
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old April 3rd, 2005, 10:02 PM
Registered User
 
Join Date: Apr 2005
Location: , , .
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!

Reply With Quote
  #2 (permalink)  
Old April 4th, 2005, 11:23 AM
Friend of Wrox
 
Join Date: Nov 2004
Location: Port Orchard, WA, USA.
Posts: 1,621
Thanks: 1
Thanked 3 Times in 3 Posts
Default

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.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 01:22 PM.


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