Greetings! I have my SQL commands set to use osql.exe, and I have set up a System DSN and a File DSN in Admin Tools for the connection I wish to use. However, I cannot figure out how to make Automise use the DSN I have set up, and when I run my project, I get a “[ODBC Driver Manager] Data source name not found and no default driver specified” error.
I found the settings where the oSQL location is set, but I have not found anywhere that I can tell Automise what DSN to use. What am I missing?
Thanks,
Jonathan
Currently the action only allows for direct connection to a database server. Use of System DSN and File DSN isn’t currently possibly through the MSSQL Execute SQL action.
With this said you can use an Execute Program Action to call osql.exe directly with the -D option for the DSN in question. Remember to pass the username and password if required.