Anyone Familiar With DashCommerce?
Nov 18, 2007
I've installed it on my local machine using SQL Server 2005 Express with no problem. Now I need to install it on the server. I want to use the remote SQL Server 2005 database, but that means installing the scripts manually. I did that and thought it went well, but I'm getting all kinds of errors, so there's a problem of some kind.
I have SQL Server 2005 Express installed. I's be happy enough to use that, but I don't know how to. I tried to install and got an error that I couldn't create a database. I don't want to try to do it manually again, that didn't work very well before.
How do I do this?
Diane
View 1 Replies
Mar 31, 2004
This is what I got at the bottom of the page while reading the posts:
The log file for database 'newbanman' is full. Back up the transaction log for the database to free up some log space.
sp_BMP_RetrieveBannerFromZoneSite 49,2,50,'3/31/2004',0,0,0
View 7 Replies
View Related
Jul 22, 2007
Hi all, I'm a newbie of SQL. I built a website using SQL 2005, and the data control was using a dataset and wizard,now when I'm uploading the website + database,I learned godaddy doesn't support database uploading.I have to create an empty SQL database on godaddy's sql server, and reDir the connection in config file. my question is, where should I copy my dataset commands to godaddy's sql server?2nd, how do I invoke them in asp.net? thanks in advanceyonk
View 1 Replies
View Related
Jan 26, 2005
Hi there! I would like to return a default status value (-101) if the -100 and 200 conditions are not met. Is there any way I can go about it?
ALTER PROCEDURE spServiceFormGet (@TicketNo int, @Name char(50))
AS
IF NOT EXISTS (SELECT SolutionID FROM ServiceForm where SolutionID = @TicketNo)
RETURN -100
IF EXISTS (SELECT SolutionID, SolvedBy FROM ServiceForm
WHERE SolutionID = @TicketNo AND SolvedBy LIKE @Name
OR SolutionID = @TicketNo AND SolvedBy IS NULL)
SELECT * FROM serviceform where SolutionID=@TicketNo
RETURN 200
ELSE <--- something like that
RETURN -101 <--- something like that
Thanks,
-Gabian-
View 3 Replies
View Related
Feb 20, 2007
This is a subject that has been brought up before but I have not seen a definitive answer/solution.
We have implemented a custom authentication extension (forms authentication) for reporting services and it has been working just fine under "normal" conditions; "normal" being users logging in, viewing reports, and then moving on.
Recently some reports were created by our report group and they contain Dundas gauge controls for "dashboard" style reports. These reports are meant to be up all day and they post back every few seconds because the data they present is mission critical.
This of course exposed the inability of the reportviewer control to stay in the context of Report Manager when it comes to the cookie exchange and authentication thus resulting in the following error:
<html><head><title>Object moved</title></head><body>
<h2>Object
moved to <a
href="/ReportServer/logon.aspx?ReturnUrl=%2freportserver%2fReportExecution2005.asmx">here</a>.</h2>
</body></html>
I created a quick ASP.NET web application and added the reportviewer to it, implemented IReportServerCredentials and the report came up as expected but behaved the same way as it did in Report Manager. Same with a Windows Forms application.
Increasing the cookie timeout in the forms authentication tag is an option, but not an attractive one. Extending the reportviewer control is also an option, but I don't know if that is a good candidate right now because I don't see anything extensible yet.
Is this just the nature of RS with custom authentication or is there a viable solution out there right now?
Any and all answers are much appreciated and I thank you in advance.
View 20 Replies
View Related
