Devart Forums

davidh

I have made those changes and have been able to connect and create reports based from the MySQL database.

However I had to copy the connection string from another project as the button for generating the connection string was disabled in SSRS.

Also I can't seem to get parameters to work properly, either using :param or @param seems to fail at the "Preview" tab.

davidh

1) All those files appear to be there without issue.

2) I can't find any reference to devart in any of the .config files. I'm assuming this is where the issue lies.

Can you tell me the strings to copy into each of the files (and where they go).

Thanks in advance

davidh

I don't get any entries for Devart in the 'Type' drop down (unlike the screen shot you sent me).

my dotConnect is: 5.20.29.0

I had a previous issue of Devart.Data.MySql.xsl cartridges not being available for SSAS projects. Could this be the same issue? Where should these cartridges be located for the SSRS projects/software?

I'm using
OS: Windows XP
Visual studio: 8.0.50727.42
SQL server: 2005

davidh

When I use SSRS I can't find the dotConnect for MySQL option available for my "shared data source".

Is SSRS in Microsoft visual studio 2005 not supported?

I am currently using the trial copy of dotConnect as I'm waiting for the purchase order to get back to me (it's with the head of department).

davidh

My files needed slightly different locations as I'm using visual studio 8 and SQL server 2005 but the fix appears to have worked. Although at present I seem to have found a new bug which I'm playing with (This new bug is of my own creation).

These is the locations that I copied the file to for anyone else looking for a solution for the same problem:

%Program Files%\Common Files\System\Ole DB\Cartridges
E:\SQL Server 2005\MSSQL.2\OLAP\bin\Cartridges
%Program Files%\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\DataWarehouseDesigner\UIRdmsCartridge
%Program Files%\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\DataWarehouseDesigner\UIRdmsCartridge

davidh

Product Version: 5.00.22 16-Feb-09
OS Version: Windows Server 2003
Platform: x32

I am currently testing the dotConnect software for use within our growing BI environment. My aim is to use the software to build cubes directly from MySQL however when I try to build the cube I get the following error message:

Code: Select all

Errors in the high-level relational engine. The following exception occurred while the managed IDbCommand interface was being used: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[issue].[issue_onsale_date_value] AS [issueissue_onsale_date_value0_0]

This seems to be the same issue described here: http://www.devart.com/forums/viewtopic. ... be&start=0

However The version number I'm working with is newer so I assume the issue/solution could be different.

I restarted the server to ensure that the services and any application changes had been made and the error persists.

Devart Forums

Search found 6 matches

SQL Server Reporting Services - dotConnect not available

dotConnect 5.00.22 Microsoft Analysis Services cube building