I could do what you said from the beginning. That is not what I asked about. I do have a SQL script file opened in NB. I have established connection to MySQL. I want to execute this file without copying its contents to the Execute Command window. For that purpose, SQL files has set of buttons on the top: Run SQL, Run Selection, etc. Those buttons do not work properly. They throw me out to Derby connection, which is not active.
From: Don <don.albert...@gmail.com> Sent: Tuesday, October 16, 2018 12:16 PM To: Greenberg, Gary <ggree...@visa.com> Subject: Re: Executing SQL file in NB Right-click the connection. Select Connect Right-click again Select Execute Command On 10/16/2018 02:42 PM, Greenberg, Gary wrote: I have created database connection to MySQL in NB 8.2 (I can't upgrade to newer version without installer due to the company security constraints). It is working and I can execute some commands. However, I do have a SQL script in the file which I want to execute. I do have connection selected in 'Services' tab, but when I click on the button 'Run SQL', NB always trying to establish connection with default Derby and certainly failing. Whatever I tried to do to make it use proper connection, nothing works. Is it a bug or there is a "secret souse" that I haven't apply? Gary Greenberg Staff Software Engineer Data Product Development ggree...@visa.com<mailto:ggree...@visa.com> Mobile: (650)269-7902 [/Users/nkavumpu/Library/Containers/com.microsoft.Outlook/Data/Library/Caches/Signatures/signature_749324139]
