Conn.Execute LockType

Is there any way to modify the locktype when updating a database via a connection object's execute method? I have a game which worked completely fine when only ten or so people were playing, but as it grew into the hundreds, many people started getting errors and I'm 99% sure that they occur when the database tries to update when it's locked, which means that my connection execute statements are defaulting to pessimistic locking, which I don't want them to. Does anyone know how I can fix this?

View Replies


ADVERTISEMENT

Conn.execute

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open application("dtat_motor_connectionstring")
set rs = new adodb.recordset
'Set RS = Conn.Execute(' "exec spcn_update_transactions &
customer_number, customer_name, customer_address, customer_city,
customer_state, customer_zip, customer_phone, vin,
acct_number, tag, title_number, tag_type_number, branch_number,
institution_number, yr_make, state_from, type_number)
response.write rs

%>

I'm I connecting them correctly. Is there and easier way to execute a stored procedure. I'm trying to insert data into a SQL page. I have to have the customer number returned to me asap for the next page.

View Replies View Related

SQL Conn.execute

I use this code all the time, but what does the ",,129" mean? Are there other parameters that one might use (I only do fairly simple SQL commands).

conn.execute strSQL,,129

View Replies View Related

Locktype Error

I formatted my PC last night, re-installed IIS and set up all my backed-up web pages.

When I tested everything to see if it worked everything seemed fine until this morning.

I tried to add a record to an Access DB and was given the following error:

ADODB.Recordset (0x800A0CB3)

Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.

I have not changed any of the code and this website has worked for arounf 6 months with no errors.

View Replies View Related

Recordset's LockType

i tried lots of thing, including changing the Recordset's LockType, and when it set to "4" i did not get any error, but the record wasn't inserted to the DB.

View Replies View Related

Locktype / Addrecord

I practiced my website on my local harddisk with a mdb database. Now, I upgraded to the internet using a SQL server. This works great for showing data but I can't get it to append data. On all my pages I use a script for counting the visits to that page and write it in a table.

This is the code where it goes wrong: Code:

View Replies View Related

Locktype Parameters

I am using ms-access, a database which is updated frequently (actually all the time) by users. Each use of an asp page by any user updates one record in this database.
In order to keep multiple updates to the same record, when occur, up-to-date (and of course to other records as well), and in order to avoid crash, but not slower the access, what cursortype and locktype shall I use?

adOpenDynamic, AdLockOptimistic
Or
adOpenDynamic, adLockPessimistic
Or
adOpenDynamic, adLockBatchOptimistic

View Replies View Related

ASP MySQL DB Connection Locktype Issue

I keep getting an error about my locktype with this code when attempting to update. Code:

View Replies View Related

Conn, 1,3,2

I have a some code:

Rs.Open "[TableName]", Conn, 1,3,2

RS.AddNew

RS.Fields("Account_Name").Value = request.Form("Account_Name")

my question is does conn, 1,3,2 only write to the database not making the data readable? if i change it to conn, 0,1 i get page can't be displayed. I'm using access DB, with conn 1,3,2 it inserts fine, but when i go to query it i get no records found, but i see the data in the database, anybody have any ideas?

View Replies View Related

Protect Conn.strings

what is the best way to protect the connection strings keeping an effective, low overheaded access to them ?

View Replies View Related

Problems Using Same Conn String Twice In 1 Page...

I have a problem utilising my connection string to open more than one recordset in one ASP page.

The following code runs absolutley fine on a server running ASP 3, but falls over when run on a server running ASP 2 (the error says:

Microsoft JET Database Engine error '80004005'

Could not use ''; file already in use.

The code I am trying to run is: Code:

View Replies View Related

Understand Global.asa And Conn String

I searched the forum but I am still a little confused regarding the global.asa file. I created a global.asa file and it is in the root of the virdual directory. I then created a sub to initially connect to a datase such as: Code:

View Replies View Related

Troubleshooting Access Conn. In Dreamweaver

I have 3 db connections, 2 of which are dsnless connections to access db's. Any of my previous existing pages that have recordsets from these db's work fine. I can add a new recordset to them and it works fine as well.

If I create a new page and add the same recordset in the same directory, I get the error msg saying something like "unable to open registry key" which from my understanding, means the page cant find the db.

Now I am using Dreamweaver 2004, and using their way to create connections where it creates a file, and then just adds an include statement an asp page if you use that connection.

Any good way to test this connection on the page or any ideas on how to troubleshoot where the path its pointing to is incorrect...im pretty much stuck at this point.

View Replies View Related

Conn.Errors.Count Or Err.Number For Transactions?

What is the best way to control is a transaction? I've done a little test and both of the examples below seem to do the job, but I was wondering which is the better method, this:

If err.number <> 0 Then
conn.RollbackTrans
Else
conn.CommitTrans
End If

Or this:

If conn.Errors.Count <> 0 Then
conn.RollbackTrans
Else
conn.CommitTrans
End If

View Replies View Related

Correct User, Password Sequence For DSN-Less DB Conn.?

I'm trying to access an access database by including the DB's password within the connection string. I try to connect to the DB, but I get and "Incorrect Password" error. What am I doing wrong?

set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"; uid=admin; pwd="pass"
conn.Open(Server.Mappath("maindb.mdb"))
set rsUpdateEntry = Server.CreateObject("ADODB.recordset")

View Replies View Related

Storing Complete Dbase Conn In Application Object

I am currently working on a small asp application. Now I would like to store the complete database connection in the application object. Note I want to store the connection NOT the connectionstring. For that purpose I wrote a small asp include which connects to the dbase and stores the connection object to the application object. However when I use this include in my pages then it doesnt work. What I am doing wrong? Here is the code:

View Replies View Related

.mdb Temp File (ldb) Not Destroyed After Closing Database Conn

I recently installed IIS lockdown, and ever since my ASP pages have been hell. One problem is that now after a user views my ASP page which reads my local Access DB, the temporary file, .ldb, stays in the folder forever!

This temp file is created when a user opens the file, so I checked out the .ldb file and it says the ADMINISTRATOR is opening the file! How can the internet user be using the ADMIN account?! This is not good news! I will share my code for my page; however I have a feeling the code isn't the problem, but a setting is. Code:

View Replies View Related

OLE Error On: Set Conn=Server.CreateObject("ADODB.Connection")

Error info is as follows:

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

Technical Information (for support personnel)

Error Type:

error '8002801c'
Error accessing the OLE registry.

/iisHelp/common/500-100.asp, line 154

Is ADO a separate install? And from where?

View Replies View Related

Execute A Sp

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?

View Replies View Related

Execute Every 5 Min

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?

View Replies View Related

Execute SQL

how can i setup a connection to run the sql statement? how can i embedded it in the script? Code:

View Replies View Related

Execute EXE With An ASP

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?

View Replies View Related

Execute DLL In ASP

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.

View Replies View Related

Server.execute ?

Can server.execute provide a return value? How? ie.

dim test
test = server.execute("page2.asp")

What code in page2.asp will produce something in test?

View Replies View Related

Global.asa Not Execute

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 ,

View Replies View Related

Code Execute First

<%Response.Write "Hello"%>
<html>
<head>
<javascript language="javascript">
alert("First");
</script>
</head>
<body bgcolor="#FFFFFF">
<h1>Testing</h1>
</body>

Which code execute first.

View Replies View Related

Server.Execute() &

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.

View Replies View Related

Asp Fails To Execute

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.

View Replies View Related

Dropdown To Execute

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?

View Replies View Related

Execute Problem

INSERT INTO results(id, book, book_spoke, recordType, book_title, chap, chapter, chapter_spoke, vers, verse, verse_spoke, text_data) VALUES (, , , '', '', , , , , , , '')
Microsoft VBScript runtime error '800a01b6'

Object doesn't support this property or method: 'execute'

/kjvresp.asp, line 280

View Replies View Related

Cmd.execute Select SQL?

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:

View Replies View Related

Paramater For Cnn.EXECUTE?

How does one pass a parameter to the EXEC query recordset:

set rs = cnn.execute("EXEC tblListings_qry2")

View Replies View Related

How Can You Execute C/c++ Code Within Asp.net?

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!).

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved