Toad World® Forums

TDP 4.3 export linked query to excel


#1

I know that there are several topic also concerning related problems but none of these contain work-around or establish a bug:

Using TDP 4.3.0.718 (64 bit) I created a query against Oracle, I use the OraClient12Home1 (64 bit) client (with the same 'Oracle in OraClient12Home1 (64)" under the advanced tab as ODBC Driver choice). On the excel side I have the same ODBC driver installed. Creating a connection and copy-paste a query from excel does work.

The Error message for the export to excel with query is:

10:17:36 AM Thread (12) Export Started [3/7/2018 10:17:36 AM]
10:17:36 AM Thread (12) Export using connection: BAN2.WORLD (AL2329), AL2329
10:17:36 AM Thread (12) Export using connection: BAN2.WORLD (AL2329), AL2329
10:17:36 AM Thread (12) Export Wizard: Building object list
10:17:36 AM Thread (12) Exporting Data (1 of 1)
10:17:36 AM Thread (12) Object SQL Query started.
10:17:36 AM Thread (40) DoneReadTreadWriter
10:17:37 AM Thread (40) User cancelled
10:17:37 AM Thread (40) DoneReadThreadWriter finally - adapter null
10:17:37 AM Thread (12) Object SQL Query finished with error: Unable to execute linked query.
Excel returned the message: “General ODBC Error”
Error code: 800A03EC
10:17:37 AM Thread (12) at Quest.Toad.ImportExport.Writers.WriterExcelInstance.WriteHeaderInternalQuery()
at Quest.Toad.ImportExport.Writers.WriterExcelInstance.WriteHeader(Object tableObject)
at Quest.Toad.ImportExport.ExportObjectData.DoneReadThreadWriter()
10:17:43 AM Thread (12) Export Finished [3/7/2018 10:17:43 AM]

10:17:43 AM Thread (12) Export time = 00:00:06.8374218


#2

Hi Arjen,

thank you for your bug report.

I was able to reproduce the behavior described by you, so i have created task for fixing it: QAT-12500

With regards Jakub K.