SQL Forms?
Dec 6, 2001
I have what I hope is a simple question for you all.
I have been volunteered to be our SQL admin. We've never used SQL here before. I've been studying it for a month or so now, but have unexpectedly been given a project for SQL 2000 with a deadline of next week. I have no problem with creating the database, the table, the view, and setting permissions. My problem is how best to have clients enter information. We don't want them to see previous days' information, or to see other users' information. They should enter their data only. We have a few managers who will look all at the data and perform queries. Can I give the users' a form for this? I'd rather not have them open enterprise manager and navigate through those screens; this will create a whole slew of training issues.
If someone could point me in the right direction on this, and maybe suggest a good reference manual, I'd appreciate it.
thanks,
-scott
View 1 Replies
ADVERTISEMENT
Jun 26, 2007
Afternoon
I'm getting the below error message:
Autogrow of file 'FORMS' in database 'FORMS' cancelled or timed out after 30547 ms. Use ALTER DATABASE to set a smaller FILEGROWTH or to set a new size.
FORMS.LDF file is 7613952 KBand the growth is 512MB .
By how much should I set the filegrowth? The users are complaining that the application is freezing on them.
This is sqlserver 2000.
View 6 Replies
View Related
Nov 21, 2005
hi,
as a previous user of Access, i was wondering if SQL Server provided any means of creating a Form through which I can enter in data to be stored in a table?
cheers,
token
View 7 Replies
View Related
Feb 8, 2008
Is there any program out there that will let me create a form in SQL (simiar to a form in access)
Just so all at once i can display certain information with minimal input from myself. Kind of like a SQL GUI.
Thanks
View 5 Replies
View Related
Jul 20, 2005
The below stored procedure works. However, I am trying to use a text boxfrom a temp form for the where clause.WHERE Transactions.TransactionID = [forms]![form1]![text0]I even tried changing first line:Alter PROCEDURE S3 @TID varchar (255) = [forms]![form1]![text0]And changed last line to:WHERE Transactions.TransactionID = @TIDSo far, I haven't been able to have this parameter work from a temp formwith the parameter typed into the text0 box.any help here? I get ado error near "!" or something to that affect.this below is what does work fine:Alter PROCEDURE S3 @TID varchar (255)ASSELECT Transactions.TransactionID, Transactions.AccountID,Transactions.TransactionNumber, Transactions.TransactionDate,Transactions.TransactionDescription, Transactions.WithdrawalAmount,Transactions.DepositAmountFROM TransactionsWHERE Transactions.TransactionID = @TID
View 3 Replies
View Related
Mar 14, 2007
My god.All I want to do is post the contents of a web form to a database sql express 2005 or access using C#. Why can I find nothing for this very simple process online?Can you tell I am totally frustrated? So lets say i have a few text fields and I want to click submit and have that entered into a table. I use C# for code behind. So I can do basic C# programming and I can to webforms with visual web developer 2005 dragging and dropping for textboxs and a button to the aspx page. But then the mystery begins for me. How the hell do I simple post that form data to the table. I understand connection string basics. I aslo can design and create tables. But tying this all together is becoming a problem. I don't want to use gridview formview detailview or any of that canned UI stuff. I also don't understand VB and when I see VB examples they only cloud my already cloud ASP.NET world. Please help by posting examples, and maybe some links or books to add to my newbish collection. Thanks,Frank
View 3 Replies
View Related
Jul 2, 2007
Greetings, I am in need of assistance, I have a number of SQL databases that will be used by multiple users, this database will handle all their profile data (first name, last name, ect)Could someone post an example how to apply data from a web form textbox and insert the data into SQL?
Any links or tutorials would help a ton!
Please feel free to contact me via e-mail at:swaneyshawn@hotmail.com
Thanks,
Shawn
View 1 Replies
View Related
Aug 13, 2001
I have a project at work that requires me to transfer all the data, including the queries, forms, macros, and modules from Access 97 to SQL Server 7. I was able to import the tables only using DTS wizard. Is there a way to copy the queries, forms, macros, and modules?
View 2 Replies
View Related
Nov 28, 2001
How would you link an online application form done in php to an SQL 7 server?
View 1 Replies
View Related
Feb 1, 2008
Hi guys, I've been thinking about this problem now for some time but somehow I don't know if my "solution" for it is right. I'd like to read your opinion.
There is a Capital table with Capital_Nr, Capital_Name, Capital_Population, Country_Nr and Country_Name as attributes.
I know the table is chaotic so I brought it to 3NF :
Capital table : Capital_Nr, Capital_Name, Capital_Population, Country_Nr(foreign key)
Country table : Country_Nr and Country_Name
Ok so I guess the table should be now in 3NF, but what intrigues me is in what NF the table originally was. I tried then to use Codd's definition of 2NF : "a 1NF table is in 2NF if and only if none of its non-prime attributes are functionally dependent on a part (proper subset) of a candidate key". In my opinion the original candidate keys could only be {Capital_Nr},{Country_Nr} and {Country_Name}, each one of them single, i.e. separate from each other. So, as there is no composite candidate key, I can affirm that the original table was in 2NF. Am I right ?
Thanks !
View 3 Replies
View Related
May 22, 2007
I could really use help getting form authentication to work. I have a box with a web site and ReportingServices installed(which if I can get this working will be moved to the DMZ). The databases are on a different machine(which will on on our network).
I have been working with the sample provided with the install and this blog.
http://blogs.msdn.com/bimusings/archive/2005/12/05/500195.aspx
My problem is that I can logon and authenticate but when I call ListChildren() my System.Net.CredentialCache.DefaultCredentials is empty so I get nothing back from the call.
I know that I have a valid cookie because after I logon I can use the Reports and the ReportServer URL's and go directly to those pages.
Can someone tell me what I need to do to make ListChildren() work? Do I still call ListChildren()? Documentation is scarce and would appreciate any help provided.
Thanks
-JW
View 1 Replies
View Related
May 22, 2008
is it possible to make forms authentication to reports? how cam it be done?
regards
P M varughese
View 1 Replies
View Related
Jun 27, 2006
I have created custom form without borders , i have written functions to minimize, maximize, exit and even for moving the window, now i need to write function to resize the window , is there any way resize the window...
View 1 Replies
View Related
Mar 20, 2008
Friends,
I want to display Reportviewer in MFC forms. What are the possible options for this?
Thanks,
S Suresh
View 1 Replies
View Related
Jan 31, 2008
I've implemented a membership provider and added it to Reporting Services. It works well from the user interface, but I am unclear on how to authenticate using rs.exe. When I run it with the trace option (-t), I get this back:
System.Exception: Could not connect to server: http://stsstg8642/reportserver/ReportService2005.asmx ---> System.Net.WebException: The request failed with the error message:
--
<html><head><title>Object moved</title></head><body>
<h2>Object moved to <a href="/ReportServer/logon.aspx?ReturnUrl=%2freportserver%2fReportService2005.asmx">here</a>.</h2>
</body></html>
--.
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.SqlServer.ReportingServices2005.ReportingService2005.ListSecureMethods()
at Microsoft.ReportingServices.ScriptHost.Management2005Endpoint.PingService(String url, String userName, String password, String domain, Int32 timeout)
at Microsoft.ReportingServices.ScriptHost.ScriptHost.DetermineServerUrlSecurity()
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.ScriptHost.ScriptHost.DetermineServerUrlSecurity()
at Microsoft.ReportingServices.ScriptHost.ScriptHost.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args, BaseCmdLine instance)
View 3 Replies
View Related
Aug 14, 2004
I could really use some suggestions on the best way to get the results of a pretty complex aspx form. There are a whole bunch of search criteria. Most of the criteria are ranges of numbers such as a starting number and ending number but other criteria need to search text fields for keywords. Most fields are optional which means that many values will not be submitted. Not that there is a right and wrong way to do it, but what typically works out better for these things, an aspx procedure that puts together a highly complicated select statement or writing a highly complicated stored procedure? Either way I see a ton of if statements, or am I making this a lot harder then it needs it needs to be?
Thanks.
View 2 Replies
View Related
Oct 2, 2001
Hello all, here is my question,
I have an Access 97 database linked to a SQL Server 7 db. All primary keys/relationships/ec have been created in the SQl database and I can update forms fine from the table view. When I try to use the Access forms to update data, I cannot update anything. I believe that a possibility for this may be that the Autonumbering feature of the primary key is held in SQL where before it was held in Access so the form cannot update without a number already apparent to the form but I am probably way off. I tried creating a whole new form completely based on the linked tables instead of using the old Access forms but I recieved the same results. Anyone have this problem or know how to fix it?
Thank you in advance.
View 2 Replies
View Related
Jul 23, 2005
Howdy,Does anyone know of any packages that you can create a form and via aODBC connection save the data to a table ?If it is possible to compile the form as I don't want clients to changethe forms ?Any idea/thoughts would be most welcome ?RegardsAndrew
View 4 Replies
View Related
Aug 30, 2007
hi,
How can i intergrate deployed reports with a windows forms?
View 1 Replies
View Related
Aug 6, 2007
We created a custom security extension for RS using Forms Authentication. The issue I am having is in ReportBuilder when the forms authentication ticket expires. Forms auth will attempt to redirect (send a HTTP 302) and the report builder will show the error message "Object moved to here" instead of prompt for credentials. I have been watching the IIS logs and I see the first time report builder start it attempt to connect using default windows credentials and after the FormsAuthenticationRequired exception it will prompt for credentials and invoke LogonUser method, but this only happens the first time or if change the server in the url. I was expecting ReportBuilder to consider the Forms Authentication expiration at any time.
Do you have any idea how to work around this?
Any help is really appreciated.
Thanks
View 6 Replies
View Related
Aug 2, 2007
Just wondering if anyone has any suggestions for a replacement for Access Forms once I move the tables etc to SQL 2005?
Does SQL 2005 have any form building functionality like Access?
View 1 Replies
View Related
Oct 1, 2006
We have one system that is developed using Visual Basic 6. The system connects to MS SQL database using ODBC configuration. We have another branch that has to access the same database. We've got an Internet connection with a speed of 2MB, as we tried to connect using Virtual Private Network (VPN), but the problem we faced that the system became very slow over the Internet, its taking half an hour to open one form. Is there any way to connect to the database and via the Internet using VB6 Forms? Or its not useful as its not a web based tool.
View 1 Replies
View Related
Feb 6, 2007
I'm implementing Forms authentication, but I have users stored in two different databases. The "LogonUser" method in my AuthenticationExtension gets an "authority". In that way I can authenticate the user in the correct database.
But... the problem is the CheckAccess method of my AuthorizationExtension. Is it in any way possible to reach the "authority" information from inside it? I need to grant some access to users of the first database and some other access to the users of the second database.
View 1 Replies
View Related
Feb 9, 2007
Is there a way to insert forms in reporting services. If so, how would this be done>?
View 6 Replies
View Related
Dec 8, 2006
Hi all,
I've been chasing down the multiple dataset issue.
I have a form which was created using the drag-n-drop dataset wizards.
In my project I have a form which has a DatagridView based upon a dataset.
I also have a Combo box based upon a completely different dataset.
I would like to copy the form into a new project
and base the controls upon a completely new/different dataset
which is a single dataset that has all my tables and underlying queries built in.
Does anyone know how to do this?
View 3 Replies
View Related
May 2, 2007
I have successfully implemented forms authentication in RS. It works great to navigate to https://myserver/Reports. I get redirected to the login-page etc. It also works great to use the ReportViewer from within my WinForms app, using the
reportViewer.ServerReport.ReportServerCredentials.SetFormsCredentials
method. I'm also able to communicate with RS through it's web services by first calling the 'LogonUser' method. However, to get that to work I had to inherit the ReportExecutionService for the cookie-handling to work.
Now over to my problem (the only thing so far I haven't got working). I'm trying to use a ReportViewer on an ASP.net web page to access the reports. I have understood that 'SetFormsCredentials' is not avaliable here. Instead, as far as I have understood, I should implement my own IReportServerCredentials . The critical method there I guess is
GetFormsCredentials(out Cookie authCookie, out string formsUser, out string formsPassword, out string formsAuthority)
, am I right?
It's here my problem starts. The examples I have seen haven't implemented this method since they use other types of authentication. So, I would need an example of what to fill that method with...
Regards Andreas
View 4 Replies
View Related
Dec 20, 2005
We have customized the report server to use our forms authentication. Our authentication expects a cookie.
Now if I want to deploy reports using a script, how do i do it?. I tried specifying
rs.exe <filename> <username><password> but then it does not work as the cookie doesnt exits?
Any ideas how this could be done? We do not want to use the report manager to deploy reports as we want an automated process.
View 5 Replies
View Related
Apr 11, 2007
I have some reports on a report server that needs to be reached in two ways.
1 - From a windows client application (over internet)
2 - From a web browser (over internet)
Windows authentication could not be used here, since the users are not part of any domain etc, so I have implemented forms authentication for Reporting Services as described here:
http://msdn2.microsoft.com/en-us/library/ms160724.aspx
My first task was to access the reports from the windows forms application, and I managed to do that without too much trouble using a ReportViewer and setting the custom credentials in this way:
myReportViewer.ServerReport.ReportServerCredentials.SetFormsCredentials(null, "loginname", "password", "");
Works great!
However, now I'm dealing with the second problem... accessing the reports from the web. Sure, this works fine if i just type http://myserver/reports/. This brings up the custom loginpage and if I enter correct login information I get access to the reports... The problem is that I don't want to show everything 'around' (on top of) the report, I just want to show a report. Lets say I have a webpage with two frames. One on the left with a couple of links each representing a singel report. When clicking the link the report should be rendered in the right frame.
What approach should I use here? When and where should the user authentication take place?
I have done some testing with an ASP.NET application using a report viewer, but I seem to get the error:
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'
I guess this is because Reporting services wants to bring up the login page? I can't find any way of setting the credentials for the reportViewer in my ASP.NET app, like I did in the WinForms app. I'm really not a web-developer so I might be missing some obvious points here, if I do, please point me in the right direction...
I have also read about using the Report server web service to render the html-page without using the reportviewer, but when I try to make a call to a service like this:
ReportingService _rs = new ReportingService();
_rs.Url = "http://myServer/ReportServer/ReportService.asmx";
CatalogItem[] items = _rs.ListChildren("/", true);
I get an exception like the one above, telling:
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'
Where should I go from here... any help would be much appriciated!
Regards Andreas
View 2 Replies
View Related
Feb 9, 2007
is there a way to put forms in reporting services? If so, how would this be done
View 2 Replies
View Related
Nov 1, 2007
Hi,
We had to migrate from MS Access 2003 to SQL Server 2005 due to some project requirements.
We had used Forms, earlier, to enter data to the Access database.
I understand SS2005 doesnt support forms.
Can you suggest any other way of creating an equivalent entity as that of forms, so as to enable users to enter data to the SS 2005 DB easily.
Thanks in Advance for your help,
Regards,
Sundar
View 4 Replies
View Related
Sep 19, 2007
This should be a fairly simple question. It's based on this error message:"Transaction count after EXECUTE
indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing.
Previous count = 1, current count = 0." I get this when executing a stored procedure upon processing a form. This error happens when I intentionally provide input to the stored procedure that I know should cause it to error out. I catch the exception, and it contains the error message, but it also contains the above message added on to it, which I don't want. I won't post the entire stored procedure. But I'll list a digest of it (Just those lines that are significant). Assume that what's included is what happens when I provide bad input:BEGINBEGIN TRYBEGIN TRANSACTION RAISERROR('The item selected does not exist in the database.', 16, 1); COMMIT -- This won't execute when the RAISERROR breaks out to the CATCH block END TRY BEGIN CATCHROLLBACKDECLARE @ErrorSeverity INT, @ErrorMessage NVARCHAR(4000)SET @ErrorSeverity = ERROR_SEVERITY()SET @ErrorMessage = ERROR_MESSAGE() RAISERROR(@ErrorMessage, @ErrorSeverity, 1) END CATCH END Okay, so that works fine. The problem is when I execute this with an SqlCommand object, on which I've opened a transaction. I won't include the entire setup of the data (with the parameters, since those seem fine), but I'll give my code that opens the connection and executes the query: con.Open(); SqlTransaction transaction = con.BeginTransaction(); command.Transaction = transaction; try { command.ExecuteNonQuery(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); } finally { con.Close(); } I'm calling the stored procedure listed above (which has its own transaction), using a SqlCommand object on which I've opened a transaction. When there is no error it works fine. But when I give the stored procedure bad data, it gives me that message about the transaction count. Is there something I need to do in either my SQL or my C# to handle this? The entire message found in the Exception's Message is a concatenation of the message in my RAISERROR, along with the transaction count message I quoted at the beginning. Thanks, -Dan
View 1 Replies
View Related
Apr 6, 2005
Here is what I've got so far...for some reason it's not firing off:
<code>
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim dtsp2 As New DTS.Package
dtsp2.LoadFromSQLServer("jfgp34", "sa", "@jfgp#1", DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default, "", "", "", "Test Northwind", "")
dtsp2.Execute()
End Sub
</code>
Any one with ideas helps out alot. Thanks in advance everyone.
RB
View 3 Replies
View Related
Jan 24, 2002
Our web forms have suddenly become dead slow.We use these forms to update certain tables.Both web serever and db servers are on different boxes. Db server seems to be working fine with no blocking and all other scheduled jobs are running in time on the db server.So what could be the reason??We even increased the default time out for these web forms but still getting the slow response or some times time out again.
Sheila.
View 1 Replies
View Related
