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

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

DBType change from compile time to run time. I am not using a view, it is against the oracle db I do

Posted By:      Posted Date: September 28, 2010    Points: 0   Category :Sql Server

The OLE DB provider "OraOLEDB.Oracle" for linked server "SOMESERVER" supplied inconsistent metadata for a column. The column "ACTIONITEMID" (compile-time ordinal 1) of object ""SOMESERVER_Action"."AI_ACTIONITEM"" was reported to have a "DBTYPE" of 130 at compile time and 131 at run time.

View Complete Post

More Related Resource Links

Change value of particular cell in Grid view at run time.



I need to know that how i can edit the particular cell value in grid view at run time just by clicking it(value) then it shows text box and after enter any value, it then save in database.

Waiting for response.

Thanks in advance.

SqlDataSource how to change the stored procedures at run time



Is it possible to change the select, insert and update stored procedure of an SqlDataSource at run time. I don't mean to change the definition of the stored procedure, but I mean to change the assignment, i.e. To change the select stored procedure from "selectSP1" to "selectSP2" at run time. Is it possible?



Crystal Report Asking for Database Authentication each time when I view Page.


Whenever I open my Crystal Report page, I am taken to the Database Authentication page where I am asked for

User name
Data Name

each time.

Is there a way to avoid this and I save these authentication in my page once.

I am using VS2005, C#.

Any Help will be appriciated.


how to change dynamically [Bbrowsable] attribute for a property at design time c#

hi,   how to change dynamically  [Browsable] attribute for a property  at design time c#

Remove time from Month Calendar view

We have a calendar part on a page that has very narrow boxes for each day. As such we want to remove the time from appearing before the title of the event. I have managed to do this through css where there is only one event. However, have not been able to remove it where there are mutiple events. Any ideas on how this can be removed in both scenarios? Cheers, Theo

Should time date stamp on .Asmx file change when project is rebuilt?

I have a web service project. The web service is named Recalc.asmx and it has a code behind file namedRecalc.asmx.vb Now if I make a change to my web service .vb code and then recompile the project, should my Recalc.asmx filebe updated as well? In windows explorer I see that the time date stamp of my Racalc.asmx.vb file changes to the date of the last change.But the time date stamp of the Recalc.asmx file does not change? Why is that? My original thinking was that I would simply need to copy the Recalc.asmx file to the test server. But the date stillshows it's original creation date of 7/1/2010 and not the date of the last rebuild as I was hoping it would do?

OnWorkflowItemChanged fired more than one time for each change

I have a state machine workflow that runs without problem in SharePoint 2007. I wanted to have this in SharePoint 2010. I have created the same workflow using Visual Studio 2010, State Machine Workflow for SharePoint 2010 template. It runs ok, except that the OnWorkflowItemChanged is firing more than one time for each change. It is the same funtionality... same definition.  The only difference is the workflow is for SharePoint 2010. I created another state machine workflow, a simple one with two or more states that contain an EventDriven( with OnWorkflowItemChanged) and setState activities. No other activities are defined.  No tasks are created. I have associated this workflow to a Custom List that I created for this test. The workflow starts when an item is created (or manually), then I modify the item from the list and the OnWorkflowItemChanged is firing more than one time. The same situation ... the same problem. I realized that the event is triggered so many times the OnWorkflowItemChanged activity is defined in the workflow. i.e. If the workflow has defined three OnWorkflowItemChanged, the OnWorkflowItemChanged will be fired three times when an item is modified. Anyone have an idea how can I fix this problem? I would appreciate any suggestions to resolve this.  

Cannot View Dashboard with Time Intelligence Post Formula



I am using PerformancePoint DashBoard Designer to create a dashboard that allows user to select a date from the calendar that must be displayed by the Time Intelligence Post Formula filter, but when i try to Preview the dashboard, i get a blank page, and the following title : PerformancePoint[2] with the contexte menu.

Can you help me to resolve this problem, and viewing the dashboard with the calendar filter correctly?

Thanks all.


Slow BinaryReader Position Change Time


Hello, I have a question about basically a laggy position change time with a large file (actually, in this case I'm using a 20GB or so disk drive).  Basically what I'm doing is writing my own class that uses the CreateFile function to read raw data from a local disk drive, and then have an extract file class that allows me to seek to blocks (the file system is FAT) that the file occupies, then read the data, piece it together, etc.  I noticed though, that when extracting an 800KB file, it took about 10 seconds to do the process, and the main cause was that changing my reader's position took anywhere from 250 milliseconds to one complete second.

The short version: When extracting a file using my own classes, it took way longer than it should have, and the cause is changing the IO's position.


The code is exactly as you'd probably imagine:

for (int i = 0; i < f.BlocksOccupied.Length - 1; i++)
          br.BaseStream.Position = m.GetBlockOffset(f.BlocksOccupied[i], f.PartInfo);
So what I am asking is if there is any way to speed up the process of moving my posit

SSRS 2008 Time min change to hour


Hi there

I've got a problem in my report.


I have 2 colums "Expense" "Entity"


Expense has an issue 300 and entity min.

what i'd like is, that it change to 5 hours.

but it should issue min if expense is below an hour.


Any ideas?

One who can read, have a clear advantage!

SharePoint Designer seems to time out generating some data view web parts, reasons?


I am trying to add a few DVWPs to my site's default page using SharePoint Designer. I find that I can add some of these with no issues, I pick the data source and 'Show Data' immediately shows the fields to select from. For another list, selecting show data leads to a long period where SPD appears not to be responding before eventually returning the message 'The server could not complete your request.....'. Clicking 'Details' shows that there is no message returned.

The list I am attempting to query now contains only 2 rows of test data. If I drop a list view web part of the same list on the same page the data appears instantaneously.

Any suggestions on why some lists could prove problematic in a DVWP in Designer?

EDIT: If I select to convert that List View Web Part to a Data View I get the same lack of response from Designer

Calendar View: Unable filter Recurring Event by Start/End Time and Group by Recurring Event View

Hi All,
I have just found several issues with Calendar View from WSS 3.0:

Unable to filter by [Start Time] and [End Time]
I am not sure why these 2 columns doesn't appear in the Filtering column in the View Settings. The workaround found in the internet is to create calculated column for Start Time and and End Time. However, it doesn't work for Recurring Event, the calculated column will show only first recurring event Start Time.

Unable to use "Group By"
When I create new view in Calendar using format: "Standard View, with Expanding Recurring Events", there is no option to specify "Group By". Anyone knows how to show all recurring event in List view and grouped by Start Time (or any other column).

Thank you and apprecate for any idea.

SSIS - OLE DB from VIEW takes long time



I have a question regarding SSIS 2008 and how it handles views. I hope the answer for this question will be a quick "Get a hotfix" heh.


I am experiencing a very odd behavior with setting up a View as a data-source in OLE DB. I have set up a a very simple package (for experimenting) with a Data Flow Task that has only two components, Data-Source and Data-Destination. I have set the data-source to a view and the destination to a table in the same database.

Note: I am developing the package on the server itself.


  • While trying to preview data-source I get an error, "Query Timeout expired (Microsoft SQL Server Native Client 10.0)
  • When executing the package Validation, Pre-Execute phases are complete but no rows are passing through the buffer. I have waited over 12 hours before stop the job. Checking the monitoring verified that IO was on 1. And that no object was locked , which may have caused the package to run so long or not to retrieve data.
  • When connecting to SSMS and doing export of data from the view - it also retrieves no data and the process seems to be stuck.


Additional data:

  • T

Scripting a change to Backup time



I have a backup plan defined in SQL Server that runs every night at 8PM. However sometimes I need to change this time to 5PM to allow a reboot of the server due to Windows updates. Some other tasks get rescheduled as well. I want to script this time change so that I do not need to manually change the backup time.

Is there a command line tool that will let me change the configuration of SQL Server? and specifically let me reschedule the time of the backup?

The scripts are written in Ruby not C#, this is fine as long as there is a command line tool.



.we each have more potential than we might ever presume to guess. (Blog: http://dsmyth.blogspot.com/)

update the Oracle time stamp and userid when using Gridview



  I am using Gridview against Oracle 9i and I am using the GridView update function to update table fields when someone edits a row.  I have captured the userid and the date/time when someone peforms this function but I have yet to figure out how to get it into the GridView row so that when the update button is pushed, the current date and time and the user's userid it displayed in the row of the table.  I've tried many different things but am at a loss to nail down the code for this.  Below is a piece of the code I am working with.




using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Sec

SSAS Time Dimension (academic years, quarters) change over time


Apologies if I don't state teh question properly or am overlooking obvious answers - just started working with SSAS and barely beginner level.

I'm working on a cube to show student enrollments in different subject areas over time - for this purpose I'm only concerned about academic years and semesters.  In the underlying dimension table I have data like

1 2006          SUMMER  SUMMER 2006
2 2006          FALL  FALL 2006
3 2006          SPRING  SPRING 2007 (note that spring 2007 is part of the 2006 academic year)
4 2007          SUMMER  SUMMER 2007
5 2007          FALL  FALL 2007
6 2007          SPRING  SPRING 2008
and so on

I've set up a simple hierarchy with only two levels - ACAD YEAR->DESCR

For the cube I have one measure: 'Enrollments' which shows the sum of students who have enrolled

What I'd like to be able to do is show the f

error redoing dashboards: dwd:design-time-name tag or AttributeID change?


hi all,
I have a user who designed some dashboards in Sharepoint 2010/PPS who apparently cannot use the previously created dashboards without dropping and re-adding a recently modified dimension.   This dimension apparently has the same Name and ID properties as the older version however I now see   dwd:design-time-name  tags wrapping around all objects in the newly created AS Database.  Not sure what is going on and how to mitigate these changes.   Furthermore, for *some* attributes of those dimensions, I see that the AttributeID property has changed from one version to another.

any pointers are much appreciated,



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