I have a table of 6MB with 50 values in the pivot-values leading to 50 columns in the pivoted table. That one works nicely.
I have another much larger table with 170MB and 121 columns. When creating the pivoted table I get an error:
SQL Fehler (1939): Engine CONNECT failed to discover table `abc`.`def` with 'CREATE TABLE whatever ...
The server runs on Win7 64Bit version 10.0.13
How can I create the pivoted table of the large table?
Answer Answered by daniel-black in this comment.
the error sounds more like the table name is incorrect.
Alternately try the tracing documented here: loading-the-connect-storage-engine