Page 1 of 1

connect Stimulsoft with Mysql

Posted: Sun Sep 18, 2016 12:15 pm
by mahfouz
Hi,
I using the Stimulsoft to create a set of reports where system users can view it and design new report as who want.

but there a big problem in the library. where I must add connection data in the MRT file. and any user can see it

also, I'm trying to use JSON file and XML, but this way will not be an efficient way because of the data changed every hour.

I hope if there another solution in your bag
- if I can connect with MySQL and user can't see the connection details
- if I can link the MRT file with requested file return data (JSON or XML)

Re: connect Stimulsoft with Mysql

Posted: Mon Sep 19, 2016 12:07 pm
by HighAley
Hello.

The connection strings are parsed in the \stimulsoft\adapters\mysql.php file.
You could make any changes there and set the right connection string there.

Thank you.

Re: connect Stimulsoft with Mysql

Posted: Tue Sep 20, 2016 6:28 am
by mahfouz
i set the connection data in parse function in stimulsoft\adapters\mysql.php file

but how I can select the connection type.

I hope if you can send a full example to using Stimulsoft with MySQL connection.

Re: connect Stimulsoft with Mysql

Posted: Tue Sep 20, 2016 6:52 am
by HighAley
Hello.

The connection type should be specified in a report template.

Thank you.

Re: connect Stimulsoft with Mysql

Posted: Tue Sep 20, 2016 8:46 am
by mahfouz
Hi dear,
thanks for you

I using the library in create a lot of reports template to use it in the system

and the user can design report and re-design prepared the template.

I need to prevent the users from seeing the connection string in the report template.

I think there 2 solutions for this problem
1- prevent user from edit connection string
2- add connection string using code in PHP files
-----------

please send an example to explain the solution

Image

Re: connect Stimulsoft with Mysql

Posted: Wed Sep 21, 2016 9:07 am
by HighAley
Hello.

Could you specify which version of our product you use?
Which Designer do you use Flash or HTML5?

Thank you.

Re: connect Stimulsoft with Mysql

Posted: Thu Sep 22, 2016 7:19 am
by mahfouz
Hello,

I using version FXPHP_2016.08.26
and using HTML5 for designer

Re: connect Stimulsoft with Mysql

Posted: Fri Sep 23, 2016 6:01 am
by HighAley
Hello.

You could try to set next option:

Code: Select all

var options = new Stimulsoft.Designer.StiDesignerOptions();
options.dictionary.dataConnectionsPermissions = Stimulsoft.Designer.StiDesignerPermissions.View;
It hides the connection string from the users.

Thank you.