Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







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


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
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
Forms In Reporting Services
is there a way to put forms in reporting services? If so, how would this be done

View Replies !   View Related
Forms Authentication, CheckAccess
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 Replies !   View Related
Using Forms Authentication In Scripts
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 Replies !   View Related
Using SetPolicies In Forms Authenication
I have successfully completed form authenication with and without LDAP provider.
 

How do i call the function SetPolicies, which is inside ReportService2005.vb?

When someone logs into the system, I want to set there role to browser. but I can't get it to work. Any ideas?
 
i tried to do this, but it didn't work...
 

            Dim test As Microsoft.Samples.ReportingServices.CustomSecurity.ReportingService2005
            Dim Item As String = "/"
            Dim Policies(0) As Microsoft.Samples.ReportingServices.CustomSecurity.Policy

            Policies(0) = New Microsoft.Samples.ReportingServices.CustomSecurity.Policy
            Policies(0).GroupUserName = TxtUser.ToString
            'Policies(0).Roles = New Microsoft.Samples.ReportingServices.CustomSecurity.Role(0) {}
            Policies(0).Roles(0) = New Microsoft.Samples.ReportingServices.CustomSecurity.Role
            Policies(0).Roles(0).Name = "Browser"
            Policies(0).Roles(0).Description = "May view folders, reports and subscribe to reports."
            test.SetPolicies(Item, Policies)

 
 

View Replies !   View Related
Connet To SQL Using VB6 Forms Via Internet
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 Replies !   View Related
Replacement For Access Forms
 

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 Replies !   View Related
Replacement For Access Forms
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 Replies !   View Related
How Do I Change My Forms Dataset?
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 Replies !   View Related
Nested Database Transactions In Forms
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 Replies !   View Related
SQL Datasource Control In Windows Forms
Gang,
 
In the tool box under Data I have a SQL datasource control if I am writing a web app. If I am doing a windows app, the control is not there. Other documentation I've read on MS sites suggests it should be. What do I need to do?
 Thanks,Derek

View Replies !   View Related
Firing DTS Through Window Based Forms In VB.net
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 Replies !   View Related
Access2K Front End To SQL SVR 2K -- Users Cannot See Forms???
Hello:We've just switched to using Access 2K as the front end to our SQL Server 2Kdb. Great. Love it.However, one small problem. The users can see the SQL Server tables andveiws but they cannot see the Access Forms or Reports.Since Forms and Reports are not listed in the SQL Server 2K Objects list,you can't grant permissions to then on the server side. I therefore assumethat somehow I must do this on the Access side.Do you agree??All users are set up with the same permissions and roles. I (the db owner)can see the forms and reports I create, but the users cannot.Any ideas??Thanks,Richard

View Replies !   View Related
Slow Performance On ADP Forms Using Filter
Hi,I have an ADP file with a main form featuring several subforms.. to getto the record I want I have just used a simple filter on the main recordsource, which is updated by altering a text box. The problem is thatthis performs very slowly.Before I made the ADP, I had an MDB with linked tables, this did nothave the same slowness problem.Any ideas??Many thanks,Chris

View Replies !   View Related
Help - Syncronizing Forms In Access 2000
regular access db - usually use sub-forms or tabs - this time I want seperate forms - have linked fields - but can't final code line in "open form" button command. Any suggestions welcome. Denny :(

View Replies !   View Related
Sql Reporting Services Forms Authentication.
I have been refering to site http://www.devx.com/dotnet/Article/26759
While implementing Forms authentication in Sql Reporting.
After changing rssrvpolicy.config located at C:Program FilesMicrosoft SQL ServerMSSQLReporting ServicesReportServer location, it gives a security error on accessing http://localhost/ReportServer

Help Required.

View Replies !   View Related
Connecting SQL Server With Oracle Forms 9i/10g
Could anyone please guide me in detail to connect Oracle Forms 9i/10g with MS SQL Server database?
To connect with Oracle Database, we need to copy and paste the tnsnames.ora file from the Oracle Database folder to the Oracle Forms folder.
But how do i connect with other databases like SQL Server, MS Access, and so on?
Thanks in advance.

View Replies !   View Related
Sql Server/access Front End/forms
I am going crazy and need some help. I had a database written in access that I am now re-writing the queries to run on the sql server end. I found out how to pass variables to a sql query using ADO code, BUT I can't figure out how to address a control on a access form.

=forms!users!logged_in_user

This condition works GREAT from access, but how can I get a sql server procedure to address the same control? Please help!

View Replies !   View Related
Connecting SQL Server With Oracle Forms 9i/10g
Could anyone please guide me in detail to connect Oracle Forms 9i/10g with MS SQL Server database?

To connect with Oracle Database, we need to copy and paste the tnsnames.ora file from the Oracle Database folder to the Oracle Forms folder.

But how do i connect with other databases like SQL Server, MS Access, and so on?

Thanks in advance.

View Replies !   View Related
Web Forms Became Dead Slow! URGENT!!
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 Replies !   View Related
Passing Variables From Access Forms To Sp's
Hi everyone,

passing variables (values) from a form (MS Access Project) to a stored procedures in order to select records shouldn't be all that difficult. However after searching for hours and hours in various forums and discussions i'm still nowhere. I really hope someone can give me the missing hint.

OK All I whant to do is select data from the sql server via an access interface. the value entered into the access form by the user (for example the client name) should then be transferred to the stored procedure which will then return all the records of the chosen client.

The simple task of transferring this form value to the stored procedure is driving me crazy. Does anyone have an idea.

Thanx in advance

Guido

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved