SQL Loader : User credential error

Hi Experts,

I have configured SQL loader with https data file url. Configured Self signed certificate and installed IIS server for the same tried placing file in c:\inetpub\wwwroot also in D drive but getting error:

I have put the data file url as: jdbc:csv:https://IQServer_ip/file path.
In the query string, I have provided a query like this:
select * from csv_filename

But when I am trying to test connection, I am getting this error:
[ ConnectionFailedException ] [ Possible suggestions ] Verify that Connection User and Password are correct. [ Error details ] Error occurred while establishing the connection with Data File during test configuration operation. Failed to load table csv_filename: java.io.IOException.

I have added the user and given required permissions.

Any idea what could be the cause of this error?
I have tried multiple things. Nothing seems working.

Hey @ashwinVnair ,

is it JDBC VA connection? If yes, could you please confirm nc -zw -5 hostname port is successful?

1 Like