GUI Forms In SQL

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



ADVERTISEMENT

Autogrow Of File 'FORMS' In Database 'FORMS' Cancelled Or Timed Out After 30547 Ms.

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 Replies View Related

Help Forms

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 Replies View Related

SQL 6.5 Web Forms?

I am looking for a way to create simple web forms in which a user can update data as
well as see it. Rather than build an Access app to do this I thought a web based mini app
would suffice. Can anyone give me some info on the Web wizard and if possible how to do this.

Thanks in advance......Mary

View Replies View Related

SQL Forms?

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 Replies View Related

SQL Forms?

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 Replies View Related

XML Forms

Hi
i have this idea and ireally want someone to help me here!
i am trying to analyz a system that could have more than 5 forms ,this forms has different contenet ,but i wont use more that one table for every one form ,so i have the idea to store every form in an XML field ,let us say we have a table "tblForms" this table has three coulumns ,ID ,XMLForm and XDS(xml data schema),so whenever i want to read any entered form i can use the XDS field to parse the XMLData field contenet , is that right ,i mean could i do that in real??
thnx

View Replies View Related

SQL Insert + Web Forms

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 Replies View Related

Help! C# - Forms - Datasource

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 Replies View Related

Using Forms With Sql Server

I'm looking for some good forms software to use with Sql ServerDon't want use Access Forms, maybe a Third party softwarecan anyone recommend a package ?Andrew

View Replies View Related

Importing Forms

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 Replies View Related

Linking Php Forms To SQL

How would you link an online application form done in php to an SQL 7 server?

View Replies View Related

Normal Forms

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 Replies View Related

Custom Forms

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 Replies View Related

Forms Authentication...Can It Really Be Done?

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 Replies View Related

Forms Authentication

 

is it possible to make forms authentication to reports? how cam it be done?
 
regards
P M varughese

View Replies View Related

RS With Forms Authentication From A Web App

Hey, i'm kind of new to the world of Reporting Services and for my first project i am trying to create a web app. that can open and display reports from RS. In addition to this i want to use Forms Authentication to restrict what users can see. I think i've correctly understood the basics of Forms Authentication, but there's a couple of things i'm not sure about. I can get Forms Authentication working fine with Report Manager. From my web app. i call the LogonUser() method on the RS web service, which in turn calls my custom authentication LogonUser() method. My question is how can i tell from my web app. that a login has been successful. My custom authentication LogonUser() method returns a boolean to indicate the result, but since i'm calling the web service, whose LogonUser() method has a return type of void, i have no way of knowing the result of the login call. Should my custom LogonUser() method be setting something to indicate a successful login?
Any help on this would be very much appreciated, apologies if i've completely missed the point on this

View Replies View Related

Reportviewer In MFC Forms

 

Friends,
 
I want to display Reportviewer in MFC forms. What are the possible options for this?
 
Thanks,
S Suresh

View Replies View Related

Using Rs.exe With Forms Authentication

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 Replies View Related

Strange Problem In The Forms

i have a form with some contols to update a databse record using the sqldatasource
<asp:SqlDataSource ID="dsfreelancerinfo" runat="server" ConnectionString="<%$ ConnectionStrings:freelancerConnectionString1 %>"


SelectCommand="SELECT * FROM [tblFreeLancer] WHERE ([FreeLancerEmail] = @FreeLancerEmail)"
UpdateCommand="UPDATE [tblFreeLancer] SET [FreeLancerFName] = @FreeLancerFName, [FreeLancerMName] = @FreeLancerMName, [FreeLancerLName] = @FreeLancerLName, [FreeLancerEmail] = @FreeLancerEmail,[FreeLancerCV] = @FreeLancerCV,[FreeLancerPicture] = @FreeLancerPicture, [FreeLancerIntro] = @FreeLancerIntro, [ViewProfile] = @ViewProfile, [FreeLancerBirthDate] = @FreeLancerBirthDate WHERE [FreeLancerID] = @FreeLancerID">


<SelectParameters>
<asp:Parameter Name="FreeLancerEmail" Type="String" />

</SelectParameters>

</asp:SqlDataSource>
 
when i click on the update button the value return from the form field doesnot change as the text in the field changed, the old data always showed up
example
<asp:TextBox ID="txtfname" runat="server" CssClass="input" Width="96px" EnableViewState="false"></asp:TextBox>
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs)msgbox(txtfname.text)end subeven if i changed the content of the txtfname control i keep displaying the old data in the controlplease helpppp

View Replies View Related

Complex Data Forms

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 Replies View Related

Repost : Using Forms With Sql Server

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 Replies View Related

Displaying Images From SQL 6.5 To VB 6.0 Forms

I have a SQL Server 6.5 database that has an image field in one of the tables.
I can retrieve the image from the database. However, when I try to display
it on a VB 6.0 form I get "Type Mismatch". Below is the code that I am using.

Dim objPic As Picture

Set objPic = LoadPicture(rs("EepPicture"))

Set Image1.Picture = objPic

The images are stored on the network as JPEGs but when I retrieve them from
the database all I see is the hex code. Could someone please tell me what
I am doing wrong?


TIA
Nate

View Replies View Related

MULTIPLE ENTRY FORMS

I WOULD LIKE TO MAKE A MULTIPLE ENTRY FORM IN ACCESS, I HAVE BEEN TOLD THIS IS NOT POSSIBLE. I NEED TO BE BE ABLE TO ENTER A SSN AND EDIT A FIELD IN A TABLE, BUT I NEED TO HAVE IT PROMPT EVERYTIME FOR THE SSN.
KELLY HOBBS

View Replies View Related

Updating SQL With Access Forms

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 Replies View Related

Using Forms To Update Database

Hello all,

I trying to develop a incident reporting application the security personnel can use to report incidents. I have a SQL Server 2000 back end and an Access 2000 front. I created three tables, Incident, Suspect and IncidentSuspect (junction table). The incident table is an old table with information still in it. I added the suspect and IncidentSuspect tables to make the database in proper form. I want the user to be able to enter an incident in to a form, and then add a suspect(s). The problem I’m having is how do I update the junction table so each incident will reference the right suspect? Right now I have a form to enter incidents, then I have a button the user can clicks on to open a form to enter the suspect(s). Whenever I go back to that a particular incident, I want just that suspect involved in the incident to show, but it will show all the contents in the suspect table. My other issue is how to update the junction table using the incident ID in the incident form and the suspect ID in the Suspect form automatically. Right now I have to go into the database and manually update the junction table with the right IncidentID and Suspect ID. Is there a way to update the junction table automatically using the Incident ID and the Suspect ID from their forms or something? Any ideas will be greatly appreciated

View Replies View Related

How Can Intergrate With Windows Forms

hi,
 How can i intergrate deployed reports with a windows forms?

View Replies View Related

ReportBuilder And Forms Authentication

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 Replies View Related

ReportViewer (ASP.NET) And Forms Authentication

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 Replies View Related

Need Direction For RS Forms Authentication

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 Replies View Related

ReportBuilder, SP2 &&amp; Forms Auth.

Hi, I've just managed to get a custom forms auth. based on the MS sample to work with our Reporting Services installation. This is after we installed SQL Server SP2, and had to re-configure Rep. Services.

Now, things work ok from a browser, but when I try to launch the Intranet version of the Report Builder, I don't get the login pop-up like I used to prior to SP2. The result is that I get a SecurityException, probably because the user I'm running under is ... "".

Any ideas on how to resolve this ?

View Replies View Related

Forms In Reporting Services

Is there a way to insert forms in reporting services. If so, how would this be done>?

View Replies View Related







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