Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
Add a reply View Replies (7)

Resolved StudioPro is not connecting to the dB in the ADD New Query window

  1. john smith
    john smith
  2. Report Editor
  3. Wednesday, September 18 2024, 10:23 AM
  4.  Subscribe via email
I am just getting started with Studio Pro. In attempting to create my first Project Query, the <Add New Query> window pops up and when i select the database connection, a Red -Exclamation- sign appears next to it. Says: Unable to open the Datasource! I am selecting the datasource from a bookmark that has already been opened and displays my tables/columns (MySQL) from a DigitalOcean Server.

I have very limited understanding of how ANY plugins work and no background in writing software other that some uneducated xojo/mysql use in the past.

Thanks
John
Attachments (1)
Screenshot (1).png Screenshot (1).png
Comment
There are no comments made yet.
Responses (7)
Sergey Pashkov
Sergey Pashkov Accepted Answer
A data source is an object containing connection information.
When we create a data source, this information is pulled from the established connection.
When we create a query, it attempts to find an existing connection or create a new one using this information.

However, it seems the information is not saved correctly (Connection type is Unknown).

Maybe try disconnecting and reconnecting to the server, then attempt to create the data source again? The data source properties should be filled for proper functioning.
Comment
There are no comments made yet.
  1. 2 weeks ago
  2. Report Editor
  3. # 1
john smith
john smith Accepted Answer
It does not show the datasource information. Can I ask... what triggers that error message? Is there anything i could have not installed correctly or a setting i may have that is not allowing the connection to go thru? What is the difference between creating a connection from the reports editor and from the schema editor? my initial creation of the source was done in the schema editor.
Comment
There are no comments made yet.
  1. 2 weeks ago
  2. Report Editor
  3. # 2
Sergey Pashkov
Sergey Pashkov Accepted Answer
I don't see anything wrong for now.
I installed Valentina Studio 64-bit on Windows 10 and created a Digital Ocean MySQL database.

I have added screenshots of my workflow.

Does it show anything in 'Show Datasource String' at step 3?
Attachments (4)
1-digital-ocean-bookmark.png 1-digital-ocean-bookmark.png
2-digital-ocean-datasource.png 2-digital-ocean-datasource.png
3-digital-ocean-show-datasource-string.png 3-digital-ocean-show-datasource-string.png
4-digital-ocean-query.png 4-digital-ocean-query.png
Comment
There are no comments made yet.
  1. 2 weeks ago
  2. Report Editor
  3. # 3
john smith
john smith Accepted Answer
It was, and didn't work there so i just downloaded 14.5 and thats where i am. Same thing either version. I keep thinking it has to be something i installed wrong!
Comment
There are no comments made yet.
  1. 2 weeks ago
  2. Report Editor
  3. # 4
Sergey Pashkov
Sergey Pashkov Accepted Answer
No, it should work. I'll recheck it now.
Is it version 14.1.x?
Comment
There are no comments made yet.
  1. 2 weeks ago
  2. Report Editor
  3. # 5
john smith
john smith Accepted Answer
I deleted the connection and recreated it. No Go
Still have the same red exclamation error
Could there be something I neglected to install somewhere?
Comment
There are no comments made yet.
  1. 2 weeks ago
  2. Report Editor
  3. # 6
Sergey Pashkov
Sergey Pashkov Accepted Answer
Hello John,

It looks like the datasource object is incorrect (Connection shows "Unknown," and the URL and user are empty). What happens if you delete it and recreate it? Do the same properties still appear?
Attachments (1)
Screenshot 2024-09-18 at 15.02.18.png Screenshot 2024-09-18 at 15.02.18.png
Comment
There are no comments made yet.
  1. 2 weeks ago
  2. Report Editor
  3. # 7
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories