SQL Reporting Services

SQL Reporting Services

Postby Carolus.Holman » Mon 27 Feb 2006 20:50

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?
Carolus.Holman
 
Posts: 1
Joined: Mon 27 Feb 2006 20:44

Postby Serious » Wed 01 Mar 2006 09:10

MySQLDirect .NET licensing schema does not allow to use data provider with Reporting Services. We work on this problem now.
Serious
 

Postby techman » Mon 27 Mar 2006 06:07

thin kthats the the same prob i have - is it solved in 3.5 beta?
techman
 

Postby Alexey » Mon 27 Mar 2006 09:15

It is fixed in 3.50 release version.
Last edited by Alexey on Mon 27 Mar 2006 10:55, edited 1 time in total.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby techman » Mon 27 Mar 2006 10:31

Wow cool!

Any ETA? (This week maybe?)
techman
 

Postby Alexey » Tue 28 Mar 2006 12:42

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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby phyzfer » Thu 13 Apr 2006 16:59

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
phyzfer
 
Posts: 4
Joined: Thu 13 Apr 2006 16:53

Postby Alexey » Mon 17 Apr 2006 13:24

Please read the discussions about Reporting Services here:
http://crlab.com/forums/viewtopic.php?p=11581#11581
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby phyzfer » Mon 17 Apr 2006 15:30

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
phyzfer
 
Posts: 4
Joined: Thu 13 Apr 2006 16:53

Postby Alexey » Thu 27 Apr 2006 09:34

We are investigating this problem. You will be notified on results here.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby phyzfer » Tue 09 May 2006 15:19

figure anything out yet??
phyzfer
 
Posts: 4
Joined: Thu 13 Apr 2006 16:53

Postby Alexey » Tue 16 May 2006 08:11

Reporting Services support will be available in the next major version.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Alexey » Mon 22 Jan 2007 11:36

New beta of MySQLDirect .NET 4.00.1 with SQL Server 2005 Business Intelligence Solutions support is available for download now.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby MrBishop » Tue 30 Jan 2007 15:04

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?
MrBishop
 
Posts: 13
Joined: Tue 31 Oct 2006 19:29

Postby Alexey » Wed 31 Jan 2007 06:33

There is no fix. We are extending our functionality. MySQLDirect .NET still needs to be installed on a target machine.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Next

Return to dotConnect for MySQL