Highlight a table in the Schema Browser while in Tree-view mode, then press F3 to perform a quick browse of the data, and the error below appears.
Error:
mCols: Cannot perform this operation on a closed dataset.
Reset your Toad user files to resolve this issue. Here are the reset steps:
NOTE:
- Make sure you have your Toad Authorization Key and Site Message.
- If some of your folders / directories are hidden, open a Windows Explorer window | go to Tools Menu | Folder Options | View Tab | click “Show hidden files and folders” | click Apply | then click OK.
1) Fully Exit Toad
2) Go to:
XP:
C:\Documents and Settings\\Application Data\Quest Software\
-OR-
Vista or 7:
C:\Users\\AppData\Roaming\Quest Software\
3) Rename the "Toad for Oracle" folder to "Toad for Oracle OLD”.
4) Start Toad 12.x, and re-test the issue.
NOTE: Try not to leave Toad running overnight or force close Toad as these can cause user files corruption.
To transfer back your Connections History, follow the steps below:
NOTE: Re-test the issue first before moving over your Connections History to make sure the issue is not coming from the connections files.
1) Fully Exit Toad (make sure you have checked the “Save Passwords” box in the login screen, if you prefer this).
2) Go to ‘Toad for Oracle OLD’ folder you renamed earlier:
XP:
C:\Documents and Settings\\Application Data\Quest Software\Toad for Oracle OLD\12.x\User Files\
-OR-
Vista or 7:
C:\Users\\AppData\Roaming\Quest Software\Toad for Oracle OLD\12.x\User Files\
3) Copy both the CONNECTIONS.INI and the CONNECTIONPWDS.INI files. Make a BACKUP of these files, just in case of errors. NOTE: The saved connections passwords are not transferable between computers or different Windows users.
4) Paste the files in the corresponding ‘newly generated’ “Toad for Oracle\12.x\User Files\” folder.
5) Start Toad and you should now see your Connections History in the log in screen.
