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

Comments

Comments loading...