|
I am developing an application using ASP which updates a SQL server 2000 database on the back-end.
I currently have a bunch of HTML forms acting as the UI. Each form collects specific information that is stored in a different table, but I want all table inserts within the session to be part of one transaction (i.e. all or nothing).
I have tried a lot of things, but I still can't get a rollback to occur when a session times-out.
I've tried specifying -
"<%@ TRANSACTION=Requires_New Language=vbscript%>"
on the asp file with no success. I even tried explicitly calling the "ObjectContext.SetAbort" method.
My hosting company swears they have transactions enabled on thier servers, so I'm thinking it must be an error from my end.
I'll appreciate any help anyone could offer me. My question is how to handle transactions with multiple
Thank you
|
|
|
|
|
this could be a dumb question but here goes ... i saw a website where they had changed the standard scroll bars (vertical ones) to be a completely different look and feel that matched the web page much better ... is there a little bit of javascript or whatever that can do that at the client or is it a server side thing?
thanks
---
situations to avoid #37: "good morning ... how many sugars do you take in your coffee ... and what was your name again?"
|
|
|
|
|
Lauren,
It can be done in the style tag at the top of the page.
<style>
BODY { scrollbar-3d-light-color:#999999;
scrollbar-arrow-color:#FFFF33;
scrollbar-base-color:black;
scrollbar-dark-shadow-color:#333333;
scrollbar-face-color:#666666;
scrollbar-highlight-color:#999999;
scrollbar-shadow-color:black}
</style>
Nick Parker
This is a non-Calculus course as long as you know things like line integrals and surface integrals...
|
|
|
|
|
thanks nick
way cool
am not really a webhead yet but am fast becoming one
hehe
---
situations to avoid #37: "good morning ... how many sugars do you take in your coffee ... and what was your name again?"
|
|
|
|
|
error report at:
set pManager = Server.CreateObject("StudentADM.StudentManager")
Error Type:
Server object, ASP 0178 (0x80070005)
The call to Server.CreateObject failed while checking permissions. Access is denied to this object.
I used ADODB.Connection, it is OK. and i used client program(with VC), this object can be accessed. Why? I don't know where should i set the permissions.
|
|
|
|
|
Check the the dlls that your object uses are in same directory with your object. And no network access.
I had same problem too, but when I put all dlls in same directory (you need to put them on same computer at least), the problem was solved. Also make sure that you compiled it. You can build a simple test application where all you need is to initialize your object, you will see then
Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer
Need Web-based database administrator? You already have it!
|
|
|
|
|
Check that the folder where the objects and any dll's used have read permissions set for the IUSR_[computer name] account, for example my user on my web server is IUSR_BUFFY.
To do this right click on the folder in explorer, click Properties/Security and add the user to the list.
If that doesn't work drop me an email...
|
|
|
|
|
Check if the user account setup to run the website has enough previleges
Reality.sys is corrupted!
Reboot the universe Y/N?
|
|
|
|
|
Is there any way of customising trace functionality so that you *only* see
the output you've specifically written and not all the other stuff?
Kevin
|
|
|
|
|
In ASP.Net, what is the a rule of thumb as to when you use server-side controls (e.g. <asp:Table> ), and when you use regular HTML elements (e.g. <table> )?
|
|
|
|
|
There's a help topic called "Recommendations for Web Controls vs Server Controls" or something, in the VS help. This will also be in the online help msdn.microsoft.com/library.
Roughly - use HTML server controls when migrating existing pages.
Use asp web controls if you want a more type-safe programming model (more properties). Also you can automatically detect which browser is being targeted. You can't do this with server controls.
Kevin
|
|
|
|
|
Hi guys, totally stumped (again). I'm experimenting with session state using SQL Server (2000). I ran InstallSqlState.sql to create the ASPState database. That went fine.
BUT, I am using Windows Authentication and now I don't know what the "sqlConnectionString" attribute of the sessionState element in my Web.Config file is supposed to look like.
I have granted my Windows login account access to the ASPState database but no combination of entries into the "sqlConnectionString" seems to work. Running the app just gives me a
"System.Data.SqlClient.SqlException: Login failed for user 'blah'. Reason: Not associated with a trusted SQL Server connection."
Not too experienced yet with setting up SQL Servers but I think I've tried everything I know and/or read so far.
Has anybody managed this??
Regards
Senkwe
Just another wannabe code junky
|
|
|
|
|
Are you running SQL and IIS on the same server?
I had major problems when running IIS on my machine local, trying to connect to a SQL database on a different server. (Standalone server, no domain)
Michael
|
|
|
|
|
Thanks for the response Michael, yes I'm running the two on the same machine. I won't be getting a new PC till late next month
All the samples I've seen show the connection string based on the fact that they are using SQL Authentication.
Regards
Senkwe
Just another wannabe code junky
|
|
|
|
|
You need to give the machinename\ASPNET account access to the SQL Server's ASPState database.
There should be a version of the correct SQL Connection string in the machine.config file located in %WINDIR\Microsoft.NET\%Version%\Config\
HTH,
James
Simplicity Rules!
|
|
|
|
|
|
Hi James, I tried out your suggestion. First thing I learned (belatedly) is that the Web.Config file sections override the corresponding sections of Machine.Config files for a particular application. Since the default state mode in the Machine.Config file refers to in process handling of session state, the default connection string is provided as such. So it didn't help, especially as I was using Windows Authentication for my SQL Server installation.
Anyway, to cut a long story short, I ended up totally screwing up my database permissions and logins, to the point where I gave up and decided to take a deep breath and start over. I basically switched to SQL Server Authentication and used the "sa" account to connect to ASPState and everything worked fine. I still think it's a bit wierd that using any other account proves to be such a pain. If you have managed to do this though, I suggest you write a brief step by step article about it because there are probably others out there like me gritting their teeth over the same thing.
Thanks again.
Senkwe
Just another wannabe code junky
|
|
|
|
|
Odd, this e-mail came to me as bounced so I didn't see it until now when I saw it sitting there and almost deleted it :-P
I haven't tried using SQL Server for session state, yet I will probably experiment with it once I find a cheap host for ASP.NET, my current host only does PHP and ASP (via an apache module).
James
Simplicity Rules!
|
|
|
|
|
Hello crowd. I'm having some serious issues with my coding.. Can anybody please take a look at this and tell me what's wrong?? Thanks...
First of all, the C# code-behind file that's causing my headaches:
[code]
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace tracker
{
/// <summary>
/// Summary description for adtracker.
/// </summary>
public class adtracker : System.Web.UI.Page
{
String strReferrer = "";
protected System.Web.UI.WebControls.Label labelMessage;
private void Page_Load(object sender, System.EventArgs e)
{
Uri uriReferrer = Request.UrlReferrer;
strReferrer = uriReferrer.ToString();
labelMessage.Text = strReferrer;
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
}
}
[/code]
And the HTML/ASPX display file, which doesn't really matter, but I'm including it for reference anyways. It just contains my Label (labelMessage) which I'm using for debugging purposes.
[code]
<%@ Page language="c#" Codebehind="adtracker.aspx.cs" AutoEventWireup="false" Inherits="tracker.adtracker" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>adtracker</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio 7.0">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
<LINK href="http://mail.forbrukerkraft.no/fkweb/webinterface/styles/main.css" type="text/css" rel="stylesheet">
</HEAD>
<body>
<form id="adtracker" method="post" runat="server">
<asp:Label id="labelMessage" runat="server" Width="139px">Label</asp:Label>
</form>
</body>
</HTML>
[/code]
Now - I'm constantly getting a System.NullReferenceException on this line:
[code]
strReferrer = uriReferrer.ToString();
[/code]
- which stumps me, since I've properly declared the strReferrer String object further up in the code, as you can see above.
There seems to be a serious gap in my knowledge somewhere here.. Can anyone try to do this on their own machine and tell me what happens? (obviously the referrer will be blank if you don't link it up from somewhere and click on the link - but that doesn't really matter - does it???)
Thanks for any help you can provide...
Henning Kilset Pedersen
Forbrukerkraft AS
IT Manager
|
|
|
|
|
When you say:
Response.Expires = -1
what exactly gets written to the HTTP header?
I'm trying to get my page to expire immediately for IE. For Netscape I can just use the "Pragma: no-cache" meta tag, but it doesn't work for IE. The problem is that I'm using JSP, not ASP, so there's no equivalent to the Response.Expires method. If I can figure out what gets written to the HTTP header, I may be able to simulate it with JSP.
Thanks in advance for your help!
Alvaro
Intellectuals solve problems; geniuses prevent them. - Albert Einstein
|
|
|
|
|
I think for IE <meta http-equiv="EXPIRES" content="May 31,2001 13:30:15"> is working fine. Never used it though, but I found it in MSDN
Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer
Need Web-based database administrator? You already have it!
|
|
|
|
|
I'm using the following:
DB.Open ("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" + "C:\personal.mdb")
And i'm getting the following errors...?
ADODB.Connection error '800a0e7a'
ADO could not find the specified provider.
How can I find the current PROVIDER version on my computer if it exists at all...?
Where would I download the newest version...?
Or am I missing something totally here as to why my webpage won't connect with the DB...?
Thanx in advance!
Cheers
p.s-I have Acess 97 on my computer and the connection string(???) is for a access 97 db...so whats the deal...? Do I have to set it up through control panel some how...?
"An expert is someone who has made all the mistakes in his or her field" - Niels Bohr
|
|
|
|
|
So I did some research and it turns out
Microsoft.Jet.OLEDB.3.51;DATA SOURCE
is the proper connection string for access 97 datbases and the one above is for Access 2000...???
My book says one thing and 3 sites I just visted says the other...???
Anyway...I tried this new connection string and still no luck, so i'm still baffled as to how to make this work.
I'm using and ASP script on PWS win 98 w/ access 97 installed...
Anyone have any ideas...?
"An expert is someone who has made all the mistakes in his or her field" - Niels Bohr
|
|
|
|
|
Yippy
I just figured it out!
I used the following:
DB.Open ("Provider=Microsoft.Jet.OLEDB.3.51;Data Source=" + "C:\PCSpectra.mdb")
And it works I think...
DATA SOURCE isn't the same as Data Source....cuz thats all I changed
Also I originally tried:
DataSource and that caused a "Couln't find a valid ISAM"
Or something like that...
Anyways...hopefully everything works now.
"An expert is someone who has made all the mistakes in his or her field" - Niels Bohr
|
|
|
|
|
It is old though. Upgrade your database components. I believe MDAC is what you need to upgrade. Go to Microsoft's site and search for MDAC download
Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer
Need Web-based database administrator? You already have it!
|
|
|
|