SQL and other databases
SQL, Oracle and most other database connections require the user to provide the connection string. AnyLabels offers a generic connection string that generally requires the user to replace MyServer with the name of the target server, and MyDatabase with the name of the target database.
If a user id is entered in the User ID box then the string
;id=******; password=*****
(where the ***** represent the text typed into the User ID and Password boxes) is added to the connection string. If a different format is required by a specific database, the User ID box should be left empty and the appropriate credential string included in the Connection string.
Once the Connection string is complete the connection may be tested by pushing the Test connection button.
Again the appropriate string for selecting data from the database should be entered before pushing the OK button.