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. 5 1446
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.energyun ited.com> wrote in message
news:#w******** *****@tk2msftng p13.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.
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....amazin g 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*****@dnartr eb.noraa> wrote in message
news:#q******** ******@TK2MSFTN GP10.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.energyun ited.com> wrote in message news:#w******** *****@tk2msftng p13.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.
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*****@dnartr eb.noraa> wrote in message
news:#q******** ******@TK2MSFTN GP10.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.energyun ited.com> wrote in message news:#w******** *****@tk2msftng p13.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.
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.
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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 whats the max rps I can
achieve. So I installed Microsoft Application Stress Tool (WAS) and
started testing. I setup basic 2 tests page does no processing
whatsoever:
TEST 1
|
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.
They're getting an error from:
Set objCDOMail = Server.CreateObject("CDONTS.NewMail")
I know that the new format is:
|
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 that holds quite a number
of extent locks in tempdb, can be as high as 10000 locks. when I run
sp_lock on that spid, it gives something like this:
697 2 0 0 EXT 1:156760 X GRANT
|
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 the server (W2K3) it throws an
exception. It only seems to happen when serializing/deserializing _arrays_
of a type. If I just serialize/deserialize one instance, it works fine.
The exception I get is: (sorry for the word wrapping.)...
|
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 leftovers from an older version on the
system).
After that, we had to change the IP address of the system. Same
| |
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 Extensions,
along with WebDAV. I have a entry in hosts with music -> 192.168.0.152
(server). When I try to create a new C# web project using file share
in the root web, I get a message box with the message "Error writing
project file. The network...
|
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 W2K3.
I used the same install binaries in each case.
For all the W2K3 servers, the install proceeds without a hitch - but in
the case of the W2K server, I'm being prompted for an install key. I
|
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 (DFT_MON_SORT) = ON
Statement (DFT_MON_STMT) = ON
Table (DFT_MON_TABLE) = ON
Timestamp (DFT_MON_TIMESTAMP) = ON
Unit of work ...
|
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 error on them now.
The error occurs when I attempt a series of SQL statements wrapped in a
TransactionScope(). It's executing against a different server, so this is
where it's elevated to a distributed transaction.
|
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...
|
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...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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...
|
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...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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...
|
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
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |