473,326 Members | 2,337 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,326 software developers and data experts.

DB Locks on Srv W2k3

I have a very simple database call running on a W2K3 server. I moved it over
from a W2K box. However, when it is run on the 2K3 server, it leaves a lock
on. It is an ASP page and not and ASPX page. It works perfect on the W2K
box. Anyone else have this probelm or better yet a cure for this problem? I
do not have the time to convert it to ASP.NET yet. The ODBC driver is a bit
different. One is V 4.00.6205 dated 3/2003 the one on the W2K box is version
4.00.6200 dated 6/2003.
Jul 19 '05 #1
5 1432
First, try using OLEDB instead of ODBC (see http://www.aspfaq.com/2126).
Next, show us the code that causes a lock, and how you determined that it
was caused by this code.

--
http://www.aspfaq.com/
(Reverse address to reply.)


"Rick Csucsai" <ri**@no-spammm.energyunited.com> wrote in message
news:#w*************@tk2msftngp13.phx.gbl...
I have a very simple database call running on a W2K3 server. I moved it over from a W2K box. However, when it is run on the 2K3 server, it leaves a lock on. It is an ASP page and not and ASPX page. It works perfect on the W2K
box. Anyone else have this probelm or better yet a cure for this problem? I do not have the time to convert it to ASP.NET yet. The ODBC driver is a bit different. One is V 4.00.6205 dated 3/2003 the one on the W2K box is version 4.00.6200 dated 6/2003.

Jul 19 '05 #2
Ya, I switched it to OLEDB first thing. That wasn't my prob.

After 6 or so hours of digging and pulling my hair out, I finally realized
that the user account had access to create and manipulate files in the
directory where the database resided, they just didn't have the right to
delete any files in the containing folder......

ugggg....amazing how when you are so used to not worrying about the minor
issues they will find there way back to you just to remind you that they
need to be paid attention to. 7 years in ASP and I still let something that
simple kick my butt.....just amazing
Another lesson learned in the pay attention to the new permission in w2k3
experience.
"Aaron [SQL Server MVP]" <te*****@dnartreb.noraa> wrote in message
news:#q**************@TK2MSFTNGP10.phx.gbl...
First, try using OLEDB instead of ODBC (see http://www.aspfaq.com/2126).
Next, show us the code that causes a lock, and how you determined that it
was caused by this code.

--
http://www.aspfaq.com/
(Reverse address to reply.)


"Rick Csucsai" <ri**@no-spammm.energyunited.com> wrote in message
news:#w*************@tk2msftngp13.phx.gbl...
I have a very simple database call running on a W2K3 server. I moved it over
from a W2K box. However, when it is run on the 2K3 server, it leaves a

lock
on. It is an ASP page and not and ASPX page. It works perfect on the W2K
box. Anyone else have this probelm or better yet a cure for this

problem? I
do not have the time to convert it to ASP.NET yet. The ODBC driver is a

bit
different. One is V 4.00.6205 dated 3/2003 the one on the W2K box is

version
4.00.6200 dated 6/2003.


Jul 19 '05 #3
Boy are you in luck. Just ran into the same thing. Beat myself up over it
only to be sent back to old school. It is a permissions problem on the
folder which contains the database. Forget all this hanoo nanoo about
switching to jet and such as it isn't your problem. To test, on the folder
that contains the database, give everyone full control. The problem is the
permission is ok on the DB itself but you don't have delete permission for
the folder that contains it.
"Aaron [SQL Server MVP]" <te*****@dnartreb.noraa> wrote in message
news:#q**************@TK2MSFTNGP10.phx.gbl...
First, try using OLEDB instead of ODBC (see http://www.aspfaq.com/2126).
Next, show us the code that causes a lock, and how you determined that it
was caused by this code.

--
http://www.aspfaq.com/
(Reverse address to reply.)


"Rick Csucsai" <ri**@no-spammm.energyunited.com> wrote in message
news:#w*************@tk2msftngp13.phx.gbl...
I have a very simple database call running on a W2K3 server. I moved it over
from a W2K box. However, when it is run on the 2K3 server, it leaves a

lock
on. It is an ASP page and not and ASPX page. It works perfect on the W2K
box. Anyone else have this probelm or better yet a cure for this

problem? I
do not have the time to convert it to ASP.NET yet. The ODBC driver is a

bit
different. One is V 4.00.6205 dated 3/2003 the one on the W2K box is

version
4.00.6200 dated 6/2003.


Jul 19 '05 #4
Rick Csucsai wrote:
Ya, I switched it to OLEDB first thing. That wasn't my prob.


Switching to OLEDB fixed other problems. Do not revert to ODBC. Do A Google
if you are interested in why we always recommend switching to OLEDB even
when it has nothing to do with the user's problem.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Jul 19 '05 #5
Rick Csucsai wrote:
Boy are you in luck.
Who? You're replying to your own thread.
Just ran into the same thing. Beat myself up
over it only to be sent back to old school. It is a permissions
problem on the folder which contains the database. Forget all this
hanoo nanoo about switching to jet and such as it isn't your problem.
As I said in my previous message, there are other reasons for switching to
OLEDB, even when it has nothing to do with the problem at hand: it will
prevent other problems from coming up. Use Google if interested.
To test, on the folder that contains the database, give everyone full
control. The problem is the permission is ok on the DB itself but you
don't have delete permission for the folder that contains it.


I realize that you said "To test". However you should make clear that full
permissions are not needed, and moreover, are probably a bad idea. All that
is needed is Change permissions (read/write)

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Jul 19 '05 #6

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

Similar topics

0
by: roberto3214 | last post by:
Hi Guys, How are you? I have recently begun some testing on IIS 6.0 in regards to an asp.net application. After lots of testing I decided to create a simple 1k page size webpage to find out...
16
by: tshad | last post by:
I have both cdosys.dll and cdonts.dll on my W2K3 server. We have been told by our web authors that their asp code won't work on our machine and that we don't have CDONTS installed on our machine....
2
by: New MSSQL DBA | last post by:
hi all, we have a SQL2000SP3 runing in W2K3. The application is JDEdwards. recently I've observed that once in a while (about a few hours), there would be a process from the ERP application...
3
by: Don McNamara | last post by:
Hi, I've hit quite a strange problem with XmlSerializer on my W2K3 server. When I serialize/deserialize using an exe on my local computer (XP), everything works fine. When I put the code out on...
3
by: Bernd Giegerich | last post by:
Hi, we had a strange problem with DB2 8.2 Enterprise Edition on Windows 2003 (Standard) Server. We installed DB2 8.2 (8.1.7) directly on a naked W2K3 system (no migration, no update -> no...
0
by: Richard | last post by:
Hi All, I'm having some difficulties with vs2003 and w2k3. The w2k3 Web Edition install is totally new in a VMWare box. I have added ASP.NET v1.1.4322 to the config and allowed it in Web Service...
0
by: BD | last post by:
I'm doing an install for a proof-of-concept environment; the server I'm installing to is W2K Sp4. I have installed to several servers in this environment under the same project, all of which are...
1
by: shenanwei | last post by:
I have db2 v8.2.5 on AIX V5.3 with all the switches on Buffer pool (DFT_MON_BUFPOOL) = ON Lock (DFT_MON_LOCK) = ON Sort ...
6
by: =?Utf-8?B?UGF1bCBQcmV3ZXR0?= | last post by:
Hi - I have 4 webservers in my webfarm. All Win2k3 web edition. Before yesterday, none of them were service packed. I have now applied SP2 to two of them, and I'm getting a very weird MSDTC...
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...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
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: 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: 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
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
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.