We use the LC Connection to connect to the SQL Database. Its a client application.
Do we need to create the Data Sources ODBC in the machines of the users uses that application or by default the LC Connection will use the drivers installed in the users machine and try to connect with the credentials provided in the application.
If we have any link on how does the LC Connection works with the ODBC would be helpful.
I am prettry sure you don’t need to setup a dsn on all the pcs that will be running the agent. Why don’t you write a quick agent that will access the sql table to test it out.