Provider cannot be found. It may not be properly installed

rbuser

I am using RB 11.07 with D2009.
I have a form set up that uses the ppDesigner.
I placed code in a button event that runs the ppDesigner.ShowModal method.

The 1st time I click the button, this message appears
"Provider cannot be found. It may not be properly installed."

The report comes up OK and I can view the proper data in the preview tab.
If I close the report and re-open it a 2nd time, the error does not appear.

I wrote the program on a Windows 7 x64 PC and it always works on this PC just fine.
When I try to run the program on another PC (Windows XP 32bit), I get this error.
I am connecting to a MSSQL database using the provider "Microsoft OLE DB Provider for SQL Server" using a UDL at the moment.
If the UDL test is viewed it looks like this on both the development PC and the production PC.

[oledb]
; Everything after this line is an OLE DB initstring
Provider=SQLOLEDB.1;Password=xxx;Persist Security Info=True;User ID=sa;Initial Catalog=accounting;Data Source=servername

When the report designer window is up, I see several data pipes in the Data Tree toolbar, when in fact, all I want is just the single data pipe I assigned to the report.

Any help would be greatly accepted!

nardmoseley

I do not think the error you are encountering is related to ReportBuilder.
ReportBuilder opens the DataPipeline - which will internally call
DataSet.Open. The DBPipeline only uses simple dataset methods such as Open,
First, Next, GetFieldValue etc.

Prior to opening the Report Designer. Try writing some code to open the
ADOConnection and open the DataSets.

myADOConnection.Open;
myADOQuery.Open;

myDesigner.Show;


The Report Designer Data Tree will show DataPipelines that you have created.
You can set DataPipeline.Visible to False to hide them from the Report
Designer.




--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

I think I answered my own question, but want other to know what I did to fix this...

As you know, when ppDesigner is activated, it "sees" all the data pipelines in the project.
It must also try to make them available to the report designer by default and try to open them up.
All I had to do was change the visible property of the ones I do not need to false and all is well.

nardmoseley

Using the Report Designer's Visual Data workspace (DADE) to build the report
queries is a common solution to this scenario. Then the report definition
includes the queries and no external DataPipelines are required.

The Report Designer's Data Tree displays all available DataPipelines. For
external DataPipelines with AutoCreateFields set to True (which is the
default value), the dataset may be implicitly opened when the DBPipeline
tries to retrieve the field information.


--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com