ASP Access Transaction Log
I have an access database for a hotel room list which includes how many rooms I have available for each hotel. This list is updated via a form that updates the database, either adding or removing rooms. The database is on the server and is accessible by four employees, each of whom can update the hotel room number as they sell them.
The hotel rooms are in a table and this table is updated and records who updated it last by overwriting the previous update entry. I want to create a log file that records ALL updates each time the form is submitted, so I can track all transactions. I have not found any info on how this is done. Do I need to create a secondary table that only records when the form is submitted and database is updated?
View Replies
ADVERTISEMENT
I am trying to find out if Access is capable of utilizing the transaction function of ASP. I have seen differing points of view online and am looking for clarification
I have 2 inserts that run. If the second fails (for whatever the reason), the first should be rolled back.I have to use Access - is this the way to go or is there another option?
View Replies
View Related
I am using 2 stored procedure in my asp application. in my asp page i execute 2 stored .. their works depend on each other. i want to apply a transaction on these. must i apply it in stored procedure or in asp page.. any example or any link. can u help me about transactions.
View Replies
View Related
I'm trying to determine if I can use transactions in my ASP applciation against one of our Oracle 9i databases. My WROX manual says I can do this if the Transaction DDL property of my connection object is equal to 8. I've checked my connection properties with the following script and determined that my Transaction DDL property is 2
'============================================
Set conn = Server.CreateObject("ADODB.Connection"
conn.open Session("PROVIDER")
For Each Item In Conn.Propertie
response.write Item.Name & " = " & Item & "<br>
Nex
'============================================
But what is 2? MSDN (http://msdn.microsoft.com/library/d...oprg04_83jt.asp) says there are a number of possible vaues for Transaction DDL such as
DBPROPVAL_TC_NON
DBPROPVAL_TC_DM
DBPROPVAL_TC_DDL_COMMI
DBPROPVAL_TC_DDL_IGNOR
DBPROPVAL_TC_DDL_LOC
DBPROPVAL_TC_AL
But which one relates to value 2
View Replies
View Related
I have problem i need to carry out a transaction on a ASP page... the page goes like this:
<%
Conn.execute (Sql) ' Where the Sql Gets the Set_Number froom Table1
Conn1.execute(Sql1) ' here the Sql1 inserts the Value (Set_Number + 1 ) 'into the Table2.
%>
This page should be Executed as a transaction or else please help me out how to lock tables so that no other person can execute the same page with same data simultaniously...
I dont use any components in this page..so now how to go about with this...????
View Replies
View Related
In asp.net, there is an object sqltransaction we can use to garantee the
data will be written to database either completely or none will be written
into database.
I am not sure if there is a similar thing I can use in classical asp.
Can you provide some info
View Replies
View Related
I have builded a web site that performs db queries and insert records, and I'm getting a overwhelmed amount of hits. Which was good but it created a big problem. I ran out of db connection licenses, because the way I did it, it opens/close a new db connection for every db action.
I read something about opening the db connection at the application level but most people think that's a bad idea.So I tried looking into MS Transaction Server but I don't know where to begin. I need to know how I could use it and how I could set the # of db connection allow.
View Replies
View Related
I have a Bill table (tblBill) and there is a running bill number being stored for each transaction (1001,1002,1003...). This running number is not from mssql identities.Currently i am using "SELECT MAX (billnumber) FROM tblBill" and + 1 to get the following running number and store the next transaction.
This method works well if each transaction execute one at a time. Now i am having problem when there is more user executing the transaction concurrently. Sometime i will have 2 different transaction with the same bill number.How do i control so that a transaction will only execute at a time or using my method above is just rubbish? I am hopping this to be solve in ASP rather than in MSSQL.
View Replies
View Related
I looked everywhere, but I can't seem to find an example of a transaction in MySQL using asp. I need an example of the following:
1. Add a record to a table
2. retreive the last inserted id
3.add to a second table
these steps have to be in a transaction. so I would need to check for errors too.
View Replies
View Related
According to Access my ADO connection has a value of 16 for the Transaction DDL property. Does anyone know what this equates to? I've found this page -
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/adosql/adoprg04_83jt.asp
But it doesn't tell me which constant this relates too, and I haven't been able to find an answer at Google either.
View Replies
View Related
if it is possible to do recurring billing to Authorize.net using ASP Classic. I have no problem doing one time transactions.
View Replies
View Related
how can I apply transaction, commits and rollbacks to a lot of inserts in one script?
View Replies
View Related
I want to know,
. Operation Behind the Online Money Transaction.
. If Once The client paid the money,
. How is it validated..( Credit Card)
. Also how Can the Admin of the Site will get the Money from the User.
View Replies
View Related
I have a page that uploads an xml file and reads it into a SQL database. The
page is transactional and aborts if there are any anomalies in the xml.
My problem is that the if I repeat an identical import the transaction
succeeds the first time and then fails the next time. This pattern continues
with subsequent repeats. I have removed all of the ObjectContext.setAbort()
calls but still the onTransactionAbort() sub is called.
View Replies
View Related
I have a Development server that is running Win2k, IIS 5.0, and ASP enabled. I am trying to gain access to an Access 2000 DB located on a file server within my domain. I'm pretty sure I have all the correct permissions set, but I am having problems when trying to access the DB.
The error is similar to:
The Microsoft Jet Database engine cannot open the file '******'. It is already opened exclusively by another user, or you need permission to view its data.
I'm looking for ways to fix this... Microsoft suggests turning off the ability for IIS to sync passwords. Unfortunately, this is not a viable solution for me.
Is it possible to create a new virtual server that is a share to my file server? Put my ASP and MDB file in there and have it work? Anyone have any other ideas?
View Replies
View Related
I'm working on a site that inserts records into an Access database and Access assigns an auto-incrementing id for the record. How can I quickly figure out what id that was just created? I seem to remember there being a function for this....
View Replies
View Related
I want to move my only window shosted client to linux. The site they have access a Microsoft Access database with the below code but i can't get it to work under Linux.
<code>Dim MM_connPang_STRING
'MM_connPang_STRING = "dsn=pangDSN"
MM_connPang_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:clientdatabasepangDB.mdb"</code>
View Replies
View Related
I'm trying to access a table in a MS Access database using ASP but the name of the table is causing me some trouble. The problem is the table name has a space in it eg, "My Table".
If i try and access it using a query "SELECT * FROM My News", it says i cant find table "My". If i remove the space from the name (to MyTable) it works fine. But the trouble is its a customers database and i cant easily rename it because its linked to other tables and db's.
How can i access a table with a space in its name? I've tried "SELECT * FROM My_News" but that doesnt work either.
View Replies
View Related
I have an ASP page needs to access a remote MS Access2000 database, I got error "The Microsoft Jet database engine cannot open the file 'F:Collect.mdb'. It is already opened exclusively by another user, or you need permission to view its data. ".
The 'F:' is a mapped drive from remote machine where the access database loactes. If I copy the database back to local box, no problem.
View Replies
View Related
I'm looking to make an online multiplayer game which will utilize Access Database... basically I require thousands of people writing and reading from the same database... I was wondering if this is possible for that... or is mdb file restricted to 1 person at a time...
If it is limited what would you suggest as the best way to control an interactive online environment? .txt files possibly?
View Replies
View Related
What is this all about? Generally I run against SQL Server but now I have to use access. The query I want to run is a simple double join
SELECT tblArtists.*,tblGenres.name AS genreName,tblPages.pageId
FROM (tblArtists
INNER JOIN tblGenres ON tblArtists.genreId = tblGenres.genreId)
LEFT JOIN tblPages ON tblArtists.artistId = tblPages.artistId
ORDER BY surName ASC, firstName ASC
Now If I run this question in access against the database it accurateley returns two posts. BUT When I paste the same query into an asp document and runs it with a fileDSN against the same database it returns nothing!? Is this some kind of joke from Microsoft?
View Replies
View Related
I have an Access DB which contains couple of link tables. All these tables are from different databases. So each one has it's own database password. Since there is no way to save the password during the DSN creation. Then you need to manually type in the password each first time when open the table.
This causes the problem in ASP code during run a query. Since the table cannot be accessed due to the password protection. Is there any statement than can open a table and meanwhile pass the password in? Does anyone experienced with the similar situation?
View Replies
View Related
I generate my codes using a generator. My problem is that I can not write into my Access database. I had gone to tools to allow access permission . still nothing.
View Replies
View Related
I have a MS Access file that consits of 500 movie titles, I already upload this file onto Brinkster.com, but I don't know to code this into ASP or PHP so I can have an on-line database. Please help me code this Access file into an ASP or PHP file.
View Replies
View Related
I have a field in my Access db which is used to put a category against a company, rather like Yellow Pages. The categories are held in another table in the same db. The Category field in my companies table is a look up field using this syntax
SELECT [categories].[ID], [categories].[Category] FROM categories;
My problem is when I want to list a company and do a response.write rs("Category") I get the ID relating to that category rather the description. How can I get the description instead?
View Replies
View Related
I am using Access and ASP.I am just trying stuff out.I created an access database and put some validation in access on some fields.
I created an ASP program to insert into my database.
When I try to insert a record that validates OK with access rules all is fine.
Then I type input that violates the access rules; I hoped to get a helpful message back.
All I got was my message saying an error had occured and it was Error number 0 and native error 2097228.
As I was testing I know it is due to failing a validation in access.
I am learning I wanted to look up this native error, I cannot find it in access help or internet searches where would I look for native errors please?
I know I need to validate client side that is not the issue it is understanding native errors!
View Replies
View Related
I'm trying to search the Access database using 3 fields and I think there's a problem in my If statement...pls check it out for me.....I'm using ASP...this is what I'm trying to do:
If Request.Form("txtUser_Id") = "User_Id" and Request.Form("txtWeekNo") = "WeekNo" Then
strSQL = "SELECT (MSD + Methods + Analysis + Architectures + Models + Studio + Elective1 + Elective2 + Elective3) AS PersonTotals, FirstName, LastName, WeekNo, Semester, StudioTeamName FROM tblpersons"
strSQL = strSQL & " WHERE Semester=" & Request.Form("DaInBox")
'strSQL = strSQL & "WHERE Semester ='" & strSemester & "'"
End If
View Replies
View Related
I'm planning to change my database from MS Access to an SQL database. So, what do i have to change in my code for that?Is it possible to have multiple tables in SQL which are linked to each other?Are there pro's and contra's ?
View Replies
View Related
I made a little app that selects data from a database depending whether there is a NO, in the YES/NO column. The data is exported to a txt file with aso. What i'm wondering is, is after the data has been downloaded to that txt file, how to write to the database saying all they were marked NO, go to YES.
View Replies
View Related
I have never dealt with XML before, So this is way out of my realms...
I am trying to get a XML feed into an Access Database..
The XML source can be found here:-
but as you can see.. there is another problem.. the file is in a .GZ format.. so i need some way of Un-Zipping it onto my web host, and then importing the XML data into the database..
Ive looked around, and the only information i can find is un-zipping it onto a local machine, and then uploading the XML file.. but that's not practical.. i don't want my web page to be dependant on my PC at home being logged on...
As for the import of the XML to Access... that's another black hole there.. ive never done anything like this before..
View Replies
View Related
I'm still very much on the learning curve when it comes to writing ASPs and have always used Access for my db. A colleague in work has told me that I should never use access on a commercial site where I'm likely to get a lot of traffic. Is this correct, is Access totally unsuitable?
View Replies
View Related
Alright, I am opening an Access XP database via ASP. One of the fields is a numerical field, and I would like to force it to display the number + 1 digit to the right of the decimal. For some reason it is only displaying digits to the left.
In Design View, my Access Table (names 'arlist') looks like this:
Field Name: level, Data Type: Number, Field Size: Integer, Format: Fixed, Deciaml Places: 1
My SQL Statement: SELECT * FROM arlist;
Then the VBScript I'm using to access the table looks like this:
Response.Write"<TD align=""right"" bgcolor=""" & strBG & """ width=""10%""><P class=""body"">" & rsDC.Fields("level") & "</TD>" & vbCRLF
I am opening the table via ADO Statically with a Read-Only pointer because the page just displays the contents of the table. I've tried everything I can think of to preserve the decimal place. If I view the table in Access, the decimal places are correct.
View Replies
View Related
I'm trying to connect an access database to a asp page, but whatever i do, it just doesn't work. Code:
View Replies
View Related