Importing data: Host unreachable

InnaRafikova
Padawan

Hi dear experts!

I'm trying to import data from MS SQL Server 2008 to my Exasol Community Edition database.

But when I'm trying to connect Exasol to MS SQL, I receive this message:

InnaRafikova_1-1612963958369.png

"[SELECT - 0 row(s), 35.467 secs] [Error Code: 0, SQL State: ETL-5] JDBC-Client-Error: Connecting to 'jdbc:jtds:sqlserver://192.168.1.*;databaseName=***' as user='***' failed: Network error IOException: No route to host (Host unreachable) (Session: 1691325693886070784)"

 

I work on a virtual machine, and I can connect to MS SQL database through DbVisualizer from this machine.

Exasol CE is running on this virtual machine (so it is VM inside VM), and it can't connect to this MS SQL database.

 

What may be the cause?

 

Thank you, Inna.

 
1 REPLY 1

exa-Uwe
Moderator
Moderator

Hi Inna,

that you can connect to the MS SQL DB from DbVisualizer doesn't mean the Exasol DB can.

See if this helps: https://community.exasol.com/t5/training-forum/enable-network-access-from-community-edition-in-virtu...

Best regards

Uwe