|
Hello all - I need your help.
I am using classic ASP 3.0
I have a web app that will not connect to the Access database.
Error:It is already opened exclusively by another user, or you need permission to view its data. - And no else is connected to it yet. I am not using Interdev at the time of error- just IE 6.0 but it happens when Interdev is opened as well.
The web a
The web app and the db are on separate servers.
The details: Web server IIS 5.0 on a Windows 2000 platform.
The database is on the PDC - Primary Domain Controller - WIN NT
The web server is a member of the domain. THe PDC is a Windows NT server. THe IUSR_websvr account has full control rights to the database and its parent folder and that user is a member of the domain. It also has full control rights to the WINNT folder on both machines - web server and PDC. THe web app security is anonymous access and allows IIS to control the password.
The database includes tables linked to another database in the same directory. The Link path uses the fully qualified server path.
The provider string in the app also uses a fully qualified path:
conStr = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=\\Rdt_bdc\Training Tracker\trainingmonitor.mdb"
Ok I hope that I provided all the clues. When I start the web app it looks like it is trying to connect for about 10 seconds before it errors out. I believe that it is a permission problem but I do not know what I missed.
Thanks all in advance
|
|
|
|
|
By any chance, do you open the database more than once in that page? If so, make sure it closes before you try opening it again.
Another thing you may want to check is if anyone has the database open in an Access window. I know you said that no one else was using it, but just to make sure...you know. Lastly, try opening the database right after you get this error. Does Access give you a similar error?
|
|
|
|
|
Hi all,
I am trying to two things but am unable to do them.
1. I am trying to dynamically add some element in the HTML page with the help of createElement function. I am able to that correctly in IE but not in Netscape 4.7 I refered the javascript reference which says that createElement is not compatible with Netscape. So what is the other way round to do it.
2. Also I am trying to make a div element fixed in the page. That is even if I scroll down the page the div element which is a type of layer does not scroll down. It is possible in IE as:
document.getElementById("divname").style.pixelTop = document.body.scrollTop;
but it is not possible in Netscape4.7 as netscape does not support scrollTop. What is the other way round to do it.
Please help.
|
|
|
|
|
My universe consists of 4 million+ records. If I were to compare one record against the universe, how much time would I take using SQL Server 2000.
"The Saint"
Sashidhar S Kokku
|
|
|
|
|
The Saint wrote:
If I were to compare one record against the universe, how much time would I take using SQL Server 2000.
Do you mean: How long would it take to retrieve one row from a table using SQL Server 2000?
It depends on a number of factors. The size of the rows, the index you are using in the filter (the WHERE clause of the SQL statement) or even if there is an index, disk contention (the HDD is a shared resource, other applications will be using it, along with potentially other users of the database) and so on.
If you want to gauge performance of your database then you just have to measure it. Certain things will obviously speed things up. e.g. Placing an index on the columns you are searching on will speed up SELECT statements. Removing indexes will speed up INSERT statements. You have to balance your needs.
Do you want to know more?
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums
|
|
|
|
|
How to execute an exe file without the save, open or autthentification dialog box
|
|
|
|
|
execute an exe...???
You can't on a users local machine...but you can instantiate an exe on the server using location.href
It's frustrating being a genius and living the life of a moron!!!
|
|
|
|
|
I need to know how does one prevent a user from submitting a form in classic asp twice? My page AddClient.asp has all the input fields, and when done, goes to the AddClientProcess.asp page where addition to the database is done. The data type for the id used is auto-numbering. So lets say the user presses the refresh button then the data gets added again becuase of auto numbering.
And how is this done in ASP.NET as well?
Thanks
|
|
|
|
|
Add an OnSubmit handler to your form. In that onsubmit handler, simply make the submit button disabled.
EX:
<html>
<head>
<script language="javascript>
function FormOnSubmit() {
document.forms[0].elements["SubmitBtn"].disabled = true;
}
</script>
</head>
<body>
<form method="post" action="AddClientProcess.asp" onsubmit="FormOnSubmit()">
<input.....
<input type="submit" name="SubmitBtn" value="Save">
</body>
</html>
onwards and upwards...
|
|
|
|
|
hai...
i have date data in my database... In my system i want to track back the data in database using search function between 2 date..for example i want to track data between date1 and date2 in my database...
help me to find the right code
|
|
|
|
|
What database are you using? In SQL Server
select * from table where date between '1/1/2004' and '1/1/2006'
<italic>Work hard and a bit of luck is the key to success. You don`t need to be genius, to be rich.
|
|
|
|
|
i am adding database seperately after installing database is there any way that my database can be bundled with the package ... ty all in advance i am new to dot net and programming
application is in ASP.Net using VB.Net and with SQL server as backend had similar problem with VB 6.0 and SQL Server
thanks again in advance
|
|
|
|
|
Hi. I'm new to asp.net and I wonder if I can get rid of the dropdownlist that my textboxes automatically creates containing strings from previous inputs. I use asp.net and c#
|
|
|
|
|
You can use AUTOCOMPLETE="OFF" inside the FORM tag.
It's frustrating being a genius and living the life of a moron!!!
|
|
|
|
|
|
I'm planning to use google search engine for searching content in my website created by Microsoft CMS 2002.I've tested Google free search code with my website but it doesn't work.
1. Is it possible to use Google Free site search with web sites created by CMS2002?
2. If someone has knownledge with this case,Please recommend me how to search CMS content using Google search.
|
|
|
|
|
It seems that for some reason, the JavaScript function encode() returns an ASCII encoded string regardless of the pages explicit setting to 'utf-8' (I'm testing in Exploder 6).
This means that the ASP.NET Request object will dismiss all the special characters encoded as '%XX', because it expects them to be in the form '%uXXXX'.
Does anyone know, of the correct method to use for encoding to UTF8?
"After all it's just text at the end of the day. - Colin Davies
"For example, when a VB programmer comes to my house, they may say 'does your pool need cleaning, sir ?' " - Christian Graus
|
|
|
|
|
Please help me...
In my system..I want to create function in ASP form where user can search data in between 2 date..For example : user can search data in between 1/02/2005 and 4/02/2005.
thank you..for helping me
help me to find the right code
|
|
|
|
|
but what will the user search for?? I mean, is the required date a field of a table in a database, or something else.
Clarify the question by providing some detail.
|
|
|
|
|
Hai there....
i have a problem in my system...i want to create a running in my asp form..
for example, went i open my asp form the number will count 1 and then went another user open the same asp form, the number will count 2. So the number will kept running in the system...
please help me.;)
help me to find the right code
|
|
|
|
|
Try searching for "Page counter"
<italic>Work hard and a bit of luck is the key to success. You don`t need to be genius, to be rich.
|
|
|
|
|
We are using Ensim 4.0 with MailEnable for Windows 2003. I am having an issue with these programs not automatically creating a virtual directory for the webmail when a new domain is created so I have to find another solution. We need this task to be automated so whenever a new site is setup the webmail will be available.
My options are to find a script or how to write one that will check all the websites and create a virtual directories for any sites that don't already have one for webmail... or implement somekind of redirection where if someone enters a domain name with the text /webmail in it, it will auto redirect to the proper webmail site
This task needs to be automated somehow as we have resellers who add websites and do not have access to setup the needed virtual directory for our webmail site
|
|
|
|
|
is it possible to do the folling with a href i want when they click on the link for it to do the function getfile
<A href="vbscript:getfile("<%server.MapPath(download\PN to AN Conversion Wksht.xls%>")">PRENEED TO ATNEED CONVERSION WORKSHEET</A>
<%end if%>
<script language=vbscript>
function getfile( file)
'cma getfile
Dim objgetfile
Dim bitstream
Set objgetfile = Server.CreateObject("bitstream.bitstream")
bitstream=objgetfile.getfs(file)
Response.ContentType = "application/x-download";
Response.AddHeader("Content-Type", "application/x-download");
Response.AddHeader("Content-Disposition","attachment;filename=example.xls");
Response.BinaryWrite(bitstream);
End Function
</script>
chad
|
|
|
|
|
Why not just make the file the href of the link, ala standard HTML?
<a href="download\PN%20to%20AN%20Conversion%20Wksht.xls"> PRENEED TO ATNEED CONVERSION WORKSHEET</a>
|
|
|
|
|
<A href="download\PN to AN Conversion Wksht.xls">PRENEED TO ATNEED CONVERSION WORKSHEET</A>
<A href="download\PN to AN Conversion Wksht.zip">PRENEED TO ATNEED CONVERSION WORKSHEET</A>
i have both of these links on my websit and the one with the zip file opens a save as box but the one with the .xls file opens excel in my web browser is there a way i can stop excel from opening and force them to download the file
thanks
chad
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
