.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

Provider selection gray, unable to change it in Data Source Creation

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :Sql Server

I am trying to create an Ad Hoc report project using SSRS2005.  We are using Oracle 10G and I have Visual Studio2005.

I have the Oracle client installed and I am an administrator.

I create a new "Report Model Project " and attempt to create a new data source, but with "Create a data source based on an existing or new connection " selected, I click on "new " where I should be able to specify the database, but the Provider shows "SqlClient Data Provider " and is grayed out so I can't change it.

How do I tell it I want to point to Oracle data?  I have no trouble normally doing this with an SSRS report but this is the first time I have tried an Ad Hoc report so I don't know what the problem is.

View Complete Post

More Related Resource Links

mysql data source provider - mysql connector/net

Dear All, I having problem installing mysql connector/net 6.2.3 on my vsd 2010 because the installed went smoothly but when Im trying to use the mysql on data source provider, I cant see it on the list and when try to install/change the connector the visual studio integreation has an x mark meaning to say it was not installed on my vsd2010.  Thanks.

change data source of cube

how to change data source of cube?

Data view web part: Change Data Source

I have a data view web part that I would like to use multiple time in the same page, but tied to different sharepoint lists.  Is there an efficient way to do this?

I can add additional data sources, but I don't see how I can remove the original.

xml secondary data source used for drop down selection how do I return additional fields to form bas


I received some much needed assistance from this forum in the past. My current situation is that I have a xml data connection to a sharepoint list over an employee database that works fine. It allow me to connect to a view on the sharepoint list correctly and display the info which is a drop down on a last name field. I now need to be able to select a last name such as Doe and have other fields such as job code be populated on the form from the same sharepoing list I have already connected to. Any direction is greatly appreciated.



Unable to drag data source to control to bind


I have a simple test application following the directions from http://msdn.microsoft.com/en-us/library/dd465159.aspx .  When I attempt to drag the data source onto the design surface I get the following error:

Cannot add the control to the design surface or bind to the control because the type TestApp.AdventureWorksEntities cannot be resolved.  Please try to build the project or add necessary assembly references.

The project as been built and the data source is in the same namespace.  I did a search for this error and the only hit I found was here, and mentioned Tools->Options->Extension Manager, 'Load per use extensions...'.  This option is checked.  I've tried unchecking and restarted with the same behavior.

Any ideas?


Unable to change autogrowth properties of SQL Server 2008 data and log files


I have used the GUI and the CLI to attempt to change SQL Server 2008 log file autogrowth property all to NO avail. In other words, there are NO error messages of any kind, indeed the CLI reports that the command completed successfully. But re-examining the database properties shows that NO change was effected.

For the CLI command, I have used the following with dots filled in for my database and logfile:


Why doesn't this work? How to make it work?


Unable to connect with IBM DB2 using IBM DB2 .NET Data Provider 9.1.5 with ADO Destination Component


As we are passing through critical phase of the project and we are facing following issues which need to be resolved.Please help on this.

Currently we are transferring Data from SQL Server to DB2 using SSIS (SQL Server 2008).The IBM DB2 version is DB2 ESE 9.1 Fix Pack 5 on Linux 4.8.

1] Unable to connect with IBM DB2 using IBM DB2 .NET Data Provider 9.1.5 in SSIS 2008 at run time (although the connection is tested successfully with IBM DB2 using IBM DB2 .NET Data Provider 9.1.5 in SSIS 2008) and the error is

"[ADO NET Destination [6096]] Error: An exception has occurred during data insertion, the message returned from the provider is: Object reference not set to an instance of an object. "

I tried to use CozyRock DB2 Destination component instead of ADO destinatoin Component then i am able to use IBM DB2 .NET provider at run time.

Also i tested connection successfully using IBM DB2 .NET Data Provider 9.1.5

Change the way data is passed from the provider to the consumer




I created a consumer in SharePoint 2010 which is receiving data from a list view.

But in order to pass the data from the list view to the consumer, I need to press the a button under the "select" column.

I want to pass the data by pressing the title of the item.

How can I implement that?

Change data source view for dimension


Is it possible to change the data source view the dimension gets the table definition from?

Basically I would like to restructure the ds views and dimensions I created earlier are reading from ds views that are no longer appropriate.   Tables would be exactly the same.

Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server


Dear All,

please to try to help me what could be the problem ?. when  i try to excute my stored proc in my sqlserver management studio it excuting fine when i trying to Excute using Asp.net application it giving Error. iam working on Sql Server, mt linked server is Oracle. my proc is like :

select  ID,Name  from OPENQUERY(TEST, ''
 ID ,
 Name  from Details)

Error:Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "TEST".
OLE DB provider "OraOLEDB.Oracle" for linked server "TEST" returned message "ORA-01017: invalid username/password; logon denied".
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.

Please try to guide me i unable run using asp.net App

thanking you,


Need Oracle Data Provider .CS File for Oracle 10g Database connection !



I need a 'Wrapper.cs' file which takes care of the Database connection ( Oracle 10g) where

i can just call the method with my SQL Query


Gridview1.DataSource = SampleWrapper.ExecuteDatatable("THE SQL QUERY");


Plz Post the link if there is any open source !    

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

Data Points: Data Source Controls in ASP.NET 2.0


ASP. NET 2. 0 introduces a series of new tools that improve data access including several data source and data bound controls. The new assortment of data source controls can eliminate a ton of repetitive code that was required in ASP.

John Papa

MSDN Magazine January 2005

ADO.NET: Building a Custom Data Provider for Use with the .NET Data Access Framework


The System.Data.dll assembly in the .NET Framework contains namespaces whose base classes can be used to create custom data providers. These namespaces also define a number of data access interfaces and base classes that let developers create data providers that will interoperate with other custom providers. Using the ADO.NET classes Connection, Command, DataReader, and DataAdapter, writing a provider is easier than writing one for OLE DB. This article explains these classes and their implementation, and how they can be used to write a variety of different kinds of data providers.

Bob Beauchemin

MSDN Magazine December 2001

Change data on gridview bind


Hi there,

Simple little problem. i have a gridview that shows products assigned to a customers job. They are displayed in exVAT prices. To make it easier i want to show the inc VAT prices. How can i add VAT to 1 column in this table?

Empty Website Data Source windown


Hi all,

I am Visual Web Developer user and facing a problem when I am creating a local report (.rdlc) file.

I am using Business objects as the Data Source for this report. It was working perfectly until all the items in the Website Data Source window suddenly "disappeared". The "Add New Data Source" button on this window is also disabled. Now the window is just like a blank box only. And I can't continue working with the report file like this...

I have tried undoing what I did before but it does not help at all...

Any reason for this to happen? There is no sign or something at least indicating what is wrong.

Please help.


 ps: found a similar thread in this forum but not solved

How can I change the color of my clandar by data from Db

Sub DayRender(ByVal source As Object, ByVal e As DayRenderEventArgs)

            Dim i As Integer
            For i = 0 To DataGrid1.Items.Count - 1
            'If (DataGrid1.Items(i).Cells(1).Text = e.Day.Date) Then
            'If (DataGrid1.Items(i).Cells(0).Text <> "") Then
            If (DataGrid1.Items(i).Cells(1).Text.Equals(e.Day.Date.ToString)) Then

                '  e.Cell.BackColor = Color.DarkOrange
                e.Cell.BackColor = System.Drawing.Color.Red
                e.Cell.ForeColor = System.Drawing.Color.Yellow

            End If
now I click the day on clendar, which have data from db it chage color ,  How can I let when the calendar is load wich day have dat in db change color ?

    End Sub


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