I tried to run 2 queries in single connection. But it doesnt work to the second query
page will return an error but execute the frist query only. How can i solve this problem.
I'm using Microsoft Access 2000. Here are the code an error that return
Dim objConn, strSQL1, strSQL2
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "DSN=egbit_dev;"
strSQL1 = "Update ADM_USERTAB Set USER_PWD = '" & new_pwd & "' where USER_ID = '" & userid & "'"
set rsUpdate_Pwd = objConn.Execute(strSQL1)
strSQL2 = "Update EGBIT_PWD_STATUS Set password_status = 'change' Where user_id = '" & userid & "'"
set rsstatus = objConn.Execute(strSQL2)
error :
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
( it refering to line that execute set rsstatus = objConn.Execute(strSQL2) )
I'm using an access database and found following problem :
I have a table X with 2 records : record 1 & record 2. I execute following procedure with 2 steps :
1. The procedure deletes records 1 : connection.execute "delete from X record 1"
2. The procedure adds record 1 again using the recordset object.
Result : nothing happens !
I have the feeling that the "delete" statement is executed AFTER the "add record" statement. Or the "delete" statement did not finish before the start of the "add record" statement (= asyncrhonous processing).
Can somebody explain me this behavior ? I have this problem only when using a MS Access database and not with an MS SQL database.
I 've coded an asp webpage where a user could toggle a boolean value through a checkbox. When the checkbox was pressed, the page posted the toggle action to itself, a
connection.execute "UPDATE tableName SET fieldName=(Not fieldname) WHERE field_id=1
query was performed and the checkbox, after I had retrieved its new value through a recordset, changed its appearence(state). At first I used an MS Access DB and it worked fine.
After I had switched the hole application to work with MS-SQL, although I changed the above query to Code:
Using ASP, I would like to write down to the HTML the time taken to execute a query. I am trying to optimize my SQL queries in the ASP page. So I want to determine if my SQL query is optimal or not. So how can I determine how much time it took to execute the query and return the results. For example, something like: It took 5 seconds.
My code retrieves a username and a password from a form. Then this information is compared to some usernames and passwords that are stored in a database. The important thing here is that the comparison must be case sensitive meaning that "passWord" is not the same thing as "password"
I have this code, working fine in access 2003
SQL = "SELECT * FROM users WHERE StrComp(username_column,'" & entered_username_in_form & "',0) = 0 AND StrComp(password_column,'" & entered_password_in_form & "',0) = 0"
but get the following error when I run it against my sql 2005 database.
[Microsoft][SQL Native Client][SQL Server]'StrComp' is not a recognized built-in function name.
I don't know the corresponding t-sql for the query.
I am running a querry on an access database and have set the number of records/page displayed at 20. if there are more than 20 records returned, then 1st page will show the first 20, the next page will show next 20 and so on....
The trouble:
the count of total records displayed is correct and the first page is displayed correctly. But when i click on *Next* to go to the next page, all the records of the database get displayed (not the 2nd page of records from the query).
I wanted to know wheather DSN is ok for the connection to a database or direct conection is better?
when i started my web project on dreamweaver i had to make a DSN connection as i have followed the books, but as now as i have also asked several questions on this site, i have aslo implemented a direct connection as well on some pages, now i am wondering is this going to have any affects when i uplode the complete site on the server.
i have noticed that on my computer when i am testing the site and uploading new records on sections that have DSN connections you can see the new record but on sections that i have implemented direct connection i cannot see it coz it is linked to the local directory database not on the testing server.
i have also never experienced uploading to a IIS server with DB connection so its my first time with dynamic websites. so am i in trouble or its ok the way i have done my site..
WEll I see that this issue is not yet solved ... So here's some more beef... There is an update the first part of the query that takes ~50 seconds and the connection gets cut off at 30 sec sharp. Logical as the default value us 30 sec. question :Does anyone know how to increase that value? I can't do it in the udl , it reverts back to nothing. Option: [1]I would/could also optimize that update using a hint to fasten it [2] Or try to execute the proc without using the dsn?
Using ASP 3 on an ISP account (I don't have access to the root of the server). I have a page that does some intake processing and I'd like to have it run every 5 minutes. Right now, the only way I can see to do this is to have a client task that wakes up every 5 minutes and opens that page.Is there a better way?
I recently moved an app over to IIS 6 from IIS 5. Everything works great! I use ASPExecute to run an .exe - but it doesn't fire. It just sits in the process window. Doesn't do anything. Is IWAM, or IUSR or both required to run it?
I need to use a VB6 dll like an ActiveX in ASP page. This dll use other .exe that is configured en DCOMCNFG and this dll is configured too in the same environment (DCOMCNFG) like a DllSurrogate with an specific user administrator.
I don't know how to configure this dll & IIS to it works with Anonymous authentication. I need to do this because is a development that it works in an Internet environtment and I can't assign a administration user in IIS 5 to the anonymous user.
my global.asa file doesn't seem to be executing in IIS and i don't know how to make them run. Any ideas how to execute the global.asa file in IIS 5.1 ,
In Page1.asp I am calling Server.Execute("Page2.asp"). Before calling Server.Execute(), I set an application variable to a value that it is important for me to know that it doesn't get accessed by another ASP page before I call Application.unlock in Page2.asp, that is why I use Application.lock. According to the documentation, Application.lock gets automatically unlocked when the ASP page terminate, I want to confirm that calling Server.Execute() doesn't automatically unlock the application, i.e that Page2.asp will start executing when the application is still locked.
after publishing a web to iis, asp pages based on a database fail to work. the browzer starts loading such page and never does- at some point the status bar stops and the page never loads without displaying any errors. the browzer shows that it is busy all the time.
what If i wanted to have a dropdown that executed a query based off the selection. so i have a dropdown on page and when they make there selection it queries other data with out submit?
What is the proper format for my SQL str using command.execute? Even though I know I have matching data in my table, I keep coming up with a ..RecordCount of -1. What am I doing wrong? Code:
I am extrememly new to C (only been playing with it for a few days), and will be am required to be using C and ASP.NET (also a language i have only been using for a couple of days) for work purposes in the next few months. I come from a mostly Java background where it was easy to write JAVA code, and provide web interfaces that made use of that code in JSP.
I would be greatful if anyone can tell me...
a) Is the same effect possible using ASP.net to access / execute etc C/C++ (not interested in c# code - all the explanations of this seem to cover c# only - or is there no difference? - Spot the newbie! lol) code (pretty sure that works - but be good to know incase there is another step in there).
b) Where can i learn more about it? Can you suggest any weblinks or books etc?
Incase it makes any difference - the sort of code i am interested in running would simply respond with results from databases, or extracted content of files etc (command line stuff) - and much of the code is already written in c / c++ so i am not keen on re-writting it specifically for asp.net (does that make sense? hope so!).
I am getting "Failed to execute request because the App-Domain could not be created. Error: 0x8013150a"in the event log and "HTTP 500 error" in Visual Studio.when I create a new ASP.Net project. When I browse to an already existing application Internet Explorer shows Application Unavailable page
with dos command of " ipconfig/all>c:ip.txt " I can retrieve some info and save it in a text file of ip.txt, now I am wondering if there is a way to do the same thing within asp?
The web server is running on IIS with asp. I'd like to know how do you execute #include with asp in a file with extension .html. The codes work fine with .asp but I'd like to do this in .html.
