.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

WCF Permissions Question / Problem

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :SharePoint

I am attempting to write my first WCF Application and am experiencing trouble when trying to pull data from a Visual FoxPro Table.  Before you cringe and quit reading, I know the problem is a permissions one.  I can debug this code on my development PC but when I put it live it simply doesn't work.

I had this same problem implementing ASMX services.  Since the provider for the VFP tables is 32 bit and the server is running on a 64 bit server (Windows 2008 R2 - IIS 7.5) I had to force those services to run 32 bit and all worked fine.  However I've tried this same thing with WCF Service and that doesn't seem to work.

Yes - I'm using impersonation.  And, I can run parts of the service that DO NOT attempt to open 32 bit OLEDB Providers.

I am developing in VS 2010.  Anyone have any ideas?

View Complete Post

More Related Resource Links

A layout, mouse selection, ListView problem/question

I'm having a problem with a particular layout scenario, and how it interacts with a left mouse click in certain situations. I have 3 rows in a Grid.  The first is a ListView (Master), with the Row Height set to '*'. It's ItemSource is bound to a collection in a ViewModel, and its SelectedItem is bound to a value in the ViewModel.  When the SelectedItem is null, it should take up its entire container (the other 2 rows are invisible). The second row is the GridSplitter.  It's visibility is bound to a value in the ViewModel.  It's only visible when the SelectedItem in the Master ListView is not null.  It's GridRow height is set to Auto, and it's height is explicitly set to 5 (via a style). The third row is a sub-ListView that shows Detail data for the Master SelectedItem in the top ListView.  It's GridRow Height is set to zero by default, and if an item is selected in the Master ListView, it should become visible and have a set height (400 to start, via a binding on the Height of the row). The desired effect is that when an item is selected in the Master ListView, the Detail ListView becomes visible and the GridSplitter allows you to resize the top and bottom as needed.  If necessary, the ScrollBars become visible in the Master ListView to show any items that are now obscured by the Detail ListView (via the automatic scrolling featur

Problem with Permissions on SQL 2005

I don't even know if my title is a fair explanation of my problem, sorry if it isn't. We are on a network using AD, probably a very typical scheme. My SQL Server is 2005 on a Server 2008 Enterprise machine. My boss had written for him a VBS which will prompt the user for the server name, then Database name and the upload a specific CVS into the proper SQL tables. As a user who is a member of the AD Administrator group, I can run the script no problems. However  the person who needs to run this script on a regular basis gets an error in a "Windows Script Host" dialog box. The error is "Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user 'CC\maurice'." I thought it may be how the SQL drivers are setup on his machine, but when I log in through his computer, I can run the script fine. Is this a setting my SQL server, or is it actually an AD issue I am dealing with?   Thanks for reading.

Problem with permissions

I've been running SSRS with an administrator account during development.  Now I am trying to deploy it for users.  I have a Domain group, SQL Users, that I've added to Report Manager.  I've given the group the following roles (same as the administrator account I use to run reports): Browser, Content Manager, My Reports, Publisher, Report Builder. When a SQL User tries to run a report they get:  An error has occurred during report processing. (rsProcessingAborted) Query execution failed for data set 'Division'. (rsErrorExecutingCommand) For more information... What permissions am I missing that is preventing the user from accessing data from the datacube?

membership provider with custom login form problem / question

Hi all, I am using the .net membership provider, and I can get past the membership.validate user ok and into my secure page.   The problem I have is that when I reach the secured page, I have a login status control which isn't changing from login to logout.   Below is my login code:If Membership.ValidateUser(txtUsername.Text, txtPassword.Text) Then Response.Redirect("/auth/Default.aspx") If chkRememberMe.Checked Then FormsAuthentication.SetAuthCookie(txtUsername.Text, True) Else FormsAuthentication.SetAuthCookie(txtUsername.Text, False) End If Else lblLoginStatus.Text = "Oops! Login not found!" End If    Thanks in advance.

SQL convert problem / question


Hi all

Can somebody explain the following behavior:
The first and second query are quite clear but I
do not understand why the third query does not work ??

Thanks a lot for your comments !

Best regards
Frank Uray

-- Working
FROM [dbo].[GeoDataTest]

Is This only a Permissions Problem?


Hi all,

A complete newbie to SSIS. I'm trying to load two columns of data from an Open VMS file into a SQL Server 2005 table. I'm using an OLE DB source (I can "Preview" and see the data), a data conversion where I convert the two source columns to an output datatype of: Col1 - Unicode String [DT_WSTR] Len 20 and Col2 - Unicode String [DT_WSTR] Len 16. I have a SQL Server destination where the two columns are mapped to table columns of nvarchar(20) and nvarchar(16) respectively.

I am able to execute the package and move the data into a flat file destination on my local computer, but I cannot put the data into the SQL Server table on our dev server. I have full permissions on the destination database and I have created the destination table; however, I get the error below. My question is, is the error related to permissions on the dev server?

Any thoughts will be much appreciated. Here is the error:

[SQL Server Destination [400]] Error: An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80040E14  Description: "Could not bulk load because SSIS file mapping object 'Global\DTS

Drill down question/problem


Bear with me, im no SQL expert by any stretch, so I'll try to explain this the best I can.

We're using system center which has built-in reporting. My sql server is running SQL 2008R2 with reporting services installed/enabled.  My problem is that system center creates drilldown reports but when I click on the links to go through the levels it doesn't send the parameters I'm requesting.  Probably doesn't make sense but my scenario is below.

I request a software summary of all my pc's.  I'm presented in ReportViewer with a list of vendors, I click that vendor and it takes me to the list of software associated with that vendor, along with the number of installs associated with those particular programs.  Now what "should" happen (because it worked with sql 2008) was once I clicked on let's say Office 2010, I would then take me to a list of only pc's that have that software installed.  This is where it breaks.  All it does is ask me for a computerId.  If I leave it blank, the message I get is "Please enter a value for the parameter 'ComputerTargetId'.  The parameter cannot be blank."

so to recap

Microsoft->List of programs published by MS->Office 2010 and install count->(broken) list of pc's with 2010 installed. 


 Sorry if this is con

DbObjectName Problem/Question


I have searched for 'DbObjectName' in posts, but none have provided a satisfactory answer.

When I created a typed dataset using the designer wizard, my connection string was pointing at my Development database and the designer created the code referencing 'DbObjectName' as follows:
<DbSource ConnectionRef="CS_CAPAC (Web.config)" DbObjectName="PrimComm_CAPAC_Dev.dbo.CAPAC_Service_Request" DbObjectType="Table"  .....>

i.e. it prefixed/qualified DbObjectname with my development database name... PrimComm_CAPAC_Dev.dbo.CAPAC_Service_Request

This is not the name of my Production database.
So can I edit the xsd file and remove the database qualifier i.e set it to DbObjectname = "dbo.CAPAC_Service_Request". I have seen this as a solution, but am not sure of the effect.

What is the purpose of DbObjectname and shouldn't the designer just reference the name of the table, as opposed to the database its contained in. Or does this cater for differences in the schema between development and production. I would have thought the connection string would provide it with enough information as to where the table exists.





Having Trouble deploying first report, I think it is permissions problem


I think I got SSR installed ok.  From the Configuration Manager when I click on Web Service URL and Report Manager URL, IE opens and returns the correct pages.  I see report manager screen etc.

In BIDS I created a solution and a report that previews fine.  The properties page of the solution has a targetServerURL the same as what is in the Configuration Manager, web service URL tab; " http://IMB-T22:8080/ReportServer ".  IBM-T22 is the name of my computer.  8080 is the port it is using.  Port 80 is used by IIS and not running.

The TargetFolder was created ok...AdventureWorks, but the report does not deploy correctly.  If I deploy it times out.  If I debug I get I get the name of my report can't be found or a permissions error. 

In the solution property page I have tried various differnt TargetServerURLs..Localhost/ReportServer...ibm-t22/ReportServer...ibm-t22:8080/ReportServer...Nothing seems to work.  Please help

I belive I am having permissions problem.  I can connect to database from BIDS and preview data in my report.

When I installed SQL Server 2008 SR2, I used an account name "NT Authority/Sytem"   I used this because it was in drop down and was having problems with "Owner"

In Reporting Services Configuration Manager I have the foll

Problem with permissions, not sure what to do


HI I have some codes that worked on my local but when I published to the server I am getting this error message, any help at all would be great!

Server Error in '/CaretechUserMngmnt' Application.

The DELETE permission was denied on the object 'Client-Users', database 'SECURITYDB', schema 'dbo'.

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: The DELETE permission was denied on the object 'Client-Users', database 'SECURITYDB', schema 'dbo'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


Problem to group radio button across gridview rows

In general no one can easily group or make a single selection from radio button list inside gridview rows. There are a lot of way to make a single or unique selection from list. Here i want to share how i can address this problem in the most easiest way. Googling the problem most of the cases i saw the grouping in horizontal way. Thats why i tried to group the radio buttons in vertical manner. Let i have a requirement like below:

Regrading Sharpoint 2010 problem and solutions

We can write your question and problem on this blogger.you get ans.use.

This sharpoint 2010 problem solving threads

Hi friend,

you can use this thread to solving problem and solutions.

Virtual Path Problem


 I get the following error on last line below (working on remote host): 'E:\web\sfcascom\ls_admin/uploads/images/001.JPG' is not a valid virtual path,

Note that the slashes go in different directions

I've tried a number of things but nothing seems to work. Thanks-


Imports System.Drawing
Imports System.Drawing.Drawing2D
Imports System.Drawing.Imaging
Imports System.Web.UI.WebControls

Imports System.Drawing.Imaging.ImageCodecInfo
Partial Class Protected_imageupload
    Inherits System.Web.UI.Page
    Private Sub btnUpload_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnUpload.Click
        ' Initialize variables
        Dim sSavePath As String
        Dim sThumbExtension As String
        Dim intThumbWidth As Integer
        Dim intThumbHeight As Integer
        Dim sFilename As String = ""
        ' Set constant values
        'sSavePath = "images/"
        sSavePath = Server.MapPath("~/") + "ls_admin/uploads/images/"

        sThumbExtension = "_thumb"
        intThumbWidth = 160
        intThumbHeight = 120

        ' If file field isn?t empty
        If FilUpload.PostedFile IsNot Nothing Then
            ' Check file size (mustn?t be 0)
            Dim myFile As Http

Strange Photo upload problem


I'm working project it's live on shared hosting

we'er uploading photos to a file on the server everything works fine the photo is resized renamed and sent to the folder

the upload page returns the thumbnail and the full size photo it's there all the photos have to be approved by an admin

twice now after they have been approved they disapear I checked the folder they are not there could there be anywhere

on the server they could get hung up before they go into the folder I have it setup so when you delete the data base entry it deletes the photo from the folder othe than that you need to open the folder and delete the photo this has hapened twice now I tried to recreate it with no luck

thaks for your help in advance

ASP.Net Caching problem ??


I'm having a problem with an asp.net 3.0 application using a gridview to display data.  The problem seems to be that despite a brand new .selectCommand being sent to the sqlDataSource, the gridview starts displaying data from *someone else's* query.  For example, user A is logged in and will be working fine until a few page submissions later when the gridview data starts suddenly showing information that belongs to another user. 

This is my first asp.net application, though I've been working with classic asp and ADO for years so I'm used to sending a SQL string and getting back the results from that string.  Apparently there is a complex caching system which is interferring which I do not at all understand so at this point I just want to stop the server from caching any data whatsoever.  Is this possible?

Any and all help will be much appreciated!!

Could some one tell me whats the Problem with this String Manipulation ??? C#.net



I store some values from code behind to a label which is Hidden !

<asp:Label ID="lbl_Hidden" runat="server" Visible = "false"></asp:Label>

and at the page load event i retrieve the value of the label & assign it to a string !

stringvalue = lbl_Hidden.Text;

Now i dont know why this manipulation does'nt work !

I've a character 'A' in the string and i'm unable to replace it with a space !

stringvalue.Replace(A, " ");

Wot do u think abt it ????

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend