![]() ![]() Can you tell me what version of MySQL, ODBC (32/64) that you are using to connect. How to pass Parameter at run time in my sql query.for SSRS reportįor example: select * from T where give me answer by Novem8:33:48 PM - Marcwolf I am also looking how to use parameters with SSRS and mysql, could you please give me some hints if you have them. Hello, have you read this forum to solve the parameter problem? Wednesday, 11:01:24 AM - Daniel Calbimonte I am accesing a Mysql database in the cloud (a server at Heroku, a cloud applications platform). Thanks Daniel, It's work very nice, i Created my first report without problems. how to get the meaningfull information from this report. One new report which will be have some data from SQL server and some data from MYSQL, combining those tables from 2 database and that too in different environment. One database is :- sql server and other is in mysql database. I ' ve typical requirement where there is 2 database hosted in 2 different environment , It gives following error message :Īn attempt has been made to use a data extension 'ODBC' that is either not registered for this report server or is not supported in this edition of Reporting Services. I am successfully able to connent MYSQL though ODBC, In Visual Studio I am able to create repots and preview them, But I have one problem when I try to deploy my code on server. (rsErrorOpeningConnection)ĭo you have any suggestions on what might be going wrong in my case? I tried this in two ways:ġ) simply uploading this report on Report ServerĢ) Deployed the project on the report server.īut when I tried to run it from Report Server using Report Builder it gives error as:Īn error has occurred during report processing. (rsReocessingAborted)įor more information about this error navigate to the report server on the local server machine, or enable remote errorsĬannot create a connection to data source 'MySQLCADUAT'. But as this report was created on my local machine, I want to keep it on the Report Server so it can be shared with other users. I followed these instructions to create a report and was able to successfully create report (connecting to MySQL DB). This will work with both SSRS and ReportBuilder.Īt least that is my experience, the DSN name seems to be the key and the application will pick the appropriate 32 or 64 bit system data source. You then create a data source in SSRS as described in this post, for example DSN=HolocomDevRW. In order to get a DataSource that works with both you have to install both 64 and 32 bit ODBC Drivers and set up SYSTEM DSNs with identical names using both drivers. SSRS is 64 bit and ReportBuilder 3.0 is 32 bit. Wednesday, Aug10:59:03 AM - Richard Frenkel Does the ports need to be opened between the SSRS and the MySQL DB, or between the SQL Server DB and the MySQL DB?Īnd how I get the report to my networked printer? If the SSRS is on a separate machine than the SQL Server backend database. ![]()
0 Comments
Leave a Reply. |