Set up an database connection
This section will show how to set a database connection in RoboIntern.
| 1. In the main window click 'File'->'Manage ODBC Connections': |  |
| 2. Click the '+' button to add a new connection: |  |
| 3. Fill out the details of the database connection as shown. For Access databases use the below connection string: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myAccessDB.accdb Whereby replace the file path with the path of your DB. For Oracle try DSN=myDsn; Uid=myUsername; Pwd=myPassword; Whereby add the DSN name, your username and password. For other DBs visit connectionstrings.com Important! For Access automation you need to install the corresponding version of the Access Database Engine and use also the right RoboIntern version (32bit or 64bit): https://www.microsoft.com/en-us/download/details.aspx?id=13255 |
 |
| 4. Once returned to the previous window the newly added database will show up in the list. Click the 'Save changes' button to finalize the setup: |  |
And that's it!
For more advanced tasks please see other sections of the how-to guide.
Happy automation!