Have you successfully tested your connection string before? Here are some ideas on how to do that: https://stackoverflow.com/questions/3910364/quick-ways-to-test-ole-db-connection-string
- The tools you can use depend on the system/OS you are on.
- The connection itself is standardized, or there might be minor differences on what connection strings different systems will accept.
- The actual content (e.g. SQL query) will definitely need to be specific to the type of system you connect to (DB2 vs. Oracle vs. MSSQL).
If these testing methods fail, it is likely that your connection string is the problem. In such cases you could try to google for specific system's connection string syntax, e.g.: https://www.c-sharpcorner.com/uploadfile/nipuntomar/connection-strings-for-ibm-db2/