473,837 Members | 1,993 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Multiple Connections Puzzle

Hello,
What are the pre-requisites / conditions for the ability to create
multiple connections to MS ACCESS database and what is the precedence of its
application? adModeShareDeny None in the code, Exclusive checkbox in the ODBC
source, Tools->Options->Advanced->Shared in the Database Options, what else?
I have a problem when multiple connections could not be opened at the same
time from my code on one server but could be on another server. Also,
adModeShareDeny None and adModeShareDeny Exclusive work as expected in some
cases and don't work as expected in other cases. So my guess that it could be
an interaction of several settings / conditions in different places. Please,
let me know your considerations on the subject.
Examples: (this is just a relevant part of the code)

ConnString = "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source="& MyPath
&";User Id=admin;Passwo rd=;"
conn.mode = 16 'adModeShareDen yNone -will let to open second connection
' conn.mode = 12 'adModeShareDen yExclusive -will not let to open second
connection
conn.open ConnString
conn1.open ConnString

This ASP code works on 1 server and 1 laptop, does not work on another server.

If I uncomment conn.mode = 12 (Exclusive) this code will correctly allow only
1 connection to open. From withing this code. But I have no problems opening
this database from the file system at the same time(?)
Also if I have a database open from the file system I have no problems
running my code if the Database option is Shared on my workstation but if I
open the database from the file system on the web server not a single
additional connection could be established from the code. This database has
Shared checked too. For some reason it works fine on another web server.

I would appreciate your input what settings and where should I use to allow
code create multiple connections to the Access database. You may also point
me to the appropriate forum for this issues.

Thanks in advance,
Yelena

--
Regards,
Yelena Varshal

Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200606/1
Jun 5 '06 #1
1 5330
I would like this post to be visible again so "replying" to my own question.
Maybe somebody knows the answer.

Yelena

Yelena Varshal wrote:
Hello,
What are the pre-requisites / conditions for the ability to create
multiple connections to MS ACCESS database and what is the precedence of its
application? adModeShareDeny None in the code, Exclusive checkbox in the ODBC
source, Tools->Options->Advanced->Shared in the Database Options, what else?
I have a problem when multiple connections could not be opened at the same
time from my code on one server but could be on another server. Also,
adModeShareDen yNone and adModeShareDeny Exclusive work as expected in some
cases and don't work as expected in other cases. So my guess that it could be
an interaction of several settings / conditions in different places. Please,
let me know your considerations on the subject.
Examples: (this is just a relevant part of the code)

ConnString = "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source="& MyPath
&";User Id=admin;Passwo rd=;"
conn.mode = 16 'adModeShareDen yNone -will let to open second connection
' conn.mode = 12 'adModeShareDen yExclusive -will not let to open second
connection
conn.open ConnString
conn1.open ConnString

This ASP code works on 1 server and 1 laptop, does not work on another server.

If I uncomment conn.mode = 12 (Exclusive) this code will correctly allow only
1 connection to open. From withing this code. But I have no problems opening
this database from the file system at the same time(?)
Also if I have a database open from the file system I have no problems
running my code if the Database option is Shared on my workstation but if I
open the database from the file system on the web server not a single
additional connection could be established from the code. This database has
Shared checked too. For some reason it works fine on another web server.

I would appreciate your input what settings and where should I use to allow
code create multiple connections to the Access database. You may also point
me to the appropriate forum for this issues.

Thanks in advance,
Yelena


--
Regards,
Yelena Varshal

Message posted via http://www.accessmonster.com
Jun 6 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

16
7530
by: noah | last post by:
Does PHP have a feature to associate Cookie sessions with a persistent database connection that will allow a single transaction across multiple HTTP requests? Here is how I imagine my process: I have an series of interactive HTML forms. The user begins a Cookie session. A database connection is opened and a transaction is begun. After the user goes through any number of pages where they update the database they finish on a page where...
6
4452
by: Quiet Man | last post by:
Hi all, I'm designing a fairly simple service that will run on W2K/SP4 and W2K3 servers. It's job is to be a very specialized database server that listens on a given IP address / TCP port and handles multiple connections. Client programs will make a connection and pass text strings to the service, which will then return a value for each of the strings. It's unlikely the service will ever have more than 100 simultaneous connections and...
9
23089
by: Abhishek Srivastava | last post by:
Hello All, In IIS 6.0 We have a concept of worker processes and application pools. As I understand it, we can have multiple worker process per appliction pool. Each worker process is dedicated to a pool. If I assign only one application to a applicaton pool and have multiple worker processes assigned to that pool. Will my application be processed by many worker processes?
2
7134
by: jasonsgeiger | last post by:
From: "Factor" <jasonsgeiger@gmail.com> Newsgroups: microsoft.public.in.csharp Subject: Multiple Clients, One port Date: Wed, 19 Apr 2006 09:36:02 -0700 I'm been working with sockets for a short while now using a server program a former coworker started. The program listens on a port for incomming connections. When a valid connection is made (we send this init string into the socket from the clients) the server closes the socket so...
3
2303
by: D. Yates | last post by:
Hi, I'm about to embark on a project that will both send and receive information to/from our client computers in the field. The area that I still need to finalize is the method of communication and
1
13120
by: xavier vazquez | last post by:
I have a problem with a program that does not working properly...when the program run is suppose to generate a cross word puzzle , when the outcome show the letter of the words overlap one intop of the other....how i can fix this the program look like this import java.util.ArrayList; import java.util.Random;
1
1337
by: Simon Harvey | last post by:
Hi all, Quick question. I would like to use MARS to avoid lots of additional connections being opened in a certain area of code that I have (a deep load style scenario) As I understand it, it allows you to have several open data readers on the one connection. Seems pretty straight forward really. The thing that puzzles me is that in most of the documents I've read
35
9372
by: keerthyragavendran | last post by:
hi i'm downloading a single file using multiple threads... how can i specify a particular range of bytes alone from a single large file... for example say if i need only bytes ranging from 500000 to 3200000 of a file whose size is say 20MB... how do i request a download which starts directly at 500000th byte... thank u cheers
4
20015
by: honey777 | last post by:
Problem: 15 Puzzle This is a common puzzle with a 4x4 playing space with 15 tiles, numbered 1 through 15. One "spot" is always left blank. Here is an example of the puzzle: The goal is to get the tiles in order, 1 through 15, from left to right, top to bottom, by just sliding tiles into the empty square. In this configuration, the goal would be to get the 14 and 15 to switch places, without affecting any of the other squares. Your...
0
9846
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9686
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10890
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10279
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9416
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7819
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5675
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4479
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
3127
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.