ODBC

Started by MarcusH, May 26, 2021, 02:42:26 PM

Previous topic - Next topic

MarcusH

Hi,

I am moving server from windows to linux since i want to run it in docker.
I managed to create a docker image with ODBC driver and and Linux ODBC Driver 17 for SQL Server from Microsoft and i am having problems connecting to database.
I have deduced that my problem is that you cannot have user/password in the DSN setting you can only send password in connection string, the only solution other then this is setting up Kerberos which i have no experience of.

So my question is it in any way possible to set username/password in netxms that is sent to ODBC or is it 100% relying on ODBC internal mechanics?

I would really like to use MS SQL since that is what i have most experience with and already have good backup and maintenance on it.

MarcusH

of course like 99% of the time when you post question you find the answer.
I read the doumentation wrong "(not used by ODBC driver)." is only DBName not DBPassword like i first thought, moved password from odbc to netxmsd.conf and now it works.