A better error for a wrong password

[PietrH]

Currently if you provide the wrong password to connect_to_etn() the following error is returned:

Error: nanodbc/nanodbc.cpp:1021: 00000: [unixODBC]fe_sendauth: no password supplied
 
In addition: Warning message:
In readLines(file, skipNul = TRUE) :
 

 Error: nanodbc/nanodbc.cpp:1021: 00000: [unixODBC]fe_sendauth: no password supplied

Is there a way we can intercept this ODBC error and produce our own?

[PietrH]

Currently the client package doesn't pass along error messages, so I'm making this issue for future reference

[PietrH]

The client now passes errors: inbo/etn@1c24bfc

[PietrH]

This error message needs to be generated on the etnservice side, specifically by connect to etn:

This line is repeated in all functions: connection <- connect_to_etn(credentials$username, credentials$password), an additional error message might be useful when either password or username is omitted, although that should never happen in etn because they are always both fetched by get_credentials()

When etnservice is used as a dependency for local database connections, this'll also insure that the error message is the same regardless if you use a local database connection or the api.

[PietrH]

Let's add a function that the client package can use to see if the provided credentials are correct, then the client can provide an error / not cache the credentials when the wrong credentials are provided.