This string works in our environment:
DRIVER={Splunk ODBC Driver};PORT=8089;PWD=myPW;SERVER=myServer;UID=myLocalUser;URL=https://myServer:8089;VERIFYSERVERSSLCERTIFICATE=N;
A great tool for building this is WinSQL. A free download is available, for debugging sql connections.
To use the tool, install the Splunk ODBC driver.
In the tool, create a new connection of type Connection String. Enter "DRIVER={Splunk ODBC Driver};" in the string field, and click OK. The tool then prompts for the rest of your connection settings. When complete, the tool writes the connection string, as above.
... View more