DB Connections when opening sql file

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.

6 comments
Comment actions Permalink

@Garou29

What do you mean by "DB Connections"?

Could you provide step by step description with screenshots?

 

0
Comment actions Permalink

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.

0
Comment actions Permalink

@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.

 

0
Comment actions Permalink

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:

 

0
Comment actions Permalink

@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.

0
Comment actions Permalink

Perfect. Thank you for your patience and help, it's greatly appreciated.

0

Please sign in to leave a comment.