.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

A field or property with the name 'User_x0020_Name' was not found on the selected data source.

Posted By:      Posted Date: October 22, 2010    Points: 0   Category :ASP.Net

I am trying to bind the XML data to a datagrid from an XML file.  I don't know why I am getting the message: "A field or property with the name 'User_x0020_Name' was not found on the selected data source."

The "User_x0020_Name" field does exist in the XML file.  This is a portion of the XML file.

<?xml version="1.0" encoding="utf-8" ?> 
<DataSet xmlns="http://www.----------.com">
 <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
 <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
 <xs:choice minOccurs="0" maxOccurs="unbounded">
 <xs:element name="Table">
 <xs:element name="User_x0020_Name" msdata:ReadOnly="true" minOccurs="0">
 <xs:restriction base="xs:string">

View Complete Post

More Related Resource Links

A field or property with the name 'FieldName' was not found on the selected data source


I'm attempting to load a GridView dynamically on a button is pressed.

The gridview has AutoGenerateColumns="True" (set in skin definition) and has a declarative column definitions as follows:

<asp:GridView runat="server"
        SkinID="GridViewDetail" ID="gvReport"
            <asp:TemplateField HeaderText="Date">
                        <asp:LinkButton  OnClick="

How do you create a custom BDC data field that allows for multiple selected values?

I need help creating a custom data field using the BDC column as a base.  We need to allow for multiple selected values instead of just a single one.  I can't find anything on the net which shows how to do this.

SSRS 2008 R2 Dataset Field Value Property Data Type not numeric

We're building SSRS 2008 R2 reports using SSAS as data sources.  There are several occaissions where the data types of certain dataset field values that represent cube measures are not numeric.  As such, when these fields are used in an aggregate function they throw an error.  Is there a way to remedy this in the dataset? Thanks for your help.

"Logon failed. Details: IM002:[Microsoft][ODBC Driver Manager] Data source name not found and no def

When i attempt to fill my Crystal Report -named limitler.rpt and it is under the sub-folder Oraburslar of my project -, i get the following error; "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. Error in File C:\DOCUME~1\KEMAL~1.ESM\LOCALS~1\Temp\limitler {148B6FE6-D5BE-4BC3-A13A-47CCCB79D78B}.rpt: Unable to connect: incorrect log on parameters." How can i handle this pro? Thanks in advance... Here is how i connect to database to fill the Crystal Report:string database = ConfigurationManager.AppSettings["Database"].ToString(); string password = ConfigurationManager.AppSettings["Password"].ToString();string username = ConfigurationManager.AppSettings["Username"].ToString(); string server = ConfigurationManager.AppSettings["Server"].ToString();ReportDocument report = new ReportDocument();report.Load(Server.MapPath("~/Oraburslar/limitler.rpt")); report.SetDatabaseLogon(username, password); CrystalReportViewer1.ReportSource = report; CrystalReportViewer1.BackColor = System.Drawing.Color.White;

SSRS 2008 - Data Source cannot be found in Preview

Hello; Something weird is happening to me - Never happened before on 100's of reports using Shared Data Sources. I have a Shared data source defined and when I try to preview a new report, I get a message saying that "The data source 'ProjectList' cannot be found" When I created the dataset, I pointed it to the shared data source. I can preview the data when I run my query from query designer, so it's obviously seeing my shared data source. If I use an embedded data source, the report renders just fine. I'm using SSRS 2008R2 BIDS to develop the report - the data source is hosted from a SQL Server 2008R1 database. Anyone ever seens this? How'd you get out of it? ThanksThanks Ron...

e.Result when data source was shaped? - linqdatasource selected event - LinqDataSourceStatusEventArg



How do I handle using e.Result when my datasource was shaped (select new{})? example aspx markup below:

<asp:LinqDataSource ID="ldsMain" runat="server" 
                    Disposition.Substring(0, 2) as Status)"
        onselecting="ldsMain_Selecting" onselected="ldsMain_Selected">    

1) since I shaped, it's an anonymous type right? so what do I cast e.Result to in order to be able to get at the data? 

2) I am thinking of using the selected event to handle some conditional page setup based on whether or not any results were actually found from the main query (the one that is used to bind data to a gridView via this linqdatasource control)... so I need to check for count > 0 and if it is, I need to fill a few dropdown controls based on a few new queries that will essentially be some select dis

Data source name not found and no default driver specified on win xp


Hi All,

I have got a new laptop with I5, windows 7 64-bit and I am trying to run application developed in vb6 which uses DSN connection to connect to the database which is in SQL 2000. Actually I was facing issue "SQL server does not exists" while connecting to the db and I have solved this by running c:\windows\syswow64\odbcad32.exe and configuring dsn through it.

Now I have installed virtual machine windows xp professional sp3 which is 32-bit and when I run my application from VM then I am getting following error -

"Datasource name not found and no default driver specified"

when I go to administrative tools > Data sources(ODBC) then I can see only one driver i.e. SQL server. I configured it but not working..

Can somebody help me on this? I am stuck..

Prabi I can be still better.

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified


trying to install sql server2005 on a windows 2003 server box.

getting msg below at the sql server .  i looked at other posts on trying to uninstall  SQL Native Access Client and norton antivirus.  i could never find the snac on the add - remove programs and this server does not have a virus protection program yet.

here's the history of the installs on the server:

wanted to test a 2005 upgrade so:

  1) installed sql server 2000 then sp4 then restored some databases to it - all OK

  2) tried to upgrade to sql 2005 but ran into problems and left it at that.

had a disk drive crash on the d drive so lost the installs but not the operating system

when the drive was replaced, left alone for a while

then wanted to test a straight 2005 install

  1) removed the broken 2005 attempt

  2) removed the 2000

  3) installed 2005 and got the error on the subject line:

TITLE: Microsoft SQL Server 2005 Setup

SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in S

SSAS 2008 - The OLAP data source has no property fields available for this dimension


Last week I was able to view member properties for my Product Dimension in Excel 2010 pivot tables. Suddenly, without having made any changes to the dimension (for example, in the Attribute Relationships window of the dimension), those member properties are no longer available in Excel. I get the error "The OLAP data source has no property fields available for this dimension" when I try to select "Show Properties in Report" or "Show Properties in Tooltips" in the Pivot Table. At the same time, member properties are available for all other dimensions. I have also not made any changes to the data source connection in Excel and in any event, there is no option in the data source connection to enable or disable member property visibility. I am using BIDS 2008 and SQL Server 2008 R2 (10.50.1600.1). Does anybody have an idea why this might be happening?


[Microsoft][ODBC Driver Manager] Data Source name not found and no device driver specified

I get the above error message when running my VB6 sp4 application on a new Win7 workstation (32 bit machine). The app runs fine on a WIn xp sp3 workstation. The app does require a DSN setup in the ODBC section and I setup the SQL connection the same as I do on an XP machine. I also test the connection on the WIN & machine and it "test successfully". After the error above the app returns a runtime error -2147467259 (80004005). I am attaching my connection string:
Connection string being used by ADO Data Control (part of VB6):
Any help would be appreciated.


Data source not found issue in subscribed report (subscribed in ssrs 2005) , with shared data source


Recently we have upgraded from SQL 2005 to SQL 2008. Following is the issue am facing in some reports in SSRS 2008. More details are below. Any solution/ cause for the issue would be of great help.

 1) Reports having issue are the ones which were deployed in SSRS 2005 through SUBSCRIPTION (Listed under My Subscriptions) and now tried to view in SSRS 2008.

2) The reports use a shared data source with name ‘Test Center’

3) After upgrading to 2008 and when we try to open the report data source not found error is thrown. “An error occurred during client rendering. An error has occurred during report processing. The data source ‘Test_Center’ cannot be found". Why does it have ‘_’ added in the data source name !!

4) When we go to the report Properties – Data sources and check the path of the shared data source, the path is correct and the data source do exists in the path.

5) If we go to report Properties – General – Report Definition – select Edit and save the RDL. Immediately select Update and browse the saved RDL and upload. The report works fine. However the data source reference still remains same.

6) Also if we deploy a report fresh referring the same data source, that too runs fine with no issues.

- Thanks & Regards, RaSuHe

osql & "Data source name not found and no default driver specified"


OK, I see that this issue has been posted elsewhere, but I have not been able to use those posts to solve my problems.  I'm trying to run a  sql script using osql.  The batch cmd listed below  brings up an osql command prompt on our servers, which means I'm connected, correct? These servers both have SQL Server installed.

CALL osql -S servername -U userid -P password

But why can't I run this same command on my desktop?  I get the "Data source name not found and no default driver specified" error.  I don't have SQL Server installed, but I do have the SQL Server client installed and I can access the DB thru SQL Server management studio without any problems.  I checked and it does appear that I have the SQL Server native client installed on my desktop.

InfoPath 2003 - Populate Data Field based on text field from secondary/different data source.


I have a form where the main fields are populated based on the results of a query field.
Ex, Main Data (SQL) Source: 

Fruit         Color
Apple       Red
Orange     Orange
Pear         Green
Banana     Yellow

Secondary Data Source (Sharepoint List)
Fruit         Code
Apple        1001
Orange     1002
Pear         1003
Banana     1004

What I would like to do is create form fields that will automatically populate based on the contents of the text field.
Ex,  (text field)   Please enter your fruit of choice:   [ Apple ]

(Field 2 - from main SQL data source)          The color of your fruit is [ RED ]

(Field 3 - from secondary Sharepoint List data source)  Your fruits code is  [ 1001 ]


Any suggestions would be greatly appreciated.

how to get dropdown list data VALUE FIELD property in JavaScript



im getting  'ON' as value instead of its actual value

abstract away the source of the connection string using a class with a static property.

ASP.NET provides a configuration system we can use to keep our applications flexible at runtime. In this article we will examine some tips and best practices for using the configuration system for the best results.

The element of a web.config file is a place to store connection strings, server names, file paths, and other miscellaneous settings needed by an application to perform work. The items inside appSettings are items that need to be configurable depending upon the environment, for instance, any database connection strings will change as you move your application from a testing and staging server into production.

Let's abstract away the source of the connection string using a class with a static property.

Rendering data with HTML tags in the DD Gridview for a selected column


I am having trouble finding out where and how to HTML Encode a cell's data on the Dynamic Data (v4.0) gridview of List.aspx.  As a simple case, suppose I have formatted cell data that is A<br/>B in the DB.    Obviously, I want A stacked on B in the cell.

It seems gridView1.HtmlEncode = true has gone away.

So maybe I'll try to catch it on the RowDataBound event:

protected void GridView1_RowDataBound(Object sender, GridViewRowEventArgs e)

            if (e.Row.RowType == DataControlRowType.DataRow)
                // Html Encode the cells


but this event never fires?

Has anyone figured out how to properly render HTML tags data in the List.aspx's GridView1? 

If I figure this out, then I can add a MetaAttribute called something like [EncodeAsHtml(true)] and be on my way.  Thanks!

Toolbox: Data Snapshots, Subversion, Source Code Organization and More


If you want to save, organize, and annotate snapshots of your database data, find an easy way to install and configure Subversion, and automate the organization of your source code, then you'll want to read more about these latest tools.

Scott Mitchell

MSDN Magazine August 2009

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