473,324 Members | 2,417 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

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? adModeShareDenyNone 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,
adModeShareDenyNone and adModeShareDenyExclusive 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=Microsoft.Jet.OLEDB.4.0;Data Source="& MyPath
&";User Id=admin;Password=;"
conn.mode = 16 'adModeShareDenyNone -will let to open second connection
' conn.mode = 12 'adModeShareDenyExclusive -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.com
http://www.accessmonster.com/Uwe/For...ccess/200606/1
Jun 5 '06 #1
1 5304
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? adModeShareDenyNone 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,
adModeShareDenyNone and adModeShareDenyExclusive 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=Microsoft.Jet.OLEDB.4.0;Data Source="& MyPath
&";User Id=admin;Password=;"
conn.mode = 16 'adModeShareDenyNone -will let to open second connection
' conn.mode = 12 'adModeShareDenyExclusive -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
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...
6
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...
9
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...
2
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...
3
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...
1
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...
1
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...
35
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...
4
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...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.