Page 1 of 2

SQL Reporting Services

Posted: Mon 27 Feb 2006 20:50
by Carolus.Holman
I am trying to use MySQLDirect.Net to connect to a mySQL database through the ReportingServices project. I cannot figure out how to have MySQLDirect show up as a valid datasource in the choose datasource dialog box. Currently the "Type:" are

Microsoft SQL server
OLE DB
Analysis services
ORACLE
ODBC
XML
report server model

Any ideas how to use this in reporting Services?

Posted: Wed 01 Mar 2006 09:10
by Serious
MySQLDirect .NET licensing schema does not allow to use data provider with Reporting Services. We work on this problem now.

Posted: Mon 27 Mar 2006 06:07
by techman
thin kthats the the same prob i have - is it solved in 3.5 beta?

Posted: Mon 27 Mar 2006 09:15
by Alexey
It is fixed in 3.50 release version.

Posted: Mon 27 Mar 2006 10:31
by techman
Wow cool!

Any ETA? (This week maybe?)

Posted: Tue 28 Mar 2006 12:42
by Alexey
We update products on our site every week. So that by the end of the week new beta version or release version should be available for downloading from our site.

Posted: Thu 13 Apr 2006 16:59
by phyzfer
How do we implement the MySQLDirect.NET Data Provider into SQL Server 2005 Reporting Services? I understand and know how to configure SQL Server 2000 to handle exteranal data sources, by using Data Processing Extensions -- but in 2005, the files (RSReportDesigner, RSReportServer, etc) are located in different locations, and I can't figure out what should be used for the settings of the and tags for these files. Any help??


thanks,
phyzfer

Posted: Mon 17 Apr 2006 13:24
by Alexey
Please read the discussions about Reporting Services here:
http://crlab.com/forums/viewtopic.php?p=11581#11581

Posted: Mon 17 Apr 2006 15:30
by phyzfer
thanks but...forwarding me to a post that I originally started isn't really a resolution to my problem. And then posting

"You need MySQLDirect .NET installed on the machine where SQL Server 2005 Reporting Services reside."

Is hardly a solution at all! Of course I have MySQLDirect.NET installed on the machine were SQL Server RS resides...How do I configure RS to see the MySQL Data Provider!?

much thanks,
phyzfer

Posted: Thu 27 Apr 2006 09:34
by Alexey
We are investigating this problem. You will be notified on results here.

Posted: Tue 09 May 2006 15:19
by phyzfer
figure anything out yet??

Posted: Tue 16 May 2006 08:11
by Alexey
Reporting Services support will be available in the next major version.

Posted: Mon 22 Jan 2007 11:36
by Alexey
New beta of MySQLDirect .NET 4.00.1 with SQL Server 2005 Business Intelligence Solutions support is available for download now.

Posted: Tue 30 Jan 2007 15:04
by MrBishop
I'm not using Reporting Services (at this time), but would the fix you mentioned also apply to my question in this thread: http://www.crlab.com/forums/viewtopic.php?t=8750?

Posted: Wed 31 Jan 2007 06:33
by Alexey
There is no fix. We are extending our functionality. MySQLDirect .NET still needs to be installed on a target machine.