Creating reports and dashboards | Stimulsoft community forum

----------------------------
[Customer Explanation]

Hi,
I'm trialling the latest version of your software for .Net.
I have a VB.Net 2010 application that uses oledb to connect to an access database which I want to try your reporting softwrae in.
When I launch the designer and try to connect to the database I get the error detailed below.

I know that the provider is registered, as if I check the connection string in my application, that is the provider it uses.

I am running Windows 7 64 Bit, Visual Studio 2010 and have MS Office 2010 32 Bit installed.

Regards,

Jon



----------------------------
[General Info]

Application: Stimulsoft Reports.Net
Framework: v4.0.30319
Version: Version: 2011.1.1000 from 4 April 2011
MachineName:
OSVersion: Microsoft Windows NT 6.1.7600.0
UserName:

----------------------------
[Exception Info]
Message: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Source: System.Data

StackTrace:
at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper)
at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at Stimulsoft.Report.Dictionary.MSAccessConnectionEditor.bTest_Click_1(Object sender, EventArgs e)

----------------------------
[Assemblies]
mscorlib, Version = 2.0.0.0
Stimulsoft.Base, Version = 2011.1.1000.0
Stimulsoft.Report, Version = 2011.1.1000.0
Stimulsoft.Report.Design, Version = 2011.1.1000.0
System.Windows.Forms, Version = 2.0.0.0

You might need to compile your VB.NET 2010 project for x86. By default it compiles for 'Any CPU' and as a result the application runs as a 64 bit app on Win7 64.
As far as I know your application needs to be running as 32-bit to use the MS Access Jet drivers.

Maybe Microsoft have released a 64-bit version of them in the last year, but previously you needed to compile your apps as 32-bit to get them working with the MS Access Jet driver.

Thanks for the response Brendon.
The problem isn't running Stimulsoft inside my application, I get the error when I run the designer outside the application from the stimulsoft program group.
If I try to connect to any access 2010 database from the designer the connection fails with the specified error.

I have a work around by dumping my data from weithin the application into an xml file, and then using stimulsoft to report on this, so I know the error lies in stimulsoft between the connection in the designer, the ms driver & the database.

Having to 'double handle' the data, using an oledb dataset to get it from the database, and then persisting the data to an xml file, isn't ideal but it works.

So the issue is still Stimulsoft no believing the 'Microsoft.ACE.OLEDB.12.0' provider is not registered, but it is because my application uses it.

Jon.

Hello,

We couldn't reproduce this bug.
Please check the OleDb provider for Access from the following link:
http://www.microsoft.com/download/en/de ... n&id=13255

Thank you.