search

multiprocessio / datastation

App to easily query, script, and visualize data from every database, file, and API.
https://datastation.multiprocess.io
Other
2.9k stars 112 forks source link

Cannot use non-default database ports eg 1522 for Oracle #272

Closed oldbakery closed 2 years ago

oldbakery commented 2 years ago

In many organisations the use of standard ports for databases is forbidden. For example, port 1521 for an Oracle database. The option to specify the port number must be included

eatonphil commented 2 years ago

Did you try adding the port to the address with a colon?

Address: localhost:1521

oldbakery commented 2 years ago

Hi Phil

Thanks for the reply. My SQL Server and MySQL connections work fine, but the Oracle connection is problematic.

Yes, I'm using the port in the host field eg [image: image.png]

Here's the error message: [image: image.png]

And here are the Oracle connection settings defined in DBeaver for comparison. These connect successfully. [image: image.png]

Hope this helps. I see a lot of potential in the product, keep up the good work :)

Cheers Simon

On Wed, Jun 22, 2022 at 6:09 PM Phil Eaton @.***> wrote:

Did you try adding the port to the address with a colon?

Address: localhost:1521

— Reply to this email directly, view it on GitHub https://github.com/multiprocessio/datastation/issues/272#issuecomment-1163394613, or unsubscribe https://github.com/notifications/unsubscribe-auth/AV6HO3ZWQTHPEJ3R6X5OLJLVQNCDNANCNFSM5ZQOKKCQ . You are receiving this because you authored the thread.Message ID: @.***>

--

Simon Ambridge

Solution Engineer, EMEA

https://www.facebook.com/streamsets/ https://twitter.com/streamsets https://www.linkedin.com/company/streamsets/

MOBILE: +44 07507 215313

EMAIL: @. @.>

https://www.dataopssummit-sf.com/

eatonphil commented 2 years ago

Got it, thanks for clarifying! Yes this is a bug. But I didn't receive the photos it looked like you tried to send. image

oldbakery commented 2 years ago

Hi Phil would you like me to send images to a different address?

Simon

On Thu, 23 Jun 2022 at 13:08, Phil Eaton @.***> wrote:

Got it, thanks for clarifying! Yes this is a bug. But I didn't receive the photos it looked like you tried to send. [image: image] https://user-images.githubusercontent.com/3925912/175295141-b066e370-ea76-4824-99c0-3dc37c4e5212.png

— Reply to this email directly, view it on GitHub https://github.com/multiprocessio/datastation/issues/272#issuecomment-1164327645, or unsubscribe https://github.com/notifications/unsubscribe-auth/AV6HO366GQCFOR4TE7QWVNLVQRHVTANCNFSM5ZQOKKCQ . You are receiving this because you authored the thread.Message ID: @.***>

--

Simon Ambridge

Solution Engineer, EMEA

https://www.facebook.com/streamsets/ https://twitter.com/streamsets https://www.linkedin.com/company/streamsets/

MOBILE: +44 07507 215313

EMAIL: @. @.>

https://www.dataopssummit-sf.com/

eatonphil commented 2 years ago

I haven't been able to replicate it but it may have been fixed already. I added tests to make sure it works in #280.

So try again in the next release and if there's still an issue please include screenshots. Thanks!