Hi All,
i have a workflow which uses a dynamic input In-DB tool to accept the query and the connection supplied to to it. I am making a dynamic query in a formula tool and that works perfectly. The connection that I am supplying to it also works perfectly on my laptop. This connection was created in accordance with the instructions supplied here. I save the indbc file on my laptop, give the file path to the formula tool which eventually feeds the dynamic input In-DB tool and everything works. The issue comes when:
I try to generalise the in-db connection path. eg. make it something like "File:\in_db_connection.indbc" or various versions of that as instructed here.
This is when in-db tool gives up.
It is very important for me to generalize it as I want to publish on the gallery where I don't really know the path where the indbc file will be saved.
are there any alternatives to this approach?
