More Detail Documentation in Connecting to MYSQL

Stimulsoft Reports.JS discussion
Chan Kuan Leang
Posts: 74
Joined: Sun May 20, 2007 9:14 pm
Location: Singapore

More Detail Documentation in Connecting to MYSQL

Post by Chan Kuan Leang »

Is there a more detail documentation in connecting to MYSQL?

So far, I not able to connect. I not able to find mysql connection.

Image


In the Stimulsoft_Reports_Programming_Manual.En documentation there is a paragraph about "Minimum Server Instance". What does it means?

Image

Smile
Chan Kuan Leang
Smile
Chan Kuan Leang
HighAley
Posts: 8431
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: More Detail Documentation in Connecting to MYSQL

Post by HighAley »

Hello.

It seems that you use our old build.

Here is the list on all available connections in Reports.JS in our current build.
Connections.png
Connections.png (25.63 KiB) Viewed 5672 times
All SQL connections needs server-side data adapters. You could find them in our distributive.

To access the databases you need to specify URL address to the PHP server.
JavaScript sends POST requests to the specified URL address and takes data in the JSON format.

Code: Select all

StiOptions.WebServer.url = "http://mywebsite.com/script.php";
Thank you.
Chan Kuan Leang
Posts: 74
Joined: Sun May 20, 2007 9:14 pm
Location: Singapore

Re: More Detail Documentation in Connecting to MYSQL

Post by Chan Kuan Leang »

Can I check where do I need to place the folder DataAdpaters? Inside the public folder?
I am using php.

Smile
Chan Kuan Leang
Smile
Chan Kuan Leang
Chan Kuan Leang
Posts: 74
Joined: Sun May 20, 2007 9:14 pm
Location: Singapore

Re: More Detail Documentation in Connecting to MYSQL

Post by Chan Kuan Leang »

Sorry, is there even more examples on mysql connection thru php?
So far, I am still struggling on the connection.

Thanks.

Smile
Chan Kuan Leang
Smile
Chan Kuan Leang
HighAley
Posts: 8431
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: More Detail Documentation in Connecting to MYSQL

Post by HighAley »

Hello.

Later today our next build will be available on our site.
You could find a sample there.

Thank you.
Chan Kuan Leang
Posts: 74
Joined: Sun May 20, 2007 9:14 pm
Location: Singapore

Re: More Detail Documentation in Connecting to MYSQL

Post by Chan Kuan Leang »

Image


If I am using Mac to design a report, how do i connect to mysql database?
What do I need to put in this connection string?

Thanks.

Smile
Chan Kuan Leang
Smile
Chan Kuan Leang
HighAley
Posts: 8431
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: More Detail Documentation in Connecting to MYSQL

Post by HighAley »

Hello, Chan.

The MySQL database is supported in Stand-alone Designer.
Could you specify how do you run the Designer?

Thank you.
Chan Kuan Leang
Posts: 74
Joined: Sun May 20, 2007 9:14 pm
Location: Singapore

Re: More Detail Documentation in Connecting to MYSQL

Post by Chan Kuan Leang »

I just click on the Designer app icon in my application folder in my mac.

Smile
Chan Kuan Leang
Smile
Chan Kuan Leang
Chan Kuan Leang
Posts: 74
Joined: Sun May 20, 2007 9:14 pm
Location: Singapore

Re: More Detail Documentation in Connecting to MYSQL

Post by Chan Kuan Leang »

Image

Can I know what is this error?
This happened which I trying to create a new data source or view data.

I just cannot see the table data.
I am using Mac designer.app.

Smile
Chan Kuan Leang
Smile
Chan Kuan Leang
HighAley
Posts: 8431
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: More Detail Documentation in Connecting to MYSQL

Post by HighAley »

Hello.

Sorry, for this error.
We have made an improvement.
Please, check our next build on Thursday.

Thank you.
Post Reply