1. Ivan
  2. Valentina Studio
  3. Thursday, November 12 2020, 11:41 AM
  4.  Subscribe via email
Hallo,
in first point - thank you for awesome toll for SQL works!!!
I have short question: I must connect to many different database daily. I want jump direct to SQL editor. I want run some batch/script. I found in documentation that I can create shortcut with command
vstudio.exe -open_connection "postgresql://host = 'localhost' port = '5432' user = 'postgres' password = 'postgres' dbname='pagila'" \
its super possible, but I can connect to database only over SSH. Is it possible? If yes, how?
Function example of my connecting in screenshot
Thank you for your help

Ivo
Attachments (1)
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello Ivan,

Yes, it is possible.
Please try to add the following params to your connection string:
ssh = 'true' ssh_host = 'termix.aa.cz' ssh_port = 3333 ssh_user = 'user581' ssh_password = 'userpass'

The same format of the connection strings is used in reports, so the documentation should work here:
References
  1. http://valentina-db.com/dokuwiki/doku.php?id=valentina:products:adk:api:vproject_class:report_factory_any
Comment
There are no comments made yet.
Ivan Accepted Answer
Ooo super. Thank you so much for turbo quick response.
I will try it.
Pls continue in good work.

Ivo
Comment
There are no comments made yet.
  • 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