1. Ivan
  2. Valentina Studio
  3. Четверг, Ноябрь 12 2020, 11:41 AM
  4.  Подписаться через 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
Вложения
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
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:
Ссылки
  1. http://valentina-db.com/dokuwiki/doku.php?id=valentina:products:adk:api:vproject_class:report_factory_any
Комментарий
There are no comments made yet.
Ivan Ответ принят
Ooo super. Thank you so much for turbo quick response.
I will try it.
Pls continue in good work.

Ivo
Комментарий
There are no comments made yet.
  • Страница :
  • 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