Dear visitor, despite the COVID-19 outbreak, our team continues operating at full speed.

Also, here is the form where you can apply for a special discount and we will contact you with possible options. Stay safe and continue achieving your business goals.

Fill the form
Get Free Trial
Get Free Trial

Exporting SQLServer data

Answered
Jimmy Urrutia asked on April 27, 2020

 
hello, a pleasure to greet you … well I have been presented with this problem … the company has two license keys, one for development and another for final product … the point is that in development it is linked to another server and to another domain … up to there all good … the problem arises when I want to make sqlserver query throws me this error …
Unable to open file http://www.campany.com/librery/flexmonster/DataBase.php?Type=SQL_LCA&Query=l2iYdoiGYV1neqeEkkOMfnZ1klGnlZShn2GtgaKjw5ylhsCmt5eQpauZx644
It seems that this file doesn’t exist or ‘Access-Control-Allow-Origin’ header is absent in the requested resource.
Read more info about this error
Details: Internal Server Error
okay
https://www.flexmonster.com/doc/typical-errors/#unable-to-open-file
and at the end of the reference you are placing an id is this & 441111426.
also part of the URL is enciphered for security but that works well we are more than safe
but if it turns out that I make a query to mariaDB it works well for me on that same server … but another important point is that on the other server with the other key … everything works wonderfully … without problems.

3 answers

Public
Jimmy Urrutia April 27, 2020

Also… I was reading this …

 

CSV and JSON support is not available in the current edition.
Each license key is bound to a data source. Check that the data source type for your license key, the type of the downloaded package, and the data source type you are using are the same. If you want to test a data source that is not included in your licensing plan, leave us a request via Contact Us form.

MS OLAP support is not available in the current edition.
Each license key is bound to a data source. Check that the data source type for your license key, the type of the downloaded package, and the data source type you are using are the same. If you want to test a data source that is not included in your licensing plan, leave us a request via Contact Us form.

Elasticsearch support is not available in the current edition.
Each license key is bound to a data source. Check that the data source type for your license key, the type of the downloaded package, and the data source type you are using are the same. If you want to test a data source that is not included in your licensing plan, leave us a request via Contact Us form.

 

And what I was thinking is that for the license they give for development … can’t you use SQLserver? single mariadb or mysql

because for you of the final product if you can for SQLserver, mariadb and mysql why have we tested it

 

Public
Jimmy Urrutia April 27, 2020

I want to test a data source that is not included in your licensing plan … the company bought flexmoster and from this they provided us with two licenses … one of final product and the other of development … the first one does not have problems is linked to a domain and query data from sqlserver, mysql, mariadb … the second one is linked to another domain but I can only query data from mariadb … and I can’t query from sqlserver and I need to do it …

and both case one and two keep the same code … their difference is the key

Public
Dmytro Zvazhii Flexmonster April 28, 2020

Hello Jimmy,
Thank you for writing to us.
As far as we know, both of the mentioned licenses have the same parameters. They both support the same data sources.

Please note, there is no difference which data storage you are using as soon as you pass the data to Flexmonster in JSON/CSV format.

Still, considering Flexmonster’s error text from your first message, it seems that the issue is related to the server-side script. We recommend checking the server-side script and browser’s console log.

It would be really helpful if you could provide us with the browser’s console log. That would help us a lot in our further investigation.
Waiting to hear from you.
Regards,
Dmytro

Please login or Register to Submit Answer