Sharepoint Custom Aspx Page With Database Connection?
May 7, 2010
i have created a custom aspx page whithin my sharepoint site with a sql server connection to a database on that server to select data when i view the page it works but when another user tries to view it it gives the following error :Server Error in '/' Application. Login failed for user 'GRINCORGuguK'.Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'GRINCORGuguK'.Source Error: The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:Add a "Debug=true" directive at the top of the file that generated the error. Example:
<%@ Page Language="C#" Debug="true" %>
or:2) Add the following section to the configuration file of your application:Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario. tack Trace:
[SqlException (0x80131904): Login failed for user 'GRINCORGuguK'.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +248
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +245
[code]...
View 4 Replies
Similar Messages:
Jul 28, 2010
I have to create the custom pages/ templates. User has to specify the fields and controls from UI and then we have to display the specified controls on an aspx page. We have mutiple users that are adding their custom fields and controls. How we can manage this data in database? Do we have to create different database for each user or we have to create different tables for each user in a single database? Also, I can go with any other option (XML, Sharepoint etc) so that all the data will be managed in a simpler form.
View 5 Replies
Jan 12, 2011
I have deployed a custom SharePoint Web service on Farm A. I am trying to access this Web service from a SharePoint timer job on Farm B. On Farm B, I am creating Class Library project, packaging it (wsp) and then deploying to GAC. The problem is I'm unable to access the Web Service using the following code. TodaysNewSVC is a service reference
TodaysNewSVC.GetTodaysnewsfromInsite objGetNews = new TodaysNewSVC.GetTodaysnewsfromInsite();
objGetNews.PreAuthenticate = true;
objGetNews.Credentials = CredentialCache.DefaultCredentials;
objGetNews.Url = "http://insite-dev.portal/_vti_bin/todaysnews.asmx";
DataTable dt2 = objGetNews.getNewsFromInsite(true, true);
//getNewsFromInsite is a WebMethod which returns the DataTable.
Note: Both farms use the same active directory authentication. I have also done the debugging for Timer Job and feature activation and they are working fine. The problem occurs during the call i.e. getNewsFromInsite
The asmx and wsdl files are accessible from Internet Explorer and also from Windows Console application. Here is the code which I use from console application:
GetTodaysnewsfromInsiteSoapClient objWSClient = new GetTodaysnewsfromInsiteSoapClient();
objWSClient.ClientCredentials.Windows.ClientCredential = System.Net.CredentialCache.DefaultNetworkCredentials;[code]...
Here is the error message:The request failed with the error message:
--
<html><head><title>Object moved</title></head><body>
<h2>Object moved to <a href="%2fPages%2fproblem-with-page.aspx%3fc%3d500">here</a>.</h2>
</body></html>
View 1 Replies
Apr 8, 2010
I have the .aspx page wich is already developed in VS 2008 with its code behind. page name is say login.aspx.
Also have another page in same scenario after login this second page will appear. ok ?
I want to embed/ add this already developed aspx page to above team site.
View 3 Replies
Aug 2, 2010
I have a default.aspx in a folder _layouts/sandbox on the sharepoint server.
It has the following code:
using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
[Code]....
View 1 Replies
Mar 7, 2010
I am using SharePoint Server 2007 + C# + .Net 3.5 + VSTS 2008 + ASP.Net. And I am using collaboration portal template.
I am developing a custom aspx page and put it in _layout folder of a site and I want to apply default.master of the SharePoint site to this aspx page. Any samples about how to achieve this goal?
View 3 Replies
Mar 17, 2011
I am using spgridview to show the files and folders of document library in an aspx page. Now i want to display the files and folders along with icons in spgridview.
View 1 Replies
Feb 21, 2011
I am working in a school and we recently installed a new server running WinServer 2008R2. I want to be able to point people to a URL on our intranet and have them fill out a simple registration form and have this data written to a database. It would also be nice to have some data auto-populate (such as their name).
Is it overkill to set up a sharepoint server and try to do this with Access Webforms? Could I use something like dotnetnuke and find a module that works? Or how about options for writing custom forms?
View 3 Replies
Feb 21, 2010
need to setup a OLEB DB connection from aspx page and not from aspx.vb file.
View 4 Replies
Dec 19, 2010
I want to create a custom web part in SharePoint 2007 that allows me to take items from an existing custom list (i.e. Title, Hyperlink, Description and photo) and then render it in a format of my choice. How can I do this using C# asp.net and a web part?
View 1 Replies
Feb 21, 2010
I want to setup a DB connection from aspx page and not from aspx.vb.
View 1 Replies
Feb 16, 2011
ASP.NET 4 - IIS 7
I would like to limit the number of connections to one of my website.What I want to do specifically is show the visitors a simple custom page warning them that the site is too busy and they should come back later.I know if I limit the nbr of connections in IIS it'll work but It doesn't show an elegant page.
View 1 Replies
Mar 29, 2010
I am using a custom error page in IIS 6:<customErrors redirectMode="ResponseRedirect" mode="On" defaultRedirect="Error2.aspx"/>I want to disable authentication for the custom error page because the error being raised is related to an authentication module and I don't want to get into an infinite loop and I want to display a clean error page to the user. I have been trying the following configuration to do that.
<location path="Error2.aspx">
<system.web>
<authentication mode="None"/>
[code]...
View 3 Replies
Mar 10, 2010
How to check/confirm that whether SQL connection pooling is enabled for a sharepoint 2007 web-application ?
View 1 Replies
Oct 6, 2010
I have a very simple Web UserControl derived from System.Web.UI.UserControl. At Design Time the user control looks perfect in the VS2008 Pane with all CSS styles. When I drag n drop this control on an aspx page, the CSS style gets applied but some texts get hidden and the CSS looks distorted.
I have checked the path of the CSS, UserControl and the ASPx page. All are in the same level under root. The aspx page just contains the UserControl in a FORM tag.
View 1 Replies
Feb 8, 2010
I'm writing ASP.NET custom control, and I want it to have a few properties which should be visible only from code behind during run-time - I mean, these properties should not be visible both in a designer and in a aspx code of page containing this control. I've tried to use following attributes:
[DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)]
[Browsable(false)]
public List<Item> SomeData
{
...
}
but unfortunately this property is still visible in an Intellisense combobox when editing aspx page. Is it possible to hide this property everywhere besides server-side code ?
View 2 Replies
Oct 12, 2010
When I load my page I populate my repeater with the following code.
Dim conn As Data.SqlClient.SqlConnection
Dim Comm As Data.SqlClient.SqlCommand
Dim reader As Data.SqlClient.SqlDataReader
[code]...
View 1 Replies
Mar 16, 2010
it's possible to put the database connection settings into a base page class so that I can auto-init them on a page. like this document: [URL] but with instructions in VB.net
View 1 Replies
Mar 10, 2011
provide me any pointers for deploying aspx pages in sharepoint layouts folder.
and also how to add any OOTB webpart in that deployed aspx pages. Can we open those pages in sharepoint designer to add any OOTB webpart.
View 2 Replies
Aug 14, 2010
We have a requirement from a client for porting an ASPX website to sharepoint :
Though the site is being served in ASPX there are no form submissions so effectively, they are just static pages without any server side processing required.
However, there is a common header and footer being used.
Here are some of the features being used in the existing site :
sifr for font substitution (using non standard web fonts) flash animations javascript and some jquery common header and footer for all pages
My question is how feasible is it to port this website to sharepoint ? Can i use sifr (or flash for that instance) in sharepoint ? or do i have to port it to silverlight ?
What is the general procedure for converting web applications to sharepoint ? Also i came across this [URL] for migration of website to sharepoint.
Can javascript be used in sharepoint ? How can i have common header and footer in sharepoint documents ?
View 2 Replies
Apr 27, 2010
I have use my custom Contol which include textbox and customValidator in my aspx page.
iv noice it never get into the customValidator function.
View 2 Replies
Jun 29, 2010
I am new to sharepoint I am familiar with creating webparts and using them in sharepoint, but how to create an entire site as template and make it to use in another sites
View 2 Replies
Jul 23, 2010
I am using VS2008 and oracle 10g ODP.Net. The oracle database that I used in the connection is working and tested it using sql plus.The connection string when used in a GriDView works perfectly. Now when I created a new listview control with the same connection it gives an error.Database schema could not be retrieved for this connection. Please make sure connection settings are correct and the database is online
Object reference not set to an instance of an object at VSDataObjectSupport (478,6)
View 2 Replies
Apr 13, 2010
As noted by some developers, workflow versioning is somekind of headache in SharePoint.
I`m wondering is there a way I can version my aspx forms? For sure, i can version code behind assemblies, but if markup changes for any of my files in LAYOUTS folder? Is there versioning available for files or do i have to choose new filename for my form?
I should have been more specific. Yes, i have files under version control (i can restore previous versions etc), but i`m not talking about this kind of version control. But by deploying new Workflow Version, i must not delete old one, because it is still running on many items in SharePoint, but rather , as noted in previous links, deploy new one so i don't break execution of workflows.
But workflows will still break if i don't preserve old aspx forms used by users to interact with workflows.
So i must ensure that Assemblies with old version numbers used by old workflow exists (this one is ok, i just changed assembly version number and deployed to GAC)I must ensure that old workflow still uses old aspx form used users to interact with workflow, but new workflow version should use new aspx form with more options (how to do this?).
View 1 Replies
Jan 10, 2011
Ive integrated a custom asp.net web application into a Sharepoint site by creating a virual directory, that contains my web app files, that points to a directory in the Sharepoint inetpub folder.
On my local dev server I can access all my web app pages just fine by typing in /virtualdirectoryname/page.aspx
My Problem is that: When I deploy to my Live Test server that is internet facing, none of the pages that make a MS-Access database call will work.
The Error I receive is '[SecurityException: Request for the permission of type 'System.Data.Odbc.OdbcPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.]'
I have researched the issue online and tried numerous solutions which include giving all the assemblies in my application a strong name, and modifying the security policy to trust this strong name.
My Custom Web App consists of 2 projects
1. A Class Library Project (Data Layer)
2. A Web Application Project (Web Layer)
My .mdb database file is stored at root level within the Virtual Directory.
I have 1 class in the Data Layer (ClassConnect.cs) that when instantiated, creates the ODBC connection for all other pages to use (OdbcConnection dbConn = new OdbcConnection();)
I have a Connection String stored in the web.config file that is as such. When I deploy to the Live Test Server I change the path in this connection string, because I haven't figured out yet how to get a relative path that works.
I also place the dll's for my 2 projects in the Sharepoint bin folder.
Could anyone suggest what might be the dfference between my Local Dev Server and the Live Test Server and why I might be getting these errors.
View 1 Replies