DB Connections when opening sql file Follow
Answered
I have a project open with active db connections. When I open an sql file, I select the drop down "DB Connections". How come I do not see any of my current connections available in the list, only virtual ones? I should be able to select from one of the active ones and execute.
Am I missing a setting or something here?
Thanks.
Please sign in to leave a comment.
@Garou29
What do you mean by "DB Connections"?
Could you provide step by step description with screenshots?
When I open the script from the Files pane (double click on the filename), It comes up like the following:
I can't seem to execute it against the db I want. The "DB Connections" drop down has options for No Connection, Virtual connections, and setup connection (which is part fo the DB Navigator). Not sure why I would have to setup the connections again as it's already over there in the Database view.
@Garou29 You need to disable DB Navigator plugin for correct DataGrip work.
There is an issue https://youtrack.jetbrains.com/issue/DBE-6086 you can track and vote for.
That worked. However, I'm not seeing my Oracle or Postgres DB when trying to execute my script. I have gone to the Data Source Properties (Ctrl+Alt+Shift+S) and have even tried moving DBs from the Project Data Sources to Global Data Sources and they still aren't showing up:
@Garou29
You need to associate a script file with a console by dialect:
Or invoke Run action from file context menu:
and choose target data source:
Let me know if there are any problems.
Perfect. Thank you for your patience and help, it's greatly appreciated.