Shared Workbook files with auto-connections failing

Toad Data Point
1

In testing we have found on Toad Workbook 5.0.6.97 when a workbook file is shared with a connection set to auto-connect it is corrupting the Transform and Cleanse module. If a file of this type is shared the receiving user is able to set the query connection to their personal connection with no issues. When the first Transform and Cleanse is reached in the process the system is prompting for the auto-connection login information in order to complete the process. Since the receiving user does not have this information they must cancel past this or try to enter their login information. The outcome is this Transform and Cleanse ends up being blank with no data passed in. Due to this subsequent steps do not process correctly. Thus far we have seen this behavior with two workbooks.

As a workaround we have found if we do not use auto-connect connections there does not appear to be an issue with sharing workbooks and the new connection is easily selected and used. When we do have a workbook that is shared with auto-connection and the author is not available to share a new copy we must recreate all the steps starting with the first Transform and Cleanse and save the file with the new connection on the destination system.

While this issue is not critical as we have an effective workaround it is one that I wanted to get out there on the forum.

2 Likes
2

MUCH appreciate you bringing this to our attention. Our Dev team will surely take a look at this. You may be asked to furnish some details, especially if we can't re-create the issue.

3

Hi Gary, I was wondering if this issue was solved, and how to disable or enable auto-connect since I am unsure what that means. My co-worker and I are having a similar problem when sharing the workbook and do not understand how to do the workaround.

5

I can't produce the issue in TDP 5.4, so maybe it has been fixed. If not, would one of you please open a Support ticket, as that helps our Dev team document steps to re-produce the issue, track progress, and prioritize.

BTW, "auto-connect" here should mean "Connect at Startup" per snap below... if otherwise, we'll need rvaldex3 to set us straight...

image
image898×809 90.2 KB

6

Thank you for the confirmation! I have already tried that, and I would go to open a support ticket, but it says my service trial has ended for that support type.

7

Also - we are working on Toad Data Point Workbook sharing issues that we have captured from our user base in Toad Data Point 5.5, which is due out first week of October, so you may want to wait for that release to double check your issue.