This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
If you are using a User or System DSN for the connection, are you pointing to the correct database name in the ODBC DSN settings? Which driver are you using? The supported versions are stated in the help documentation.
I did partially solve that problem, but there seems to be an extended problem.
I need to connect to 2 different DB2 Databases (say A & B), structured similarly. I'm currently using a System DSN for the connection and it connects only to a single database (Connects only to A, B doesn't connect irrespective if A is / isn't connected) . I use the same method for B, but it doesn't work. To be more specific, I can see the correct table in the input/import option, but when I run it, I see a "no columns returned".
When you try to connect to Database "B", are you using the same System DSN as Database "A" and just changing the database name or are you creating an entirely new DSN? It's possible that there are different/ additional CLI parameters that would need to be set under the advanced settings portion of the driver for the other database to work correctly. Also, do you know that you have the same permissions for both databases?